How to configure Shared server mode in an oracle database?

Below are the list of initialization parameters that needs to be added/changed to the SPfile,  Server parameter file to configure shared server mode on oracle database.

Using command prompt, Go to oracle home , D:\app\Admin\virtual\virtual\product\12.2.0\dbhome_1\bin

C:\Users\Admin>cd\

C:\>cd D:\app\Admin\virtual\virtual\product\12.2.0\dbhome_1\bin

D:\app\Admin\virtual\virtual\product\12.2.0\dbhome_1\bin > sqlplus/nolog
 SQL*Plus: Release 12.2.0.1.0 Production on Fri Jan 21 08:08:20 2022
 Copyright (c) 1982, 2016, Oracle. All rights reserved
 SQL > conn sys/password @servicename
 SQL> alter system set shared_servers=5;
 SQL>alter system set max_dispatchers=10 scope=spfile;
 SQL>alter system set shared_server_sessions=5 scope=spfile;
 SQL>alter system set circuits=300 scope=spfile;
 SQL >alter system set dispatchers="(protocol=TCP)(dispatchers=3)(connections=100)" scope=spfile;

And Client tnsnames.ora file should look like

DW=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=DW-server)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=dw.server.com)
(SERVER=shared)))

Bounce the database

To confirm Shared server  Connection use below SQL query

SQL >SELECT name, status, messages,idle,busy,bytes,breakes from v$dispatcher;
SQL>select username,server from v$session;