Home » RDBMS Server » Networking and Gateways » SCAN Listener issue while connecting to two node RAC (Oracle 11g 11.2.0.4, Linux 6.4)
SCAN Listener issue while connecting to two node RAC [message #654088] Wed, 27 July 2016 01:11 Go to next message
qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan
Member
Hi Experts,

I am getting ORA-12560 while trying to connect a two node RAC.
This is only happening with SCAN IP. With local listeners I can connect with both nodes.
TNSPING is showing this error:

****************************************************************
C:\Users\shahnawazq>tnsping racdb

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 27-JUL-2
016 10:58:31

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:
D:\app\shahnawazq\product\11.2.0\client_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = falcon-scan)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVIC
E_NAME = racdb.ig.com)))
TNS-12560: TNS:protocol adapter error
*************************************************************

Kindly tell me which information you need from me.

Thanks and Regards,
Qazi
Re: SCAN Listener issue while connecting to two node RAC [message #654471 is a reply to message #654088] Wed, 03 August 2016 07:29 Go to previous message
qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan
Member
Thanks to all experts for kind help.

Issue was resolved by changing SCAN IP. In fact Network team gave existing scan ip to another machine. Node 2 was unable to resolve to scan because of ip conflict. When I gave new IP to SCAN then problem gone.

Thanks again for help.

Regards,
Qazi Mohammad Shahnawaz
Previous Topic: TNS-12541 TNS no listener issue
Next Topic: ORA-12224: TNS: no listener
Goto Forum:
  


Current Time: Mon Nov 20 09:24:24 CST 2017

Total time taken to generate the page: 0.01880 seconds