CONVERTING DATABASE MODE TO SHARED FROM DEDICATED & VICE VERSA
1. Stop the listener
2. Change the listener.ora file as follows
LISTENER=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME )(PORT = 1532))
)
SID_LIST_LISTENER=
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ICCOMSCO)
(ORACLE_HOME = /ICCOMSoracle/oracle/ora92)
(SID_NAME = ICCOMSCO)
(SERVER = SHARED)
)
)
3. Shutdown the database
4. Add or edit following parameters in init file
*.dispatchers='(protocol=TCP)(disp=5)'
*.shared_servers=60
*.max_dispatchers=10
*.max_shared_servers=150
The values disp=5 and shared_server=60 depends on client’s need
5. Start the listener
6. Start the database
After starting the database if you check the status of listener you will find
Instance "ICCOMSCO", status READY, has 6 handler(s) for this service...
7. To revert back follow the same process but instead of SHARED write DEDICATED & remove those 4 parameters from init file.
-
Get unlimited access to documents by upgrading to Premium Membership.
Converting database mode to shared from dedicated & vice versa 2011-06-07
Converting database mode to shared from dedicated & vice versa