Converting database mode to shared from dedicated & vice versa 2011-06-07

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.