RelationalDBDesignRelationalDBDesign


Logging | Tracing   « Prev  Next »
Lesson 7 Identify the location of log and trace files on any Oracle server
ObjectiveFind 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