

If you want to review the log file, you can display it with tail command as follows. u01/app/oracle/diag/tnslsnr/msdbdbadm01/listener/alert rw-r- 1 oracle oinstall 5.0M Jul 16 15:07 log.xml When i go to /u01/app/oracle/diag/tnslsnr/msdbdbadm01/listener/alert directory, you can see the Listener log files ( Archived ) as follows. Listener Log File /u01/app/oracle/diag/tnslsnr/msdbdbadm01/listener/alert/log.xml

Listener Parameter File /u01/app/12.1.0.2/grid/network/admin/listener.ora I have marked the listener log file and parameter file locations above with RED and BLUE Color. Instance "msdb1", status READY, has 1 handler(s) for this service. Instance "REPDB1", status READY, has 1 handler(s) for this service. Instance "FLEXDB1", status READY, has 1 handler(s) for this service. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=)(PORT=5501))(Security=(my_wallet_directory=/u01/app/oracle/product/12.1.0.2/dbhome_1/admin/REPDB/xdb_wallet))(Presentation=HTTP)(Session=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.1.0.2/dbhome_1/admin/msdb/xdb_wallet))(Presentation=HTTP)(Session=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) Listener Parameter File /u01/app/12.1.0.2/grid/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/msdbdbadm01/listener/alert/log.xml Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production All rights reserved.Ĭonnecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) If you want to learn where listener log file location is, execute the lsnrctl status command as follows. Listener log file locations are very important for us. I will explain Listener Log file location in Oracle in this post.
