關於11gR2RAC監聽的跟蹤排查
現今客戶對於資料庫的安全越來越高，特別是網路安全這一部分，各種防火牆安全措施層出不窮，這就要就資料庫DBA和網路工程師有一個很好的溝通，否則，溝通不夠，往往存在著不小的麻煩，以下就是一次因為網路問題，導致的資料庫無法連線。
大致說一下整個故障經過：
客戶的資料庫在進行了10g單機升級到11g RAC後，由於10g是單機，對外只有一個IP，而11g採用scan的模式，也是隻有一個IP，所以客戶端連線並沒有做什麼改動，網路層面也沒有任何變化，而當升級完成，業務開啟後，客戶反映連線不上資料庫伺服器。我們遠端檢查，發現tnsping連線串，沒有任何問題，但是透過使用者名稱/密碼@服務名的方式遠端連線資料庫，則無法連線。由於報錯程式碼簡單，無法看出具體的問題，於是我們採用sqlnet跟蹤的方式，去跟蹤資料庫連線，看看問題到底出現在哪裡。
一下是具體的過程：
C:\Documents and Settings\tzyy>sqlplus "scott/oracle@tbsrun"
ERROR:
ORA-12543: TNS:destination host unreachable
我們首次透過tnsping確認連線問題：
C:\Documents and Settings\tzyy>tnsping tbsrun
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 10-SEP-2
014 09:49:22
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
E:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 172.16.1.246)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (servi
ce_name = bsrun)))
OK (20 msec)
發現tnsping沒有任何問題，返回成功，對於我們來說，一般tnsping沒有問題的話我們一般都認為從客戶端主機到伺服器端的網路環境都應該沒有問題。
接下來我們透過對一次連線進行跟蹤來分析問題：
首先設定跟蹤引數：
TRACE_LEVEL_CLIENT=16
TRACE_FILE_CLIENT=CLIENT
TRACE_TIMESTAMP_CLIENT=ON
trace_directory_client=E:\oracle\product\10.2.0\client_1\NETWORK\ADMIN
具體的設定過程及引數解釋在本文中不加敘述，我們只分析該過程
以下為詳細的分析日誌：
[10-SEP-2014 09:23:19:671] --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
[10-SEP-2014 09:23:19:671] New trace stream is E:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\client_2052_1.trc
[10-SEP-2014 09:23:19:671] New trace level is 16
[10-SEP-2014 09:23:19:671] --- TRACE CONFIGURATION INFORMATION ENDS ---
[10-SEP-2014 09:23:19:671] --- PARAMETER SOURCE INFORMATION FOLLOWS ---
[10-SEP-2014 09:23:19:671] Attempted load of system pfile source E:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora
[10-SEP-2014 09:23:19:671] Parameter source loaded successfully
[10-SEP-2014 09:23:19:671]
[10-SEP-2014 09:23:19:671] Attempted load of local pfile source C:\Documents and Settings\tzyy\sqlnet.ora
[10-SEP-2014 09:23:19:671] Parameter source was not loaded
[10-SEP-2014 09:23:19:671]
[10-SEP-2014 09:23:19:671] -> PARAMETER TABLE LOAD RESULTS FOLLOW
[10-SEP-2014 09:23:19:671] Successful parameter table load
[10-SEP-2014 09:23:19:671] -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS
[10-SEP-2014 09:23:19:671] TRACE_LEVEL_CLIENT = 16
[10-SEP-2014 09:23:19:671] TRACE_TIMESTAMP_CLIENT = ON
[10-SEP-2014 09:23:19:671] SQLNET.AUTHENTICATION_SERVICES = (NTS)
[10-SEP-2014 09:23:19:671] TRACE_FILE_CLIENT = CLIENT
[10-SEP-2014 09:23:19:671] trace_directory_client = E:\oracle\product\10.2.0\client_1\NETWORK\ADMIN
[10-SEP-2014 09:23:19:671] --- PARAMETER SOURCE INFORMATION ENDS ---
[10-SEP-2014 09:23:19:671] --- LOG CONFIGURATION INFORMATION FOLLOWS ---
[10-SEP-2014 09:23:19:671] Log stream will be "C:\Documents and Settings\tzyy\sqlnet.log"
[10-SEP-2014 09:23:19:671] Log stream validation not requested
[10-SEP-2014 09:23:19:671] --- LOG CONFIGURATION INFORMATION ENDS ---
######
以上為本次跟蹤的資訊讀取，包括跟蹤級別，基本的跟蹤引數讀取位置############
#####################以下為開始跟蹤過程########################
[10-SEP-2014 09:23:19:671] nlstdipi: entry
[10-SEP-2014 09:23:19:671] nlstdipi: exit
[10-SEP-2014 09:23:19:671] nigini: entry
[10-SEP-2014 09:23:19:671] nigini: Count in the NL global area is now 1
[10-SEP-2014 09:23:19:671] nigini: Count in NI global area now: 1
[10-SEP-2014 09:23:19:671] nrigbi: entry
[10-SEP-2014 09:23:19:671] nrigbni: entry
[10-SEP-2014 09:23:19:671] nrigbni: Unable to get data from navigation file tnsnav.ora
[10-SEP-2014 09:23:19:671] nrigbni: exit
[10-SEP-2014 09:23:19:671] nrigbi: exit
[10-SEP-2014 09:23:19:671] nigini: exit
[10-SEP-2014 09:23:19:671] niqname: Hst is already an NVstring.
[10-SEP-2014 09:23:19:671] niqname: Inserting CID.
[10-SEP-2014 09:23:19:671] niotns: entry
[10-SEP-2014 09:23:19:671] niotns: niotns: setting up interrupt handler...
[10-SEP-2014 09:23:19:671] niotns: Not trying to enable dead connection detection.
#######################對連線串進行解析並確認###########################
[10-SEP-2014 09:23:19:671] niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.1.246)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(service_name=bsrun)(CID=(PROGRAM=E:\oracle\product\10.2.0\client_1\bin\sqlplus.exe)(HOST=CZDL_CGZX104)(USER=tzyy))))
[10-SEP-2014 09:23:19:671] nscall: entry
[10-SEP-2014 09:23:19:671] nsmal: entry
[10-SEP-2014 09:23:19:671] nsmal: 212 bytes at 0xe42d10
[10-SEP-2014 09:23:19:671] nsmal: normal exit
[10-SEP-2014 09:23:19:671] nscall: connecting...
[10-SEP-2014 09:23:19:671] nladini: entry
[10-SEP-2014 09:23:19:671] nladini: exit
[10-SEP-2014 09:23:19:671] nladget: entry
[10-SEP-2014 09:23:19:671] nladget: exit
[10-SEP-2014 09:23:19:671] nsc2addr: entry
[10-SEP-2014 09:23:19:671] nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.1.246)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(service_name=bsrun)(CID=(PROGRAM=E:\oracle\product\10.2.0\client_1\bin\sqlplus.exe)(HOST=CZDL_CGZX104)(USER=tzyy))))
[10-SEP-2014 09:23:19:671] nttbnd2addr: entry
[10-SEP-2014 09:23:19:671] snlinGetAddrInfo: entry
[10-SEP-2014 09:23:19:671] snlinGetAddrInfo: exit
[10-SEP-2014 09:23:19:671] nttbnd2addr: using host IP address: 172.16.1.246
[10-SEP-2014 09:23:19:671] snlinFreeAddrInfo: entry
[10-SEP-2014 09:23:19:671] snlinFreeAddrInfo: exit
[10-SEP-2014 09:23:19:671] nttbnd2addr: exit
[10-SEP-2014 09:23:19:671] nsc2addr: normal exit
[10-SEP-2014 09:23:19:671] nsopen: entry
[10-SEP-2014 09:23:19:671] nsmal: entry
[10-SEP-2014 09:23:19:671] nsmal: 736 bytes at 0xeb5e08
[10-SEP-2014 09:23:19:671] nsmal: normal exit
[10-SEP-2014 09:23:19:671] nsopenmplx: entry
[10-SEP-2014 09:23:19:671] nsmal: entry
[10-SEP-2014 09:23:19:671] nsmal: 1644 bytes at 0xeb60f0
[10-SEP-2014 09:23:19:671] nsmal: normal exit
[10-SEP-2014 09:23:19:671] nsiorini: entry
[10-SEP-2014 09:23:19:671] nsbal: entry
[10-SEP-2014 09:23:19:671] nsbgetfl: entry
[10-SEP-2014 09:23:19:671] nsbgetfl: normal exit
[10-SEP-2014 09:23:19:671] nsmal: entry
[10-SEP-2014 09:23:19:671] nsmal: 84 bytes at 0xd9f570
[10-SEP-2014 09:23:19:671] nsmal: normal exit
[10-SEP-2014 09:23:19:671] nsbal: normal exit
[10-SEP-2014 09:23:19:671] nsiorini: exit (0)
[10-SEP-2014 09:23:19:671] nscpxget: entry
[10-SEP-2014 09:23:19:671] nscpxget: normal exit
[10-SEP-2014 09:23:19:671] nsopenalloc_nsntx: nlhthput on mplx_ht_nsgbu:ctx=eb5e08, nsntx=eb60f0
[10-SEP-2014 09:23:19:671] nsopenmplx: normal exit
###################開始建立連線，發起連線######################
[10-SEP-2014 09:23:19:671]
nsopen: opening transport...
[10-SEP-2014 09:23:19:671] nttcon: entry
[10-SEP-2014 09:23:19:671] nttcon: toc = 1
[10-SEP-2014 09:23:19:671] nttcnp: entry
[10-SEP-2014 09:23:19:671] nttcnp: creating a socket.
[10-SEP-2014 09:23:19:671] nttcnp: exit
[10-SEP-2014 09:23:19:671] nttcni: entry
[10-SEP-2014 09:23:19:671] nttcni: trying to connect to socket 1864.
[10-SEP-2014 09:23:19:671] snlinGetNameInfo: entry
[10-SEP-2014 09:23:19:671] snlinGetNameInfo: Using numeric form of host's address 172.18.115.203
[10-SEP-2014 09:23:19:671] snlinGetNameInfo: exit
[10-SEP-2014 09:23:19:671]
nttcni: connected on ipaddr 172.18.115.203
[10-SEP-2014 09:23:19:671] nttcni: exit
[10-SEP-2014 09:23:19:671] nttcon: NT layer TCP/IP connection has been established.
[10-SEP-2014 09:23:19:671] nttcon: set TCP_NODELAY on 1864
[10-SEP-2014 09:23:19:671] nttcon: exit
########################以下傳送274 bytes的包####################
[10-SEP-2014 09:23:19:671] nsopen: transport is open
[10-SEP-2014 09:23:19:671] nsoptions: entry
[10-SEP-2014 09:23:19:671] nsoptions: lcl[0]=0x0, lcl[1]=0x102000, gbl[0]=0x0, gbl[1]=0x0, cha=0x0
[10-SEP-2014 09:23:19:671] nsoptions: lcl[0]=0xf4ffefff, lcl[1]=0x102000, gbl[0]=0xfabf, gbl[1]=0x0
[10-SEP-2014 09:23:19:671] nsoptions: normal exit
[10-SEP-2014 09:23:19:671] nsnainit: entry
[10-SEP-2014 09:23:19:671] nsnainit: call
[10-SEP-2014 09:23:19:671] nsnadct: entry
[10-SEP-2014 09:23:19:671] nsnadct: normal exit
[10-SEP-2014 09:23:19:671] nsnasvnainfo: entry
[10-SEP-2014 09:23:19:671] nsnasvnainfo: normal exit
[10-SEP-2014 09:23:19:671] nainit: entry
[10-SEP-2014 09:23:19:671] nagblini: entry
[10-SEP-2014 09:23:19:671] nau_gin: entry
[10-SEP-2014 09:23:19:671] nau_gparams: entry
[10-SEP-2014 09:23:19:671] nam_gbp: Reading parameter "sqlnet.authentication_required" from parameter file
[10-SEP-2014 09:23:19:671] nam_gbp: Parameter not found
[10-SEP-2014 09:23:19:671] nau_gparams: Using default value "FALSE"
[10-SEP-2014 09:23:19:671] nau_gslf: entry
[10-SEP-2014 09:23:19:671] nam_gic: entry
[10-SEP-2014 09:23:19:671] nam_gic: Counting # of items in "sqlnet.authentication_services" parameter
[10-SEP-2014 09:23:19:671] nam_gic: Found 1 items
[10-SEP-2014 09:23:19:671] nam_gic: exit
[10-SEP-2014 09:23:19:671] nam_gnsp: Reading parameter "sqlnet.authentication_services" from parameter file
[10-SEP-2014 09:23:19:671] nam_gnsp: Found value "NTS"
[10-SEP-2014 09:23:19:671] nauss_set_state: entry
[10-SEP-2014 09:23:19:671] nauss_set_state: exit
[10-SEP-2014 09:23:19:671] nau_gslf: exit
[10-SEP-2014 09:23:19:671] nau_gparams: exit
[10-SEP-2014 09:23:19:671] nau_gin: exit
[10-SEP-2014 09:23:19:671] nagblini: exit
[10-SEP-2014 09:23:19:671] na_saveprot: entry
[10-SEP-2014 09:23:19:671] na_saveprot: exit
[10-SEP-2014 09:23:19:671] nacomin: entry
[10-SEP-2014 09:23:19:671] nas_init: entry
[10-SEP-2014 09:23:19:671] nas_init: exit
[10-SEP-2014 09:23:19:671] nau_ini: entry
[10-SEP-2014 09:23:19:671] naugcp_get_connect_parameters: entry
[10-SEP-2014 09:23:19:671] nauss_set_state: entry
[10-SEP-2014 09:23:19:671] nauss_set_state: exit
[10-SEP-2014 09:23:19:671] naugcp_get_connect_parameters: exit
[10-SEP-2014 09:23:19:671] nau_gettab: entry
[10-SEP-2014 09:23:19:671] nau_gettab: using authentication adapter table "nautab"
[10-SEP-2014 09:23:19:671] nau_gettab: nautab contains the following services:
[10-SEP-2014 09:23:19:671] nau_gettab: KERBEROS5
[10-SEP-2014 09:23:19:671] nau_gettab: NTS
[10-SEP-2014 09:23:19:671] nau_gettab: RADIUS
[10-SEP-2014 09:23:19:671] nau_gettab: exit
[10-SEP-2014 09:23:19:671] nau_sini: entry
[10-SEP-2014 09:23:19:671] nau_sini: exit
[10-SEP-2014 09:23:19:671] nau_ini: connection type: "standard"
[10-SEP-2014 09:23:19:671] nau_ini: exit
[10-SEP-2014 09:23:19:671] naeeinit: entry
[10-SEP-2014 09:23:19:671] nam_gbp: Reading parameter "SQLNET.FIPS_140" from parameter file
[10-SEP-2014 09:23:19:671] nam_gbp: Parameter not found
[10-SEP-2014 09:23:19:671] nam_gnsp: Reading parameter "SQLNET.ENCRYPTION_CLIENT" from parameter file
[10-SEP-2014 09:23:19:671] nam_gnsp: Parameter not found
[10-SEP-2014 09:23:19:671] naequad: Using default value "ACCEPTED"
[10-SEP-2014 09:23:19:671] nam_gic: entry
[10-SEP-2014 09:23:19:671] nam_gic: Counting # of items in "SQLNET.ENCRYPTION_TYPES_CLIENT" parameter
[10-SEP-2014 09:23:19:671] nam_gic: Parameter not found
[10-SEP-2014 09:23:19:671] nam_gic: exit
[10-SEP-2014 09:23:19:671] naesno: Using default value "all available algorithms"
[10-SEP-2014 09:23:19:671] naeshow: entry
[10-SEP-2014 09:23:19:671] naeshow: These are the encryption algorithms that the client will accept:
[10-SEP-2014 09:23:19:671] naeshow: Choice 0: no algorithm; encryption inactive
[10-SEP-2014 09:23:19:671] naeshow: Choice 1: 'AES256' (ID 17)
[10-SEP-2014 09:23:19:671] naeshow: Choice 2: 'RC4_256' (ID 6)
[10-SEP-2014 09:23:19:671] naeshow: Choice 3: 'AES192' (ID 16)
[10-SEP-2014 09:23:19:671] naeshow: Choice 4: '3DES168' (ID 12)
[10-SEP-2014 09:23:19:671] naeshow: Choice 5: 'AES128' (ID 15)
[10-SEP-2014 09:23:19:671] naeshow: Choice 6: 'RC4_128' (ID 10)
[10-SEP-2014 09:23:19:671] naeshow: Choice 7: '3DES112' (ID 11)
[10-SEP-2014 09:23:19:671] naeshow: Choice 8: 'RC4_56' (ID 8)
[10-SEP-2014 09:23:19:671] naeshow: Choice 9: 'DES' (ID 2)
[10-SEP-2014 09:23:19:671] naeshow: Choice 10: 'RC4_40' (ID 1)
[10-SEP-2014 09:23:19:671] naeshow: Choice 11: 'DES40' (ID 3)
[10-SEP-2014 09:23:19:671] naeshow: exit
[10-SEP-2014 09:23:19:671] naeeinit: exit
[10-SEP-2014 09:23:19:671] naecinit: entry
[10-SEP-2014 09:23:19:671] nam_gnsp: Reading parameter "SQLNET.CRYPTO_CHECKSUM_CLIENT" from parameter file
[10-SEP-2014 09:23:19:671] nam_gnsp: Parameter not found
[10-SEP-2014 09:23:19:671] naequad: Using default value "ACCEPTED"
[10-SEP-2014 09:23:19:671] nam_gic: entry
[10-SEP-2014 09:23:19:671] nam_gic: Counting # of items in "SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT" parameter
[10-SEP-2014 09:23:19:671] nam_gic: Parameter not found
[10-SEP-2014 09:23:19:671] nam_gic: exit
[10-SEP-2014 09:23:19:671] naesno: Using default value "all available algorithms"
[10-SEP-2014 09:23:19:671] naeshow: entry
[10-SEP-2014 09:23:19:671] naeshow: These are the checksumming algorithms that the client will accept:
[10-SEP-2014 09:23:19:671] naeshow: Choice 0: no algorithm; checksumming inactive
[10-SEP-2014 09:23:19:671] naeshow: Choice 1: 'SHA1' (ID 3)
[10-SEP-2014 09:23:19:671] naeshow: Choice 2: 'MD5' (ID 1)
[10-SEP-2014 09:23:19:671] naeshow: exit
[10-SEP-2014 09:23:19:671] naecinit: exit
[10-SEP-2014 09:23:19:671] nainit: exit
[10-SEP-2014 09:23:19:671] nagetctxinfo: entry
[10-SEP-2014 09:23:19:671] nagetctxinfo: exit
[10-SEP-2014 09:23:19:671] nsnainit: NS Connection version: 313
[10-SEP-2014 09:23:19:671] nsnainit: inf->nsinfflg[0]: 0x61 inf->nsinfflg[1]: 0x61
[10-SEP-2014 09:23:19:671] nsnainit: "or" info flags: 0x61 Translations follow:
native service(s) is (are) wanted
[10-SEP-2014 09:23:19:671] nsnainit: "or" info flags: 0x61 Translations follow:
native service(s) is (are) wanted
"and" info flags: 0x61 Translations follow:
native service(s) is (are) wanted
[10-SEP-2014 09:23:19:671] nsnainit: normal exit
[10-SEP-2014 09:23:19:671] nsopen: global context check-in (to slot 0) complete
[10-SEP-2014 09:23:19:671] nsopen: lcl[0]=0xf4ffefff, lcl[1]=0x102000, gbl[0]=0xfabf, gbl[1]=0x0, tdu=32767, sdu=2048
[10-SEP-2014 09:23:19:671] nsdo: entry
[10-SEP-2014 09:23:19:671] nsdo: cid=0, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2
[10-SEP-2014 09:23:19:671] nsdo: rank=64, nsctxrnk=0
[10-SEP-2014 09:23:19:671] nsdo: nsctx: state=7, flg=0x4001, mvd=0
[10-SEP-2014 09:23:19:671] nsbal: entry
[10-SEP-2014 09:23:19:671] nsbgetfl: entry
[10-SEP-2014 09:23:19:671] nsbgetfl: normal exit
[10-SEP-2014 09:23:19:671] nsmal: entry
[10-SEP-2014 09:23:19:671] nsmal: 84 bytes at 0xeb5d68
[10-SEP-2014 09:23:19:671] nsmal: normal exit
[10-SEP-2014 09:23:19:671] nsbal: normal exit
[10-SEP-2014 09:23:19:671] nsbal: entry
[10-SEP-2014 09:23:19:671] nsbgetfl: entry
[10-SEP-2014 09:23:19:671] nsbgetfl: normal exit
[10-SEP-2014 09:23:19:671] nsmal: entry
[10-SEP-2014 09:23:19:671] nsmal: 84 bytes at 0xe47e10
[10-SEP-2014 09:23:19:671] nsmal: normal exit
[10-SEP-2014 09:23:19:671] nsbal: normal exit
[10-SEP-2014 09:23:19:671] nsdo: nsctxrnk=0
[10-SEP-2014 09:23:19:671] nsdo: normal exit
[10-SEP-2014 09:23:19:671] nsopen: normal exit
[10-SEP-2014 09:23:19:671] nsdo: entry
[10-SEP-2014 09:23:19:671] nsdo: cid=0, opcode=67, *bl=216, *what=8, uflgs=0x0, cflgs=0x3
[10-SEP-2014 09:23:19:671] nsdo: rank=64, nsctxrnk=0
[10-SEP-2014 09:23:19:671] nsdo: nsctx: state=14, flg=0x4005, mvd=0
[10-SEP-2014 09:23:19:671] nsdo: gtn=10, gtc=10, ptn=10, ptc=2011
[10-SEP-2014 09:23:19:671] nscon: entry
[10-SEP-2014 09:23:19:671] nscon: doing connect handshake...
[10-SEP-2014 09:23:19:671] nscon: sending NSPTCN packet
[10-SEP-2014 09:23:19:671] nspsend: entry
[10-SEP-2014 09:23:19:671] nspsend: plen=274, type=1
[10-SEP-2014 09:23:19:671] nttwr: entry
[10-SEP-2014 09:23:19:671] nttwr: socket 1864 had bytes written=274
[10-SEP-2014 09:23:19:671] nttwr: exit
[10-SEP-2014 09:23:19:671] nspsend: packet dump
[10-SEP-2014 09:23:19:671] nspsend: 01 12 00 00 01 00 00 00 |........|
[10-SEP-2014 09:23:19:671] nspsend: 01 39 01 2C 00 00 08 00 |.9.,....|
[10-SEP-2014 09:23:19:671] nspsend: 7F FF C6 0E 00 00 01 00 |........|
[10-SEP-2014 09:23:19:671] nspsend: 00 D8 00 3A 00 00 02 00 |...:....|
[10-SEP-2014 09:23:19:671] nspsend: 61 61 00 00 00 00 00 00 |aa......|
[10-SEP-2014 09:23:19:671] nspsend: 00 00 00 00 00 00 00 00 |........|
[10-SEP-2014 09:23:19:671] nspsend: 00 00 00 00 00 00 00 00 |........|
[10-SEP-2014 09:23:19:671] nspsend: 00 00 28 44 45 53 43 52 |..(DESCR|
[10-SEP-2014 09:23:19:671] nspsend: 49 50 54 49 4F 4E 3D 28 |IPTION=(|
[10-SEP-2014 09:23:19:671] nspsend: 41 44 44 52 45 53 53 3D |ADDRESS=|
[10-SEP-2014 09:23:19:671] nspsend: 28 50 52 4F 54 4F 43 4F |(PROTOCO|
[10-SEP-2014 09:23:19:671] nspsend: 4C 3D 54 43 50 29 28 48 |L=TCP)
(H
|
[10-SEP-2014 09:23:19:671] nspsend: 4F 53 54 3D 31 37 32 2E |
OST=172.
|
[10-SEP-2014 09:23:19:671] nspsend: 31 36 2E 31 2E 32 34 36 |
16.1.246
|
[10-SEP-2014 09:23:19:671] nspsend: 29 28 50 4F 52 54 3D 31 |)(PORT=1|
[10-SEP-2014 09:23:19:671] nspsend: 35 32 31 29 29 28 43 4F |521))(CO|
[10-SEP-2014 09:23:19:671] nspsend: 4E 4E 45 43 54 5F 44 41 |NNECT_DA|
[10-SEP-2014 09:23:19:671] nspsend: 54 41 3D 28 53 45 52 56 |TA=(SERV|
[10-SEP-2014 09:23:19:671] nspsend: 45 52 3D 44 45 44 49 43 |ER=DEDIC|
[10-SEP-2014 09:23:19:671] nspsend: 41 54 45 44 29 28 73 65 |ATED)(se|
[10-SEP-2014 09:23:19:671] nspsend: 72 76 69 63 65 5F 6E 61 |rvice_na|
[10-SEP-2014 09:23:19:671] nspsend: 6D 65 3D 62 73 72 75 6E |me=bsrun|
[10-SEP-2014 09:23:19:671] nspsend: 29 28 43 49 44 3D 28 50 |)(CID=(P|
[10-SEP-2014 09:23:19:671] nspsend: 52 4F 47 52 41 4D 3D 45 |ROGRAM=E|
[10-SEP-2014 09:23:19:671] nspsend: 3A 5C 6F 72 61 63 6C 65 |:\oracle|
[10-SEP-2014 09:23:19:671] nspsend: 5C 70 72 6F 64 75 63 74 |\product|
[10-SEP-2014 09:23:19:671] nspsend: 5C 31 30 2E 32 2E 30 5C |\10.2.0\|
[10-SEP-2014 09:23:19:671] nspsend: 63 6C 69 65 6E 74 5F 31 |client_1|
[10-SEP-2014 09:23:19:671] nspsend: 5C 62 69 6E 5C 73 71 6C |\bin\sql|
[10-SEP-2014 09:23:19:671] nspsend: 70 6C 75 73 2E 65 78 65 |plus.exe|
[10-SEP-2014 09:23:19:671] nspsend: 29 28 48 4F 53 54 3D 43 |)(HOST=C|
[10-SEP-2014 09:23:19:671] nspsend: 5A 44 4C 5F 43 47 5A 58 |ZDL_CGZX|
[10-SEP-2014 09:23:19:671] nspsend: 31 30 34 29 28 55 53 45 |104)(USE|
[10-SEP-2014 09:23:19:671] nspsend: 52 3D 74 7A 79 79 29 29 |R=tzyy))|
[10-SEP-2014 09:23:19:671] nspsend: 29 29 |)) |
[10-SEP-2014 09:23:19:671] nspsend: 274 bytes to transport
########################以上為整個發包過程#########################
[10-SEP-2014 09:23:19:671] nspsend: normal exit
[10-SEP-2014 09:23:19:671] nscon: exit (0)
[10-SEP-2014 09:23:19:671] nsdo: nsctxrnk=0
[10-SEP-2014 09:23:19:671] nsdo: normal exit
[10-SEP-2014 09:23:19:671] nsdo: entry
[10-SEP-2014 09:23:19:671] nsdo: cid=0, opcode=68, *bl=512, *what=9, uflgs=0x0, cflgs=0x3
[10-SEP-2014 09:23:19:671] nsdo: rank=64, nsctxrnk=0
[10-SEP-2014 09:23:19:671] nsdo: nsctx: state=2, flg=0x4005, mvd=0
[10-SEP-2014 09:23:19:671] nsdo: gtn=10, gtc=10, ptn=10, ptc=2011
[10-SEP-2014 09:23:19:671] nscon: entry
############################開始從服務端的回包過程############################
[10-SEP-2014 09:23:19:671] nscon: recving a packet
[10-SEP-2014 09:23:19:671] nsprecv: entry
[10-SEP-2014 09:23:19:671] nsprecv: reading from transport...
[10-SEP-2014 09:23:19:671] nttrd: entry
[10-SEP-2014 09:23:19:671] nttrd: socket 1864 had bytes read=313
[10-SEP-2014 09:23:19:671] nttrd: exit
[10-SEP-2014 09:23:19:671] nsprecv: 313 bytes from transport
[10-SEP-2014 09:23:19:671] nsprecv: tlen=313, plen=10, type=5
[10-SEP-2014 09:23:19:671] nsprecv: 303 bytes to leftover
[10-SEP-2014 09:23:19:671] nsprecv: packet dump
[10-SEP-2014 09:23:19:671] nsprecv: 00 0A 00 00 05 02 00 00 |........|
[10-SEP-2014 09:23:19:671] nsprecv: 01 25 |.% |
[10-SEP-2014 09:23:19:671] nsprecv: normal exit
[10-SEP-2014 09:23:19:671] nscon: got NSPTRD packet
[10-SEP-2014 09:23:19:671] nscon: recving connect data
[10-SEP-2014 09:23:19:671] nsdo: entry
[10-SEP-2014 09:23:19:671] nsdo: cid=0, opcode=68, *bl=293, *what=1, uflgs=0x4001, cflgs=0x0
[10-SEP-2014 09:23:19:671] nsdo: nsctx: state=2, flg=0x804005, mvd=0
[10-SEP-2014 09:23:19:671] nsdo: gtn=10, gtc=10, ptn=10, ptc=2011
[10-SEP-2014 09:23:19:671] nsrdr: entry
[10-SEP-2014 09:23:19:671] nsrdr: recving a packet
[10-SEP-2014 09:23:19:671] nsprecv: entry
[10-SEP-2014 09:23:19:671] nsprecv: 303 bytes from leftover
[10-SEP-2014 09:23:19:671] nsprecv: tlen=303, plen=303, type=6
[10-SEP-2014 09:23:19:671] nsprecv: packet dump
[10-SEP-2014 09:23:19:671] nsprecv: 01 2F 00 00 06 00 00 00 |./......|
[10-SEP-2014 09:23:19:671] nsprecv: 00 40 28 41 44 44 52 45 |.@(ADDRE|
[10-SEP-2014 09:23:19:671] nsprecv: 53 53 3D 28 50 52 4F 54 |SS=(PROT|
[10-SEP-2014 09:23:19:671] nsprecv: 4F 43 4F 4C 3D 54 43 50 |OCOL=TCP|
[10-SEP-2014 09:23:19:671] nsprecv: 29 28 48 4F 53 54 3D 31 |)
(HOST=1
|
[10-SEP-2014 09:23:19:671] nsprecv: 37 32 2E 31 36 2E 31 2E |
72.16.1.
|
[10-SEP-2014 09:23:19:671] nsprecv: 32 34 38 29 28 50 4F 52 |
248
)(POR|
[10-SEP-2014 09:23:19:671] nsprecv: 54 3D 31 35 32 31 29 29 |T=1521))|
[10-SEP-2014 09:23:19:671] nsprecv: 00 28 44 45 53 43 52 49 |.(DESCRI|
[10-SEP-2014 09:23:19:671] nsprecv: 50 54 49 4F 4E 3D 28 41 |PTION=(A|
[10-SEP-2014 09:23:19:671] nsprecv: 44 44 52 45 53 53 3D 28 |DDRESS=(|
[10-SEP-2014 09:23:19:671] nsprecv: 50 52 4F 54 4F 43 4F 4C |PROTOCOL|
[10-SEP-2014 09:23:19:671] nsprecv: 3D 54 43 50 29 28 48 4F |=TCP)(HO|
[10-SEP-2014 09:23:19:671] nsprecv: 53 54 3D 31 37 32 2E 31 |ST=172.1|
[10-SEP-2014 09:23:19:671] nsprecv: 36 2E 31 2E 32 34 36 29 |6.1.246)|
[10-SEP-2014 09:23:19:671] nsprecv: 28 50 4F 52 54 3D 31 35 |(PORT=15|
[10-SEP-2014 09:23:19:671] nsprecv: 32 31 29 29 28 43 4F 4E |21))(CON|
[10-SEP-2014 09:23:19:671] nsprecv: 4E 45 43 54 5F 44 41 54 |NECT_DAT|
[10-SEP-2014 09:23:19:671] nsprecv: 41 3D 28 53 45 52 56 45 |A=(SERVE|
[10-SEP-2014 09:23:19:671] nsprecv: 52 3D 44 45 44 49 43 41 |R=DEDICA|
[10-SEP-2014 09:23:19:671] nsprecv: 54 45 44 29 28 73 65 72 |TED)(ser|
[10-SEP-2014 09:23:19:671] nsprecv: 76 69 63 65 5F 6E 61 6D |vice_nam|
[10-SEP-2014 09:23:19:671] nsprecv: 65 3D 62 73 72 75 6E 29 |e=bsrun)|
[10-SEP-2014 09:23:19:671] nsprecv: 28 43 49 44 3D 28 50 52 |(CID=(PR|
[10-SEP-2014 09:23:19:671] nsprecv: 4F 47 52 41 4D 3D 45 3A |OGRAM=E:|
[10-SEP-2014 09:23:19:671] nsprecv: 5C 6F 72 61 63 6C 65 5C |\oracle\|
[10-SEP-2014 09:23:19:671] nsprecv: 70 72 6F 64 75 63 74 5C |product\|
[10-SEP-2014 09:23:19:671] nsprecv: 31 30 2E 32 2E 30 5C 63 |10.2.0\c|
[10-SEP-2014 09:23:19:671] nsprecv: 6C 69 65 6E 74 5F 31 5C |lient_1\|
[10-SEP-2014 09:23:19:671] nsprecv: 62 69 6E 5C 73 71 6C 70 |bin\sqlp|
[10-SEP-2014 09:23:19:671] nsprecv: 6C 75 73 2E 65 78 65 29 |lus.exe)|
[10-SEP-2014 09:23:19:671] nsprecv: 28 48 4F 53 54 3D 43 5A |(HOST=CZ|
[10-SEP-2014 09:23:19:671] nsprecv: 44 4C 5F 43 47 5A 58 31 |DL_CGZX1|
[10-SEP-2014 09:23:19:671] nsprecv: 30 34 29 28 55 53 45 52 |04)(USER|
[10-SEP-2014 09:23:19:671] nsprecv: 3D 74 7A 79 79 29 29 28 |=tzyy))(|
[10-SEP-2014 09:23:19:671] nsprecv: 49 4E 53 54 41 4E 43 45 |INSTANCE|
[10-SEP-2014 09:23:19:671] nsprecv: 5F 4E 41 4D 45 3D 62 73 |_NAME=bs|
[10-SEP-2014 09:23:19:671] nsprecv: 72 75 6E 32 29 29 29 |run2))) |
[10-SEP-2014 09:23:19:671] nsprecv: normal exit
[10-SEP-2014 09:23:19:671] nsrdr: got NSPTDA packet
[10-SEP-2014 09:23:19:671] nsrdr: NSPTDA flags: 0x40
[10-SEP-2014 09:23:19:671] nsrdr: normal exit
[10-SEP-2014 09:23:19:671] nsdo: *what=1, *bl=293
[10-SEP-2014 09:23:19:671] nsdo: 293 bytes from NS buffer
##############################發回293位元組的包############################
[10-SEP-2014 09:23:19:671] nsdo: normal exit
[10-SEP-2014 09:23:19:671] nscon: got 293 bytes connect data
[10-SEP-2014 09:23:19:671] nscon: exit (0)
[10-SEP-2014 09:23:19:671] nsdo: nsctxrnk=0
[10-SEP-2014 09:23:19:671] nsdo: normal exit
[10-SEP-2014 09:23:19:671] nscall: redirected
[10-SEP-2014 09:23:19:671] nsclose: entry
[10-SEP-2014 09:23:19:671] nstimarmed: entry
[10-SEP-2014 09:23:19:671] nstimarmed: no timer allocated
[10-SEP-2014 09:23:19:671] nstimarmed: normal exit
[10-SEP-2014 09:23:19:671] nttctl: entry
[10-SEP-2014 09:23:19:671] nttctl: entry
[10-SEP-2014 09:23:19:671] nsdo: entry
[10-SEP-2014 09:23:19:671] nsdo: cid=0, opcode=98, *bl=0, *what=0, uflgs=0x440, cflgs=0x2
[10-SEP-2014 09:23:19:671] nsdo: rank=64, nsctxrnk=0
[10-SEP-2014 09:23:19:671] nsdo: nsctx: state=3, flg=0x804001, mvd=0
[10-SEP-2014 09:23:19:671] nsbfr: entry
[10-SEP-2014 09:23:19:671] nsbaddfl: entry
[10-SEP-2014 09:23:19:671] nsbaddfl: normal exit
[10-SEP-2014 09:23:19:671] nsbfr: normal exit
[10-SEP-2014 09:23:19:671] nsbfr: entry
[10-SEP-2014 09:23:19:671] nsbaddfl: entry
[10-SEP-2014 09:23:19:671] nsbaddfl: normal exit
[10-SEP-2014 09:23:19:671] nsbfr: normal exit
[10-SEP-2014 09:23:19:671] nsdo: nsctxrnk=0
[10-SEP-2014 09:23:19:671] nsdo: normal exit
[10-SEP-2014 09:23:19:671] nsiocancel: entry
[10-SEP-2014 09:23:19:671] nsiofrrg: entry
[10-SEP-2014 09:23:19:671] nsbfr: entry
[10-SEP-2014 09:23:19:671] nsbaddfl: entry
[10-SEP-2014 09:23:19:671] nsbaddfl: normal exit
[10-SEP-2014 09:23:19:671] nsbfr: normal exit
[10-SEP-2014 09:23:19:671] nsiofrrg: exit
[10-SEP-2014 09:23:19:671] nsiocancel: exit
[10-SEP-2014 09:23:19:671] nsclose: closing transport
[10-SEP-2014 09:23:19:671] nttdisc: entry
[10-SEP-2014 09:23:19:671] nttdisc: Closed socket 1864
##以上為整個握手協議過程，到這裡整個握手協議成功，也就是tnsping為什麼成功的原因，接下來就要真正開始建立連線
#####
[10-SEP-2014 09:23:19:671] nttdisc: exit
[10-SEP-2014 09:23:19:671] nsclose: global context check-out (from slot 0) complete
[10-SEP-2014 09:23:19:671] nsnadisc: entry
[10-SEP-2014 09:23:19:671] nadisc: entry
[10-SEP-2014 09:23:19:671] nacomtm: entry
[10-SEP-2014 09:23:19:671] nacompd: entry
[10-SEP-2014 09:23:19:671] nacompd: exit
[10-SEP-2014 09:23:19:671] nacompd: entry
[10-SEP-2014 09:23:19:671] nacompd: exit
[10-SEP-2014 09:23:19:671] nacomtm: exit
[10-SEP-2014 09:23:19:671] nas_dis: entry
[10-SEP-2014 09:23:19:671] nas_dis: exit
[10-SEP-2014 09:23:19:671] nau_dis: entry
[10-SEP-2014 09:23:19:671] nau_dis: exit
[10-SEP-2014 09:23:19:671] naeetrm: entry
[10-SEP-2014 09:23:19:671] naeetrm: exit
[10-SEP-2014 09:23:19:671] naectrm: entry
[10-SEP-2014 09:23:19:671] naectrm: exit
[10-SEP-2014 09:23:19:671] nagbltrm: entry
[10-SEP-2014 09:23:19:671] nau_gtm: entry
[10-SEP-2014 09:23:19:671] nau_gtm: exit
[10-SEP-2014 09:23:19:671] nagbltrm: exit
[10-SEP-2014 09:23:19:671] nadisc: exit
[10-SEP-2014 09:23:19:671] nsnadisc: normal exit
[10-SEP-2014 09:23:19:671] nsopenfree_nsntx: nlhthdel from mplx_ht_nsgbu, ctx=eb5e08 nsntx=eb60f0
[10-SEP-2014 09:23:19:671] nsiocancel: entry
[10-SEP-2014 09:23:19:671] nsiofrrg: entry
[10-SEP-2014 09:23:19:671] nsiofrrg: exit
[10-SEP-2014 09:23:19:671] nsiocancel: exit
[10-SEP-2014 09:23:19:671] nsmfr: entry
[10-SEP-2014 09:23:19:671] nsmfr: 1644 bytes at 0xeb60f0
[10-SEP-2014 09:23:19:671] nsmfr: normal exit
[10-SEP-2014 09:23:19:671] nsmfr: entry
[10-SEP-2014 09:23:19:671] nsmfr: 736 bytes at 0xeb5e08
[10-SEP-2014 09:23:19:671] nsmfr: normal exit
[10-SEP-2014 09:23:19:671] nsclose: normal exit
[10-SEP-2014 09:23:19:671] nscall: connecting...
[10-SEP-2014 09:23:19:671] nsc2addr: entry
############以下是我們需要重點關注的一點，172.16.1.248 該IP為二節點的VIP#####################
[10-SEP-2014 09:23:19:671] nsc2addr: (ADDRESS=(PROTOCOL=TCP)(HOST=172.16.1.248)(PORT=1521))
[10-SEP-2014 09:23:19:671] nttbnd2addr: entry
[10-SEP-2014 09:23:19:671] snlinGetAddrInfo: entry
[10-SEP-2014 09:23:19:671] snlinGetAddrInfo: exit
[10-SEP-2014 09:23:19:671] nttbnd2addr: using host IP address: 172.16.1.248
[10-SEP-2014 09:23:19:671] snlinFreeAddrInfo: entry
[10-SEP-2014 09:23:19:671] snlinFreeAddrInfo: exit
[10-SEP-2014 09:23:19:671] nttbnd2addr: exit
[10-SEP-2014 09:23:19:671] nsc2addr: normal exit
[10-SEP-2014 09:23:19:671] nsopen: entry
[10-SEP-2014 09:23:19:671] nsmal: entry
[10-SEP-2014 09:23:19:671] nsmal: 736 bytes at 0xeb5e08
[10-SEP-2014 09:23:19:671] nsmal: normal exit
[10-SEP-2014 09:23:19:671] nsopenmplx: entry
[10-SEP-2014 09:23:19:671] nsmal: entry
[10-SEP-2014 09:23:19:671] nsmal: 1644 bytes at 0xeb60f0
[10-SEP-2014 09:23:19:687] nsmal: normal exit
[10-SEP-2014 09:23:19:687] nsiorini: entry
[10-SEP-2014 09:23:19:687] nsbal: entry
[10-SEP-2014 09:23:19:687] nsbgetfl: entry
[10-SEP-2014 09:23:19:687] nsbgetfl: normal exit
[10-SEP-2014 09:23:19:687] nsbal: normal exit
[10-SEP-2014 09:23:19:687] nsiorini: exit (0)
[10-SEP-2014 09:23:19:687] nscpxget: entry
[10-SEP-2014 09:23:19:687] nscpxget: normal exit
[10-SEP-2014 09:23:19:687] nsopenalloc_nsntx: nlhthput on mplx_ht_nsgbu:ctx=eb5e08, nsntx=eb60f0
[10-SEP-2014 09:23:19:687] nsopenmplx: normal exit
[10-SEP-2014 09:23:19:687] nsopen: opening transport...
[10-SEP-2014 09:23:19:687] nttcon: entry
[10-SEP-2014 09:23:19:687] nttcon: toc = 1
[10-SEP-2014 09:23:19:687] nttcnp: entry
[10-SEP-2014 09:23:19:687] nttcnp: creating a socket.
[10-SEP-2014 09:23:19:687] nttcnp: exit
[10-SEP-2014 09:23:19:687] nttcni: entry
####
可以看到從248IP建立的socket 1864開始建立連線出現了報錯###########
[10-SEP-2014 09:23:19:687] nttcni: trying to connect to socket 1864.
[10-SEP-2014 09:23:40:625] ntt2err: entry
[10-SEP-2014 09:23:40:625] ntt2err: soc 1864 error - operation=1, ntresnt[0]=513, ntresnt[1]=51, ntresnt[2]=0
[10-SEP-2014 09:23:40:625] ntt2err: exit
[10-SEP-2014 09:23:40:734] nttcni: exit
[10-SEP-2014 09:23:40:734] nttcon: exit
[10-SEP-2014 09:23:40:734] nserror: entry
[10-SEP-2014 09:23:40:734] nserror: nsres: id=0, op=65, ns=12543, ns2=12560; nt[0]=513, nt[1]=51, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[10-SEP-2014 09:23:40:734] nsopen: unable to open transport
[10-SEP-2014 09:23:40:734] nsiocancel: entry
[10-SEP-2014 09:23:40:734] nsiofrrg: entry
[10-SEP-2014 09:23:40:734] nsbfr: entry
[10-SEP-2014 09:23:40:734] nsbaddfl: entry
[10-SEP-2014 09:23:40:734] nsbaddfl: normal exit
[10-SEP-2014 09:23:40:734] nsbfr: normal exit
[10-SEP-2014 09:23:40:734] nsiofrrg: exit
[10-SEP-2014 09:23:40:734] nsiocancel: exit
[10-SEP-2014 09:23:40:734] nsopenfree_nsntx: nlhthdel from mplx_ht_nsgbu, ctx=eb5e08 nsntx=eb60f0
[10-SEP-2014 09:23:40:734] nsiocancel: entry
[10-SEP-2014 09:23:40:734] nsiofrrg: entry
[10-SEP-2014 09:23:40:734] nsiofrrg: exit
[10-SEP-2014 09:23:40:734] nsiocancel: exit
[10-SEP-2014 09:23:40:734] nsmfr: entry
[10-SEP-2014 09:23:40:734] nsmfr: 1644 bytes at 0xeb60f0
[10-SEP-2014 09:23:40:734] nsmfr: normal exit
[10-SEP-2014 09:23:40:734] nsmfr: entry
[10-SEP-2014 09:23:40:734] nsmfr: 736 bytes at 0xeb5e08
[10-SEP-2014 09:23:40:734] nsmfr: normal exit
[10-SEP-2014 09:23:40:734] nsopen: error exit
[10-SEP-2014 09:23:40:734] nsmfr: entry
[10-SEP-2014 09:23:40:734] nsmfr: 216 bytes at 0xe48690
[10-SEP-2014 09:23:40:734] nsmfr: normal exit
[10-SEP-2014 09:23:40:734] nsmfr: entry
[10-SEP-2014 09:23:40:734] nsmfr: 212 bytes at 0xe42d10
[10-SEP-2014 09:23:40:734] nsmfr: normal exit
[10-SEP-2014 09:23:40:734] nladtrm: entry
[10-SEP-2014 09:23:40:734] nladtrm: exit
[10-SEP-2014 09:23:40:734] nscall: error exit
[10-SEP-2014 09:23:40:734] nioqper: error from nscall
[10-SEP-2014 09:23:40:734] nioqper: ns main err code: 12543
[10-SEP-2014 09:23:40:734] nioqper: ns (2) err code: 12560
[10-SEP-2014 09:23:40:734] nioqper: nt main err code: 513
[10-SEP-2014 09:23:40:734] nioqper: nt (2) err code: 51
[10-SEP-2014 09:23:40:734] nioqper: nt OS err code: 0
[10-SEP-2014 09:23:40:734] niomapnserror: entry
[10-SEP-2014 09:23:40:734] niqme: entry
#####################因為無法建立連線超時導致12543報錯的產生###################
[10-SEP-2014 09:23:40:734] niqme: reporting NS-12543 error as ORA-12543
[10-SEP-2014 09:23:40:734] niqme: exit
[10-SEP-2014 09:23:40:734] niomapnserror: exit
[10-SEP-2014 09:23:40:734] niotns: Couldn't connect, returning 12543
[10-SEP-2014 09:23:40:734] niotns: exit
[10-SEP-2014 09:23:40:734] nsbfrfl: entry
[10-SEP-2014 09:23:40:734] nsbrfr: entry
[10-SEP-2014 09:23:40:734] nsbrfr: nsbfs at 0xe47e10, data at 0xe47e70.
[10-SEP-2014 09:23:40:734] nsbrfr: normal exit
[10-SEP-2014 09:23:40:734] nsbrfr: entry
[10-SEP-2014 09:23:40:734] nsbrfr: nsbfs at 0xd9f570, data at 0xeb6768.
[10-SEP-2014 09:23:40:734] nsbrfr: normal exit
[10-SEP-2014 09:23:40:734] nsbrfr: entry
[10-SEP-2014 09:23:40:734] nsbrfr: nsbfs at 0xeb5d68, data at 0xe475f0.
[10-SEP-2014 09:23:40:734] nsbrfr: normal exit
[10-SEP-2014 09:23:40:734] nsbfrfl: normal exit
[10-SEP-2014 09:23:40:734] nigtrm: Count in the NI global area is now 0
[10-SEP-2014 09:23:40:734] nrigbd: entry
[10-SEP-2014 09:23:40:734] nrigbd: exit
[10-SEP-2014 09:23:40:734] nigtrm: Count in the NL global area is now 0
[10-SEP-2014 09:23:40:734] nlse_term_audit: entry
[10-SEP-2014 09:23:40:734] nlse_term_audit: exit
其實到這裡問題很明確，我們知道一般來說透過監聽無法正常建立連線一般情況下都是網路設定，防火牆，長連線設定等等
在11g RAC中當使用者連結scan ip時，scan ip接收到使用者的連結請求，此時會根據rac各節點的資源情況來決定將連線分配給哪個vip的監聽，這裡vip監控就是各個節點的本地監聽了。我們發現由於
從10g升級到了11g 新增加了本地IP及新的VIP資訊，而在網路層面並沒有對這幾個IP開放。
------------------------------------------------------------------------------------
原部落格地址：
http://blog.itpub.net/23732248/
原作者：應以峰 (frank-ying)
-------------------------------------------------------------------------------------
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/23732248/viewspace-1467105/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 關於跟蹤路由對網站監測的意義路由網站
- Oracle 跟蹤/告警/監聽日誌的清理指令碼Oracle指令碼
- 監聽器控制程式lsnrctl跟蹤trace file
- 聊聊跟蹤監聽器動態註冊（Dynamic Register）方法
- 關於oracle中session跟蹤的總結OracleSession
- 關於oracle的監聽問題Oracle
- 關於EditText焦點監聽
- 關於Servlet中的事件監聽 薦Servlet事件
- 基於行跟蹤的ROWDEPENDENCIES實現資訊變化跟蹤
- Java呼叫鏈跟蹤關鍵技術（四）SQL監控JavaSQL
- 棧呼叫關係跟蹤
- 網站是如何跟蹤監視你的網站
- 關於vue事件監聽的一個問題Vue事件
- 關於監聽不能啟動的解決方法
- 一個Oracle監聽問題的網路排查Oracle
- 關於SD業務幾個TCODE操作的SAP表跟蹤
- 關於SSH中對於action的監聽問題（關於系統計數）
- 當心你的手機暗藏“臥底軟體”！已有6萬人被監聽和跟蹤→
- sql server關於跟蹤日誌查詢使用說明SQLServer
- 請教關於利用跟蹤檔案重建控制檔案
- 關閉監聽的日誌。
- SQL 跟蹤方法相關介紹SQL
- 【經典】連線oracle的總結（關於tnsname和監聽）Oracle
- 關於oracle11g RAC 監聽器問題Oracle
- [zt] oracle跟蹤檔案與跟蹤事件Oracle事件
- oracle跟蹤檔案與跟蹤事件(zt)Oracle事件
- oracle跟蹤檔案和跟蹤事件(zt)Oracle事件
- ALERT日誌中常見監聽相關報錯之一：ORA-609錯誤的排查
- ALERT日誌中常見監聽相關報錯之二：ORA-3136錯誤的排查
- 為監聽設定密碼防止遠端關閉監聽密碼
- 【TRACE】如何設定或動態跟蹤Oracle net偵聽器Oracle
- 如何做好專案進度監控與跟蹤
- 基於laravel的事件監聽例項Laravel事件
- git的跟蹤分支和遠端跟蹤分支學習筆記Git筆記
- banq老師 我想問一個很笨的問題關於#會話#跟蹤#的會話
- SQL 的跟蹤方法traceSQL
- Banq,請教一下關於非同步事件監聽模式非同步事件模式
- 關於SQLRecoverableException問題的排查和分析SQLException