listener.ora Trace Parameters

오라클에 접속을 시도하는 외부 IP를 확인하기 위해,,
리스너 파일 마지막 라인에 아래와 같이 trace 환경을 추가하였습니다.
로그 파일이 엄청 증가하지 않도록,, 확인 후 바로 주석처리 해주는 센스!!

###### LISTENER TRACE ######
TRACE_LEVEL_LISTENER=16
TRACE_FILE_LISTENER=LISTENER.TRC
TRACE_DIRECTORY_LISTENER=/home/***/
TRACE_TIMESTAMP_LISTENER=ON

trace 파라미터에 대한 자세한 설명은 오라클 사이트에서 제공하는 아래 내용을 참고하세요.





출처: http://download.oracle.com/docs/cd/B28359_01/network.111/b28316/troublestng.htm#BABFGDFJ



Table 16-21 listener.ora Trace Parameters

# TRACE_LEVEL_listener_name

Specifies the level of detail the trace facility records for the listener.
The trace level value can either be a value within the range of 0 (zero) to 16 (where 0 is no tracing and 16 represents the maximum amount of tracing) or a value of off, admin, user, or support.

-off (equivalent to 0) provides no tracing
-user (equivalent to 4) traces to identify user-induced error conditions
-admin (equivalent to 6) traces to identify installation-specific problems
-support (equivalent to 16) provides trace information for troubleshooting information for Oracle Support Services

 

# TRACE_DIRECTORY_listener_name
   TRACE_FILE_listener_name

Establishes the destination directory and file for the trace file. By default the directory is $ORACLE_HOME/network/trace on UNIX and %ORACLE_HOME%\network\trace on Windows, and the file name is listener.trc.

# TRACE_FILELEN_listener_name

Specifies the size of the listener trace files in kilobytes (KB). When the size is met, the trace information is written to the next file. The number of files is specified with the TRACE_FILENO_listener_name parameter

# TRACE_FILENO_listener_name

Specifies the number of trace files for listener tracing. When this parameter is set along with the TRACE_FILELEN_listener_name parameter, trace files are used in a cyclical fashion. The first file is filled first, then the second file, and so on. When the last file has been filled, the first file is re-used, and so on.

The trace file names are distinguished from one another by their sequence number. For example, if the default trace file of listener.trc is used, and this parameter is set to 3, the trace files would be named listener1.trc, listener2.trc and listener3.trc.

In addition, trace events in the trace files are preceded by the sequence number of the file.

# TRACE_TIMESTAMP_listener_name

Adds a time stamp in the form of dd-mon-yyyy hh:mi:ss:mil to every trace event in the listener trace file.