-
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
-
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;
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|