Procedure for configuring a Shared Server in Oracle

Procedure for configuring a Shared Server in Oracle

Oracle configuration sharing Server:
1. Configure the second listener
Netca/manual
Manual: listener. ora
LSNR_2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = Demon) (PORT = 1526 ))
)
)

2. start LSR_2 to listen for lsnrctl start lsnr_2
3. Configure tnsnames. ora
Add:

LSNR_2 = (ADDRESS = (PROTOCOL = TCP) (HOST = Demon) (PORT = 1526 ))

ORCL_1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = Demon) (PORT = 1526 ))
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = ORCL)
)
)

4. Register LSNR_2 listeners
Show parameter service_names
Show parameter local_listener
Alter system set local_listener = 'lsnr _ 2 ';
Alter system register;

Note: As of now, it is not very different from creating a second listener, but it only changes the SERVER = SHARED parameter;
You can also modify the Database Service name. A database can have multiple service names:
Show parameter service_names
Alter system set service_name = "...... ";
Alter system set service_names = ORCL, EG;
5. Configure Shared Server Parameters
Show parameter shared; shared process
Show parameter dispatch; scheduling Parameters
6. Generate pfile and close the database
Create pfile from spfile;
Shutdown immediate
7. Modify the parameter file
$ ORACLE_HOME/dbs/
Ls-ctl
Vi initORCL. ora
Add parameters to the pfile parameter file:
 
Shared_servers = 10
Max_shared_servers = 30
Shared_server_session= 200
Dispatchers = "(PROTOCOL = TCP) (DISPATCHERS = 3)"/network PROTOCOL and scheduler Parameters
Max_dispatchers = 10

8. Generate spfle and start the database
Create spfile from pfile;
Startup
9. View related parameters
Show parameter shared; shared process
Show parameter dispatch; scheduling Parameters
10. Test
Sqlplus hr/hr @ ORCL_1
View:
Select server from v $ session;/grant permissions

Configure an Oracle Shared Server