Sunday, 16 March 2014

How to know/check our database server is configured as Dedicated server ?

How to know/check our database server is configured as Dedicated server?

Follow the below steps to check whether database is configured as Dedicated server or not.
1. Select username, server from v$session ;
2. Select * from v$dispatcher;
3. Go to $ORACLE_HOME/dbs and open init.ora(pfile/spfile) and find the variable DISPATCHERS 
4. Finally open the tnsnames.ora file and find parameters of each database. This will forcibly make db to run in dedicated server mode.

Results:
1. Select username, server from v$session ;
USERNAME                       SERVER
------------------------------ ---------
USER3                           DEDICATED
USER1                           DEDICATED
USER2                           DEDICATED
USER1                           DEDICATED
USER1                           DEDICATED
2. Select * from v$dispatcher;
no rows selected
3. DISPATCHERS = '(ADDRESS=(PROTOCOL=TCP)(HOST=accountmgt.tntt.com)(PORT=1524))'
4.database_1 = (description=(address=(host=amaze.tntt.com)(protocol=tcp)(port=1521))(connect_data=(sid=database_1)(server=dedicated)))

Conclusion:
Even though/not the output from 2,3 indicate MTS server config params, we should consider output of 1,4 and can say that database is in dedicated server mode. Why because server=dedicated param indicate the database to be in dedicated mode forcibly ignoring rest of config setting.

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...