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