OraFAQ Forum: Networking and Gateways » SCAN Listener issue while connecting to two node RAC

Home » RDBMS Server » Networking and Gateways » SCAN Listener issue while connecting to two node RAC (Oracle 11g 11.2.0.4, Linux 6.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SCAN Listener issue while connecting to two node RAC [message #654088]

Wed, 27 July 2016 01:11

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

Report message to a moderator

Re: SCAN Listener issue while connecting to two node RAC [message #654471 is a reply to message #654088]

Wed, 03 August 2016 07:29

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

Report message to a moderator

Previous Topic:	TNS-12541 TNS no listener issue
Next Topic:	ORA-12224: TNS: no listener

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 17 20:30:23 CST 2024