oracle 跟踪PMON动态注册

来源：互联网发布：景观设计效果图软件编辑：程序博客网时间：2024/04/30 18:20

[oracle@normal admin]$ ps -ef | grep oraoracle    1687     1  0 15:21 ?        00:00:00 ora_pmon_normal[oracle@normal admin]$ lsnrctl stopLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 26-AUG-2014 16:23:11Copyright (c) 1991, 2011, Oracle.  All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))[oracle@normal ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 26 16:24:10 2014Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> oradebug setospid 1687Oracle 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.719err=-300 lbflgs=0x0 tbtime=0 tntime=0 etime=300 srvs=1 nreqs=0 sreqs=0 asrvs=1error=-300 etime=300 control=0 integral=0 lasterr=-300 lastetm=300kmmlrl: status: succ=0, wait=0, fail=1kmmlrl: listener failure retry: 6001kmmgdnu: 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 0kmmlrl: nsgr register returned 0*** 2014-08-26 16:28:19.722err=-300 lbflgs=0x0 tbtime=0 tntime=0 etime=300 srvs=1 nreqs=0 sreqs=0 asrvs=1error=-300 etime=300 control=0 integral=0 lasterr=-300 lastetm=300kmmlrl: 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.289Start Registration Information------------------------------ Last update: 429880227 (15 seconds ago)Flag: 0xc, 0x0State: 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.407Start Registration Information------------------------------ Last update: 430022203 (114 seconds ago)Flag: 0x4, 0x0State: 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----------------------------

0 0