例項動態註冊跟蹤

由於在很多客戶那邊都碰到例項資訊不能動態註冊到監聽中去、本次就介紹一種方法來跟蹤例項動態註冊的全過程，以便提供更好的解決思路

跟蹤PMON程式動態註冊步驟
1、獲取資料庫伺服器上PMON程式號
[oracle@scn ~]$ ps -ef|grep pmon|grep -v grep|awk '{print $2}'
3957
2、關閉監聽
lsnrctl stop
3、在sqlplus中使用oradebug命令跟蹤pmon程式並獲取跟蹤檔案
SQL>oradebug setospid 3957
SQL>oradebug event 10257 trace name context forever,level 16;
SQL>oradebug tracefile_name
4、開啟監聽，等待pmon程式動態註冊監聽並獲得跟蹤檔案
lsnrctl start
5、從跟蹤檔案orcl_pmon_3957.trc可以看到pmon程式動態註冊的過程


操作記錄：
[oracle@xuh admin]$ ps -ef|grep pmon|grep -v grep|awk '{print $2}'
3957
[oracle@xuh admin]$ lsnrctl stop
[oracle@xuh admin]$ sqlplus "/as sysdba"
SQL> oradebug setospid 3957
Oracle pid: 2, Unix process pid: 3957, image: oracle@xuh (PMON)
SQL> oradebug event 10257 trace name context forever,level 16;
Statement processed.
SQL> oradebug tracefile_name
/oracle/app/admin/orcl/bdump/orcl_pmon_3957.trc
SQL> exit
[oracle@xuh admin]$ lsnrctl start
[oracle@xuh admin]$ more /oracle/app/admin/orcl/bdump/orcl_pmon_3957.trc
*** 2016-01-07 22:48:10.500
err=-300 tbtime=0 etime=300 srvs=1 nreqs=0 sreqs=0 asrvs=1
error=-300 etime=300 control=0 integral=0 lasterr=-300 lastetm=300
kmmlrl: listener failure retry: 6235
kmmgdnu: orclXDB
         goodness=0, delta=1,
         flags=0x5:unblocked/not overloaded, update=0x6:G/D/-
kmmgdnu: orcl
         goodness=0, delta=1,
         flags=0x4:unblocked/not overloaded, update=0x6:G/D/-
kmmlrl: node load 2
kmmlrl: nsgr update returned 0
kmmlrl: nsgr register returned 0
*** 2016-01-07 22:48:13.502