How to convert MTS to dedicated db
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;
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.
I'm no expert on this, but what about changing the listener config?
put server = DEDICATED in the tnsnames file of the client - job done
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;
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;
Thanks for taking your time to offer tips.
Click Here to Expand Forum to Full Width