当前位置:Gxlcms > mysql > 连接scanip出现ORA-12545错误

连接scanip出现ORA-12545错误

时间: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

人气教程排行