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;