Hi All,
When I connect to RAC database from a remote node, I get the below message :
[oracle@voice ~]$ sqlplus user1/passwd1@rac_scan
SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 9 20:34:13 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Enter user-name:
But, tnsping outputs proper result :
[oracle@voice ~]$ tnsping rac_scan
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 09-SEP-2014 20:34:01
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (CONNECT_TIMEOUT = 10) (RETRY_COUNT = 3) (ADDRESS_LIST = (LOAD_BALANCE=ON) (FAILOVER=ON) (ADDRESS = (PROTOCOL = TCP)(HOST = racnode-cluster-scan)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = racdb.abc.com)))
OK (60 msec)
tnsnames.ora entry on the remote node is below :
rac_scan =
(DESCRIPTION =
(CONNECT_TIMEOUT = 10)
(RETRY_COUNT = 3)
(ADDRESS_LIST =
(LOAD_BALANCE=ON) (FAILOVER=ON)
(ADDRESS =
(PROTOCOL = TCP)(HOST = racnode-cluster-scan)(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb.abc.com)
)
)
ping works as well :
[oracle@voice ~]$ ping racnode-cluster-scan
PING racnode-cluster-scan (192.168.1.187) 56(84) bytes of data.
64 bytes from racnode-cluster-scan (192.168.1.187): icmp_seq=1 ttl=64 time=0.195 ms
64 bytes from racnode-cluster-scan (192.168.1.187): icmp_seq=2 ttl=64 time=0.233 ms
64 bytes from racnode-cluster-scan (192.168.1.187): icmp_seq=3 ttl=64 time=0.242 ms
64 bytes from racnode-cluster-scan (192.168.1.187): icmp_seq=4 ttl=64 time=0.229 ms
--- racnode-cluster-scan ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3000ms
rtt min/avg/max/mdev = 0.195/0.224/0.242/0.025 ms
Output of lsnrctl status listener_scan is below :
[grid@racnode2 ~]$ lsnrctl status listener_scan1
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 09-SEP-2014 20:38:12
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 Linux: Version 11.2.0.1.0 - Production
Start Date 09-SEP-2014 20:14:17
Uptime 0 days 0 hr. 23 min. 55 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u02/app/11.2.0/grid1/network/admin/listener.ora
Listener Log File /u02/app/11.2.0/grid1/log/diag/tnslsnr/racnode2/listener_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.187)(PORT=1521)))
Services Summary...
Service "racdb.abc.com" has 2 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
Instance "racdb2", status READY, has 1 handler(s) for this service...
Service "racdbXDB.abc.com" has 2 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
Instance "racdb2", status READY, has 1 handler(s) for this service...
The command completed successfully
Any idea where I am going wrong?
Thanks,
...