Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Ora-12545 error in using SCAN of Oracle 11g Release 2 RAC

492296Jul 5 2010 — edited Nov 28 2012
Hi All,

I have succesfully installed 2 nodes RAC but unfortunately I'm receiving ORA-12545 Connect failed bacause target host or object does not exists in using SCAN.

Here's my configuration.

Global Database Name:oradb.bluecluster.com
SID Name:oradb

My connection properties using SqlDeveloper

jdbc:oracle:thin:@rac-scan.bluecluster.com:1521/oradb.bluecluster.com

Oracle Version:

SQL> select * from v$version;

BANNER
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Productio

In DNS

#Public
192.168.30.201 rac1.bluecluster.com rac1
192.168.30.202 rac2.bluecluster.com rac2

#Virtual
192.168.30.203 rac1-vip.bluecluster.com rac1-vip
192.168.30.204 rac2-vip.bluecluster.com rac2-vip

#Scan
192.168.30.205 rac-scan.bluecluster.com rac-scan
192.168.30.206 rac-scan.bluecluster.com rac-scan
192.168.30.207 rac-scan.bluecluster.com rac-scan

In RAC1:
local_listener =(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip.bluecluster.com)(PORT=1521))))
remote_listener =rac-scan.bluecluster.com:1521

In RAC2:
local_listener =(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip.bluecluster.com)(PORT=1521))))
remote_listener =rac-scan.bluecluster.com:1521

[oracle@rac1 ~]$ srvctl config scan

SCAN name: rac-scan.bluecluster.com, Network: 1/192.168.30.0/255.255.255.0/eth6
SCAN VIP name: scan1, IP: /192.168.30.207/192.168.30.207
SCAN VIP name: scan2, IP: /rac-scan.bluecluster.com/192.168.30.205
SCAN VIP name: scan3, IP: /192.168.30.206/192.168.30.206

[oracle@rac1 ~]$ srvctl status scan

SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac2
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node rac1
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node rac1

[oracle@rac1 ~]$ srvctl config scan_listener;

SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521

[oracle@rac1 ~]$ srvctl status scan_listener;

SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node rac1
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node rac1

Really appreciate if you can share your experiences in a successful SCAN connection.

Regards,
Benjie

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 26 2012
Added on Jul 5 2010
#jdbc, #performance-availability, #rac-asm-clusterware-installation
13 comments
12,049 views