会不会跟scan listener 有关?我找到了下面的一些信息,节点2上的listener状态是INTERMEDIATE,不太明白是啥意思
sqlnet log file:
Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LZBSORACPD02-vip)(PORT=1521))(CONNECT_DATA=(SID=LZBSORAC2)(CID=(PROGRAM=D:\app\oraclerac\product\11.2.0\dbhome_1\bin\emagent.exe)(HOST=LZBSORACPD02)(USER=SYSTEM))))
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production
Time: 26-MAR-2012 13:34:01
Tracing not turned on.
Tns error struct:
ns main err code: 12541
TNS-12541: TNS:no listener
ns secondary err code: 12560
nt main err code: 511
TNS-00511: No listener
nt secondary err code: 61
nt OS err code: 0
***********************************************************************
Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LZBSORACPD02-vip)(PORT=1521))(CONNECT_DATA=(SID=LZBSORAC2)(CID=(PROGRAM=D:\app\oraclerac\product\11.2.0\dbhome_1\bin\emagent.exe)(HOST=LZBSORACPD02)(USER=SYSTEM))))
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production
Time: 26-MAR-2012 13:34:02
Tracing not turned on.
Tns error struct:
ns main err code: 12541
TNS-12541: TNS:no listener
ns secondary err code: 12560
nt main err code: 511
TNS-00511: No listener
nt secondary err code: 61
nt OS err code: 0
C:\Users\dbadirect>tnsping lzbsoracpd02
TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 30-MAR-2012 04:25:30
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
D:\app\11.2.0\grid\network\admin\sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.200.21)(PORT=1521)))
^C
C:\Users\dbadirect>tnsping lzbsoracpd01
TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 30-MAR-2012 04:25:51
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
D:\app\11.2.0\grid\network\admin\sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.200.20)(PORT=1521)))
OK (0 msec)
C:\Users\dbadirect>
C:\Users\dbadirect>olsnodes
lzbsoracpd01
lzbsoracpd02
C:\Users\dbadirect>srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node lzbsoracpd01
C:\Users\dbadirect>srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node lzbsoracpd01
C:\Users\dbadirect>srvctl config scan
SCAN name: LZBRACSCANPD.NA.LZB.HQ, Network: 1/10.1.200.0/255.255.255.0/PublicLan
SCAN VIP name: scan1, IP: /LZBRACSCANPD.NA.LZB.HQ/10.1.200.24
C:\Users\dbadirect>crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DBDATA.dg
ONLINE ONLINE lzbsoracpd01
ONLINE ONLINE lzbsoracpd02
ora.DBFLASH.dg
ONLINE ONLINE lzbsoracpd01
ONLINE ONLINE lzbsoracpd02
ora.LISTENER.lsnr
ONLINE ONLINE lzbsoracpd01
ONLINE INTERMEDIATE lzbsoracpd02 CHECK TIMED OUT
ora.OCR_VOTE.dg
ONLINE ONLINE lzbsoracpd01
...