摘抄于https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=bbdpuqqs8_4&_afrLoop=441479978503320
文档内容
用途 |
适用范围 |
详细信息 |
问题 1:安装Patch 23273629后SCAN Listener 或 local listener无法启动 |
问题 2:间歇性VIP, SCAN VIP failover和VIP failover后Listener停止 |
问题 3:SCAN 连接有关问题 |
问题 4:在 SCAN listener 发生故障切换(failover)后,服务未注册到 SCAN listener |
问题 5:SCAN有关的安装问题 |
问题 6:SCAN VIP 或 SCAN LISTENER是OFFLINE / UNKNOWN状态 |
参考 |
适用于:
Oracle Database - Enterprise Edition - 版本 11.2.0.1 和更高版本本文档所含信息适用于所有平台
用途
本文简要总结了与 SCAN VIP 和 SCAN LISTENERS 有关的常见问题。
有关SCAN的更多信息,请参考Note 887522.1 Grid Infrastructure Single Client Access Name (SCAN) Explained
适用范围
适用于11gR2 Grid Infrastructure.
详细信息
问题 1:安装Patch 23273629后SCAN Listener 或 local listener无法启动
请具体参考:
note 2166451.1 - SCAN Listener or local listener fails to start after applying Patch 23273629 - Oracle Grid Infrastructure Patch Set Update 12.1.0.2.160719 (Jul2016)
问题 2:间歇性VIP, SCAN VIP failover和VIP failover后Listener停止
间歇性VIP, SCAN VIP failover和Listener停止导致的连接问题.
$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE rac2
ora.rac1.vip
1 ONLINE INTERMEDIATE rac2 FAILED OVER
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.scan2.vip
1 ONLINE ONLINE rac2
ora.scan2.vip
1 ONLINE ONLINE rac2
ora.scan3.vip
1 ONLINE ONLINE rac2
1. Unpublished Bug 12680491 Intermittent hiccup in network CHECK action can fail over vip, bring listener offline briefly, 请参考 Note 12680491.8
2. Bug 13582411 RAC ONE NODE: SCAN_LISTENER GO OFF LINE AFTER NETWORK HICCUP
补丁安装后,需要再修改VIP 和 SCAN VIP 的STOP_DEPENDENCIES属性,使补丁生效。
问题 3:SCAN 连接有关问题
通过SCAN 连接数据库时可能遇到下面的错误
Intermittent ORA-12541 TNS: No Listener
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
ORA-12516: TNS:listener could not find available handler with matching protocol Stack
TNS-12561: TNS:unknown error
TNS-01101: Could not find service name for LISTENER_SCANx
ORA-12537: TNS:connection closed
TNS-12518: TNS:listener could not hand off client connection
1. 本地LISTENER没有启动。
2. 集群以外的服务器设置remote_listener指向集群SCAN(有可能出现在DataGuard 备库)
3. tnsnames.ora没有正确定义"<SCAN>:<PORT>"
4. 本地LISTENER在RDBMS ORACLE_HOME/network/admin/tnsnames.ora中定义,并且手动启动。
5. COST问题
6. lsnrctl status <listener name> 在错误的ORACLE_HOME(需要在GRID_HOME下运行)或者错误的节点下运行。
7. 错误ORACLE_HOME设置。
8. oracle权限问题,丢失了setuid 和 setgid权限。
9. 由于Bug 15874565
请参考下面的Note的解决方案:
1. How to Troubleshoot Connectivity Issue with 11gR2 SCAN Name Note 975457.1
2. Intermittent ORA-12541 when Connecting via SCAN listener in RAC Note 1547757.1
3. TNS-12514 Unable to connect to RAC database using SCAN name Note 1459768.1
4. Connect Via SCAN Intermittently Fails With ORA-12516: TNS:listener Could Not Find Available Handler With Matching Protocol Stack Note 1638175.1
5. SCAN: Following (COST) Implementation Services Fail to Register to SCAN Listeners TNS-12561 Note 1624154.1
6. SCAN: Using Lsnrctl To Check Scan Listener Status Yields Error TNS-12541 TNS: No Listener Note 1666358.1
7. TNS-01101: Could not find service name for LISTENER_SCANx Note 1064628.1
8. TNS-12518 Can Not Connect To RAC 11gR2 Database Note 1088754.1
9. Duplicate VIP or SCAN VIP or SCAN Listener Found on More than 1 Node in a RAC Cluster Note 1575272.1
问题 4:在 SCAN listener 发生故障切换(failover)后,服务未注册到 SCAN listener
在执行 SCAN VIP 和 SCAN listener故障切换后,实例未注册到 SCAN listener。这种情况只会发生在其中1 个 scan listener上。客户机连接间歇性出现“ORA-12514 TNS:listener does not currently know of service requested in connect descriptor”。
1. 未发布的 Bug 12659561:在执行 scan listener故障切换后,数据库实例可能未注册到 scan listener(请参阅 Note 12659561.8),这一问题已在 11.2.0.3.2 中修复,针对 11.2.0.2 的 Merge patch13354057 适用于特定平台。
2. 未发布的 Bug 13066936:在执行 scan 故障切换时,实例未注册服务(请参阅 Note 13066936.8)。
1) 对于以上两个 Bug,解决方法是执行以下步骤,在未注册到 SCAN listener的数据库实例上注销并重新注册remote_listener。
show parameter remote_listener
alter system set remote_listener='';
alter system register;
alter system set remote_listener='<scan>:<port>';
alter system register;
2) 服务未注册到 SCAN listener(监听程序)时要检查的其他要点:
a. 正确定义了 remote_listener 和 local_listener
b. sqlnet.ora 中定义了 EZCONNECT,示例:NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
c. 定义3个SCAN IP,那么不能在/etc/hosts中定义,应该在DNS中定义。
d. 多次运行nslookup <scan> 应以 round-robin (循环)方式显示 SCAN VIP
e. 如果未配置 Secure transports (COST) 的类,则不要在 listener.ora 中设置 SECURE_REGITER_<listener>。
问题 5:SCAN有关的安装问题
安装Grid Infrastructure时,有时会出现下面的错误:
INS-40719 Scan Already Assigned To Another System
INS-41105: subnet chosen as public does not match subnet of SCAN VIP
PRVG-1101 : SCAN name "cluscan.us.oracle.com" failed to resolve
INFO: PRVF-4664 : Found inconsistent name resolution entries for SCAN name "cluscan.us.oracle.com"
INFO: PRVF-4657 : Name resolution setup check for "scanclunm" (IP address: 10.4.0.202) failed
PRCS-1016 : Failed to resolve Single Client Access Name cluscan.us.oracle.com
原因
1. 分配不正确的SCAN IP.
2. 服务器网络配置问题.
3. DNS SCAN 名字定义问题.
解决方案:
请参考下面的Note的解决方案:
1. Installing 11gR2 Grid Infrastructure Fails with INS-40719 Scan Already Assigned To Another SystemNote 955636.1
2. INS-41105: subnet chosen as public does not match subnet of SCAN VIP Note 1540546.1
3. PRVF-4664 PRVF-4657: Found inconsistent name resolution entries for SCAN name Note 887471.1
问题 6:SCAN VIP 或 SCAN LISTENER是OFFLINE / UNKNOWN状态
crsctl stat res -t shows
ora.scan1.vip 1 ONLINE UNKNOWN racnode2 CHECK TIMED OUT
or
ora.scan1.vip 1 ONLINE OFFLINE racnode2
原因
1. 网络配置问题
2. Bug 14179376 - SCAN VIP GOES OFFLINE INTERMITTENTLY
3. Solaris IPMP 有关问题
4. AIX LHEA 有关问题
5. Windows Bug 13371153 - Windows: SCAN VIP fail ping after relocate even with new arp driver (patch 10124639)
6. Bug 14259185 - WINDOWS: vip and scan vips fail back not pingable in win2008r2
解决方案:
请参考下面的Note的解决方案:
1. SCAN VIP Showing Status UNKNOWN - CHECK TIMED OUT On One Node Note 1341882.1
2. SCAN VIP GOES OFFLINE INTERMITTENTLY Note 1544475.1
3. Solaris: 11gR2 VIP / SCAN VIP and Dependent Resources Offline after Active Public NIC in IPMP Group Fails Note 1069254.1
4. AIX: VIP and SCAN VIP fails to failover to other node after pulled cable on public network if LHEA is being used Note 1530943.1
5. RAC on Windows: Relocate SCAN (and node VIP) Not Working In Timely Manner (Bug:13371153/10124639) Note 1423313.1
6. WINDOWS: vip and scan vips fail back not pingable in win2008r2 Note 14259185.8