Identify the location of log and trace files on any Oracle server
Objective
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 2.3.3.0.0 - Production on 05-APR-9
9 15:42:31
Copyright (c) Oracle Corporation 1994. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=fred))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 2.3.3.0.
0 - Production
Start Date 22-MAR-99 14:40:16
Uptime 14 days 0 hr. 0 min. 15 sec
Trace Level off
Security OFF
SNMP ON
Listener Parameter File /etc/listener.ora
Listener Log File /ora8/home/8.0.5/network/log/listener.log
Services Summary...
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.
Log Location Trace Files - Exercise
Before moving on to the next lesson, click the Exercise button to evaluate a situation requiring the use of the log and trace parameters.
Log Location Trace Files - Exercise
