oracle 跟踪PMON动态注册

[oracle@normal admin]$ ps -ef | grep ora
oracle    1687     1  0 15:21 ?        00:00:00 ora_pmon_normal

[oracle@normal admin]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 26-AUG-2014 16:23:11

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))


[oracle@normal ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 26 16:24:10 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> oradebug setospid 1687
Oracle pid: 2, Unix process pid: 1687, image: oracle@normal.localdomain (PMON)

SQL> oradebug event 10257 trace name context forever, level 16;
Statement processed.

SQL> oradebug tracefile_name
/u01/app/oracle/diag/rdbms/normal/normal/trace/normal_pmon_1687.trc


*** 2014-08-26 16:28:16.719
err=-300 lbflgs=0x0 tbtime=0 tntime=0 etime=300 srvs=1 nreqs=0 sreqs=0 asrvs=1
error=-300 etime=300 control=0 integral=0 lasterr=-300 lastetm=300
kmmlrl: status: succ=0, wait=0, fail=1
kmmlrl: listener failure retry: 6001
kmmgdnu: NORMALXDB
         goodness=0, delta=1,
         flags=0x5:unblocked/not overloaded, update=0x6:G/D/-
kmmgdnu: normal
         goodness=0, delta=1,
         flags=0x4:unblocked/not overloaded, update=0x6:G/D/-
kmmlrl: nsgr update returned 0
kmmlrl: nsgr register returned 0

*** 2014-08-26 16:28:19.722
err=-300 lbflgs=0x0 tbtime=0 tntime=0 etime=300 srvs=1 nreqs=0 sreqs=0 asrvs=1
error=-300 etime=300 control=0 integral=0 lasterr=-300 lastetm=300
kmmlrl: status: succ=0, wait=0, fail=1


*** 2014-08-26 16:29:16.748                                                                                                                          
err=-300 lbflgs=0x0 tbtime=0 tntime=0 etime=300 srvs=1 nreqs=0 sreqs=0 asrvs=1                                                                       
error=-300 etime=300 control=0 integral=0 lasterr=-300 lastetm=300                                                                                   
kmmlrl: status: succ=0, wait=0, fail=1                                                                                                               
kmmlrl: listener failure retry: 6002                                                                                                                 
kmmgdnu: NORMALXDB                                                                                                                                   
         goodness=0, delta=1,                                                                                                                        
         flags=0x5:unblocked/not overloaded, update=0x6:G/D/-                                                                                        
kmmgdnu: normal                                                                                                                                      
         goodness=0, delta=1,                                                                                                                        
         flags=0x4:unblocked/not overloaded, update=0x6:G/D/-                                                                                        
kmmlrl: node load 15                                                                                                                                 
kmmlrl: nsgr update returned 0                                                                                                                       
kmmlrl: nsgr register returned 0                                                                                                                     
                                                                                                                                                     
*** 2014-08-26 16:29:19.751                                                                                                                          
err=-300 lbflgs=0x0 tbtime=0 tntime=0 etime=300 srvs=1 nreqs=0 sreqs=0 asrvs=1                                                                       
error=-300 etime=300 control=0 integral=0 lasterr=-300 lastetm=300                                                                                   
kmmlrl: status: succ=1, wait=0, fail=0 

SQL> oradebug event 10257 trace name context off;
Statement processed.

在11g以后还行使用 listener_registration 来跟踪 PMON 的动态注册

alter system set events='immediate trace name listener_registration level 3';

--pmon trace文件相关输出类容：

*** 2014-08-26 16:38:17.289
Start Registration Information
------------------------------
 
Last update: 429880227 (15 seconds ago)
Flag: 0xc, 0x0
State: succ=0, wait=0, fail=1
 
Listeners:
  0 - (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.137.11)(PORT=1521))
       state=4, err=3
       nse[0]=12541, nse[1]=12541, nte[0]=0, nte[1]=0, nte[2]=0
       ncre=0
       endp=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=normal.localdomain)(PORT=1521)))
         flg=0x80000000 nse=0
 
Instance: normal
  flg=0x0, upd=0x0
  info=(HOST=normal)
  node load=2, max=5120
  inst load=1, max=247
 
Services:
  0 - normal
       flg=0x4, upd=0x6
       goodnes=0, delta=1
  1 - NORMALXDB
       flg=0x5, upd=0x6
       goodnes=0, delta=1
 
Handlers: 
  0 - Dedicated
       flg=0x80002002, upd=0x0
       services=normal 
       hdlr load=28, max=149
 
Dispatchers:
  0 - D000
       addr=(ADDRESS=(PROTOCOL=tcp)(HOST=normal.localdomain)(PORT=31696))
       inf=DISPATCHER <machine: normal.localdomain, pid: 1719>
       flg=0x1004, upd=0x0
       services=NORMALXDB 
       hdlr load=0, max=1022
 
CMON Handlers:
 
Listen Endpoints:
 
----------------------------
End Registration Information
----------------------------

--停止跟踪
alter system set events='immediate trace name listener_registration off';

--pmon trace文件相关信息
*** 2014-08-26 17:03:36.407
Start Registration Information
------------------------------
 
Last update: 430022203 (114 seconds ago)
Flag: 0x4, 0x0
State: succ=1, wait=0, fail=0
 
Listeners:
  0 - (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.137.11)(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
----------------------------