Listener Registration Dump

To dump listener registrations use

LISTENER_REGISTRATION <LEVEL>

For example using ALTER SESSION:

ALTER SESSION SET EVENTS 'immediate listener_registration (1)';

Alternatively using ORADEBUG:

ORADEBUG DUMP LISTENER_REGISTRATION 1

The dump writes an information message to the session trace file.

For example:

*** 2015-08-28 22:39:00.827
Processing Oradebug command 'dump listener_registration 1'
Listener registration dumped to PMON's trace file:

*** 2015-08-28 22:39:02.860
  /u01/app/oracle/diag/rdbms/test/TEST/trace/TEST_pmon_2239.trc

*** 2015-08-28 22:39:02.860
Oradebug command 'dump listener_registration 1' console output: 

The listener registration trace is written to the PMON trace file as shown above

For example for level 1:

------------------------------
Start Registration Information
------------------------------

Last update: 481863694 (248 seconds ago)
Flag: 0x4, 0x0
State: succ=1, wait=0, fail=0

Listeners:
  0 - (ADDRESS=(PROTOCOL=TCP)(HOST=vm3.juliandyke.com)(PORT=1521))
       state=1, err=0
       nse[0]=0, nse[1]=0, nte[0]=0, nte[1]=0, nte[2]=0
       ncre=0

----------------------------
End Registration Information
----------------------------

For level 2 (and above) additional information is written to the PMON trace file.

For example:

------------------------------
Start Registration Information
------------------------------

Last update: 481931977 (127 seconds ago)
Flag: 0x4, 0x0
State: succ=1, wait=0, fail=0

Listeners:
  0 - (ADDRESS=(PROTOCOL=TCP)(HOST=vm3.juliandyke.com)(PORT=1521))
       state=1, err=0
       nse[0]=0, nse[1]=0, nte[0]=0, nte[1]=0, nte[2]=0
       ncre=0
       endp=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vm3.juliandyke.com)(PORT=1521)))
         flg=0x80000000 nse=0

Instance: TEST
  flg=0x0, upd=0x2
  info=(HOST=vm3)
  node load=5, max=5120
  inst load=1, max=247

Services:
  0 - TEST
       flg=0x4, upd=0x6
       goodnes=0, delta=1
  1 - TESTXDB
       flg=0x5, upd=0x6
       goodnes=0, delta=1

Handlers:
  0 - Dedicated
       flg=0x80002002, upd=0x2
       services=TEST
       hdlr load=29, max=149

Dispatchers:
  0 - D000
       addr=(ADDRESS=(PROTOCOL=tcp)(HOST=vm3.juliandyke.com)(PORT=59204))
       inf=DISPATCHER 
       flg=0x1004, upd=0x0
       services=TESTXDB
       hdlr load=0, max=1022

CMON Handlers:

Listen Endpoints:

----------------------------
End Registration Information
----------------------------

For addtional information see:

ORADEBUG DOC EVENT ACTION LISTENER_REGISTRATION;