How to convert MTS to dedicated db
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to convert MTS to dedicated db

  1. #1
    Join Date
    Jul 2000
    Location
    Arlington Heights, Illinois, Usa
    Posts
    14

    How to convert MTS to dedicated db

    Hi,

    I would like to move a production db running on Oracle9i from MTS to dedicated since
    1. Hit with an Oracle Bug and as per oracle support
    2. No. of user session is only around 30+ anytime

    This is what I did:

    sql> alter system set dispatchers='' scope = both;
    ORA-2065 alter system not allowed.
    sql> alter system set shared_servers =0;
    system altered

    My understanding is if you set the shared_servers = 0 should disable MTS. But it did not happen. Also, Oracle documentation states to use the above commands and I still get the error.

    Any suggestions?

    Thanks
    Murali
    Murali

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    I'm no expert on this, but what about changing the listener config?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    put server = DEDICATED in the tnsnames file of the client - job done

  4. #4
    Join Date
    Jul 2000
    Location
    Arlington Heights, Illinois, Usa
    Posts
    14
    Thanks. In the meantime, I was playing in my test server and here is what I found.

    As per oracle support, you can identify if MTS is down by checking v$dispatcher and v$shared_server and both should return no rows.

    Here is what I did.

    alter system set dispatcher='(PROTOCOL=TCP)(DISPATCHERS=0)' scope= both;
    System altered (I was really surprised since eventhough it
    looks elementary, the docs were wrong).
    Alter system set shared_servers = 0;
    system altered

    select * from v$dispatcher;
    no rows returned
    select * from v$shared_server;
    initially returned rows and later if you try again a few time, it also says "no rows returned".

    To test whether it takes dedicated connection only,
    disconnected from sql, connected to sql
    select osuser,username, server from v$session
    where username is not null;
    SYS DEDICATED
    SYSTEM DEDICATED

    Thanks for taking your time to offer tips.

    Much appreciated.

    Murali
    Murali

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width