Identify the location of log and trace files on any Oracle server
Find the location of log and trace files on an Oracle server
Identify location of log trace files
The easiest way to see the location of server-side log and trace files is to issue the listener control status command.
View the Code below to see an example. Here you see the specific directory and file Oracle has located for the listener log file.
dilbert > lsnrctl stat
LSNRCTL for IBM/AIX RISC System/6000: Version 220.127.116.11.0 - Production on 05-APR-9
Copyright (c) Oracle Corporation 1994. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=fred))
STATUS of the LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 18.104.22.168.
0 - Production
Start Date 22-MAR-99 14:40:16
Uptime 14 days 0 hr. 0 min. 15 sec
Trace Level off
Listener Parameter File /etc/listener.ora
Listener Log File /ora8/home/8.0.5/network/log/listener.log
lamp has 1 service handler(s)
i8itall has 1 service handler(s)
To view client parameters, you must display the local sqlnet.ora file to see the locations of the log and trace files.
Now that you understand the basic files locations and purposes, let’s look at the uses of these files.