Change Oracle from "Dedicated" Server to "Shared" Server

How to set the oracle from "Dedicated" to "Shared" server? What are all parameters needs to set to change the Oracle from "Dedicated" Server to "Shared" Server?

mah_mca
Profile Answers by mah_mca Questions by mah_mca
Feb 12th, 2008
1
5059

Questions by mah_mca

Oracle

Answer

Showing Answers 1 - 1 of 1 Answers

raj_java_j2ee
Profile Answers by raj_java_j2ee

May 12th, 2009

1.To change from dedicated server to shared server add the following initialization parameters in the parameter file.

dispatchers='(protocol=TCP)(disp=5)'
max_dispatchers=150
shared_servers=5
max_shared_servers=100

2.shutdown and restart the database

3.To check if the listener is creating shared server connection use the following command
c:>lsnrctl services

4.client side changes.
change the parameter SERVER = SHARED in tnsnames.ora file

SERVICENAME =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP ADDRESS)(PORT = 1521))
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = SERVICENAME )
)
)