kfnuseconn oracle,ORA-15055 unable to connect to ASM instance ORA-21561

会不会跟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

...

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值