Sunday, 16 March 2014

disabling Shared Server(MTS) architecture

How to disable a Shared (MTS) Server Architecture?

Follow the below simple steps to disable multi thread server architecture
1.Remove the  DISPATCHERS parameter in your pfile/spfile
2.Convert (SERVER=DEDICATED) instead of (SERVER=MTS) in tnsnames.ora file in $ORACLE_HOME/network/admin location
3.Restart the listener of database in order to effect the changes.


we can see the change in architecture in alertlog of database.



Cheers......!!!!!!

No comments:

ORA-600 [kwqitnmphe:ltbagi], [1], [0] reported in the alert log file.

ORA-00600 [kwqitnmphe:ltbagi] Cause: This issue arises in 12.1.0.2. The error occurs because there are still Historical Messages without...