Sunday, 16 March 2014

Path for TNS and listener file location

How to know TNS file and listener file path location?

1.Generally the path for listener and TNS file location in UNIX is $ORACLE_HOME/network/admin
2.but in some operating systems like Solaris operating system it can be /var/opt/oracle
3.else we can find  using $TNS_ADMIN variable.
4.in lsnrctl status result we will find the paths easily as
Listener Parameter File   /u01/app/11.2.0/grid2/network/admin/listener.ora
Listener Log File            /u01/app/oracle/diag/tnslsnr/amaze/listener/alert/log.xml


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