时间：2021-07-01 10:21:17 帮助过：79人阅读
GRID和数据库版本：11.2.0.1 OS：Solaris 5.10 现象：在客户端连接scan ip时报错 sqlplus system/Oracle@210.10.4.5:1521/pdpt O
GRID和数据库版本：11.2.0.1
OS：Solaris 5.10
现象：在客户端连接scan ip时报错
sqlplus system/Oracle@210.10.4.5:1521/pdpt
ORA-12545: 因目标主机或对象不存在，连接失败
但两台数据库服务器之间连scan ip则没问题
# cat /etc/hosts
::1 localhost
127.0.0.1 localhost
210.10.4.5 taian-pt-d1 loghost
210.10.4.6 taian-pt-d2
210.10.4.9 taian-pt-d1-vip
210.10.4.10 taian-pt-d2-vip
210.10.4.7 pdpt-cluster-scan
192.168.2.1 taian-pt-d1-priv
192.168.2.2 taian-pt-d2-priv
经检查scan ip监听正常，客户端能ping通scan ip
-bash-3.2$ crs_stat -trac资源服务正常
Name Type Target State Host
------------------------------------------------------------
ora.ARCHDG.dg ora....up.type ONLINE ONLINE taian-pt-d1
ora.DATADG.dg ora....up.type ONLINE ONLINE taian-pt-d1
ora....ER.lsnr ora....er.type ONLINE ONLINE taian-pt-d1
ora....N1.lsnr ora....er.type ONLINE ONLINE taian-pt-d2
ora.OCRVT.dg ora....up.type ONLINE ONLINE taian-pt-d1
ora.asm ora.asm.type ONLINE ONLINE taian-pt-d1
ora.eons ora.eons.type ONLINE ONLINE taian-pt-d1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE taian-pt-d1
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
ora.ons ora.ons.type ONLINE ONLINE taian-pt-d1
ora.pdpt.db ora....se.type ONLINE ONLINE taian-pt-d1
ora.scan1.vip ora....ip.type ONLINE ONLINE taian-pt-d2
ora....SM1.asm application ONLINE ONLINE taian-pt-d1
ora....D1.lsnr application ONLINE ONLINE taian-pt-d1
ora....-d1.gsd application OFFLINE OFFLINE
ora....-d1.ons application ONLINE ONLINE taian-pt-d1
ora....-d1.vip ora....t1.type ONLINE ONLINE taian-pt-d1
ora....SM2.asm application ONLINE ONLINE taian-pt-d2
ora....D2.lsnr application ONLINE ONLINE taian-pt-d2
ora....-d2.gsd application OFFLINE OFFLINE
ora....-d2.ons application ONLINE ONLINE taian-pt-d2
ora....-d2.vip ora....t1.type ONLINE ONLINE taian-pt-d2
-bash-3.2$ lsnrctl status LISTENER_SCAN1scan IP监听正常
LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 06-MAR-2012 09:36:50
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN1
Version TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
Start Date 29-FEB-2012 13:42:48
Uptime 5 days 19 hr. 54 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/app/grid_home/network/admin/listener.ora
Listener Log File /home/app/grid_home/log/diag/tnslsnr/taian-pt-d2/listener_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=210.10.4.7)(PORT=1521)))
Services Summary...
Service "PDPT" has 2 instance(s).
Instance "PDPT1", status READY, has 1 handler(s) for this service...
Instance "PDPT2", status READY, has 1 handler(s) for this service...
The command completed successfully
SQL> show parameter listener数据库实例的local_listener参数内容为vip的主机名
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD