1. Get unlimited access to documents by upgrading to Premium Membership.
sangamsuman

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

Converting database mode to shared from dedicated & vice versa

  1. sangamsuman
    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.