GRID and database version: 11.2.0.1OS: Solaris5.10 symptom: Error sqlplussystemOracle@210.10.4.5: 1521 pdptO reported when the client is connected to scanip
GRID and database version: 11.2.0.1 OS: Solaris 5.10 symptom: sqlplus system/Oracle@210.10.4.5: 1521/pdpt O error reported when client connection scan ip
GRID and database version: 11.2.0.1
OS: Solaris 5.10
Symptom: an error is reported when the client connects to the scan ip address.
Sqlplus system/Oracle@210.10.4.5: 1521/pdpt
ORA-12545: the connection failed because the target host or object does not exist
However, the scan ip address can be connected between two database servers.
# Cat/etc/hosts
: 1 localhost
127.0.0.1 localhost
210.10.4.5 taian-pt-d1 loghost
Taian-pt-d2 210.10.4.6
Taian-pt-d1-vip 210.10.4.9
Taian-pt-d2-vip 210.10.4.10
210.10.4.7 pdpt-cluster-scan
192.168.2.1 taian-pt-d1-priv.
192.168.2.2 taian-pt-d2-priv.
After checking that the scan ip listener is normal, the client can ping the scan ip Address
-Bash-3.2 $ crs_stat-trac resource service is normal
Name Type Target State Host
------------------------------------------------------------
Ora. ARCHDG. dg ora... up. type ONLINE taian-pt-d1
Ora. DATADG. dg ora... up. type ONLINE taian-pt-d1
Ora... ER. lsnr ora... er. type ONLINE taian-pt-d1
Ora... N1.lsnr ora... er. type ONLINE taian-pt-d2
Ora. OCRVT. dg ora... up. type ONLINE taian-pt-d1
Ora. asm ora. asm. type ONLINE taian-pt-d1
Ora. eons ora. eons. type ONLINE taian-pt-d1
Ora. gsd ora. gsd. type OFFLINE
Ora... network ora... rk. type ONLINE taian-pt-d1
Ora. Solaris ora. productname. type OFFLINE
Ora. ons ora. ons. type ONLINE taian-pt-d1
Ora. pdpt. db ora... se. type ONLINE taian-pt-d1
Ora. scan1.vip ora... ip. type ONLINE taian-pt-d2
Ora... SM1.asm application ONLINE taian-pt-d1
Ora... D1.lsnr application ONLINE taian-pt-d1
Ora...-d1.gsd application OFFLINE
Ora...-d1.ons application ONLINE taian-pt-d1
Ora...-d1.vip ora... t1.type ONLINE taian-pt-d1
Ora... SM2.asm application ONLINE taian-pt-d2
Ora... D2.lsnr application ONLINE taian-pt-d2
Ora...-d2.gsd application OFFLINE
Ora...-d2.ons application ONLINE taian-pt-d2
Ora...-d2.vip ora... t1.type ONLINE taian-pt-d2
-Bash-3.2 $ lsnrctl status LISTENER_SCAN1scan IP listener normal
LSNRCTL for Solaris: Version 11.2.0.1.0-Production on 06-MAR-2012 09:36:50
Copyright (c) 1991,200 9, 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> the local_listener parameter of the show parameter listener database instance is the vip host name.
NAME TYPE VALUE
-----------------------------------------------------------------------------
Listener_networks string
Local_listener string (DESCRIPTION = (ADDRESS_LIST = (AD