1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!
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.