SRDC - Data Collection for Listener Hang (Doc ID 1677251.1)

 1. Does the server where the listener runs respond to operating system commands?

 

2. Collect the listener log in text format covering the time of the error:

•         Pre-11g:

Default location of the listener log is $ORACLE_HOME/network/log on UNIX and $ORACLE_HOME\network\log on Windows.  Default file name is listener.log.

•         11g Onwards:

• • If ADR is enabled, default location of the listener log in text format is $ORACLE_BASE/diag/tnslsnr/<hostname>/listener/trace on UNIX and $ORACLE_BASE\diag\tnslsnr\<hostname>\listener\trace on Windows. Default file name is listener.log.

Default location of the listener log in xml format is $ORACLE_BASE/diag/tnslsnr/<hostname>/listener/alert on UNIX and $ORACLE_BASE\diag\tnslsnr\<hostname>\listener\alert on Windows. Default file name is log.xml.

If the listener log is not available as text format, collect the listener log in xml format.

• • If ADR is disabled, the listener log is default located under $ORACLE_HOME/network/log on Unix and $ORACLE_HOME\network\log on Windows. Default file name is listener.log.

The location of the listener log can also be also determined by checking the section 'Listener Log File' from 'lsnrctl status' output.

 

3. Which is the size of the listener log?

 

4. Log on the machine where the listener runs and collect the output from the command below. Does the command hang?

  lsnrctl status

 

If the underlying platform is Unix, see additional steps below:

 

5. Log on the machine where the listener runs and collect the output from the following command:

ps –ef | grep tnslsnr

 

6. Log on the machine where the listener runs and collect stack traces of the hung listener process by using the commands below.  Provide 3 stack traces - one about every 30 seconds:

-- Get listener pid:

ps -ef | grep tnslsnr

 

-- Collect stack trace. The command may vary based on Operating System:

Linux: pstack <listener_pid>

Solaris: pstack <listener_pid>

AIX (pre 5.2): Type dbx -a <listener_pid> . At the next prompt, type 'where'.

AIX (5.2 and higher): procstack <listener_pid>

HP-UX, Linux: Type gdb $ORACLE_HOME/bin/tnslsnr <listener_pid>. At the next prompt, type 'where'.

 

7. Log on the machine where the listener runs and collect OS tracing for the listener process:

-- Get listener pid:

ps -ef | grep tnslsnr

 

-- Enable OS trace:

Solaris,AIX: truss -aefdDo /tmp/truss-lsnr.log -p <PID_of_listener>
Linux: strace -frT -o /tmp/strace-lsnr.log -p <PID_of_listener> 
HP: tusc -aef -o /tmp/tusc-lsnr.log -T "%H%M%S" -p <PID_of_listener>

 

8. Log on the machine where the listener runs and collect the output from 'top' command at the time of the listener hang.

 

9. Copy the answers from questions and the output from commands into a text file.

 

10. Compress (in .zip or .tar.gz format) and upload all the data.