Oracle Database Discussions

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!

RAC 12C problem to connect to the second node in case of failling of the first

kaelemMay 29 2019 — edited May 29 2019

I have a rac 12.1.0.2 Enterprise with 2 nodes under Windows 2012 R2 64 bits.

I have a DB with db_unique_name = RACPRODK, with two instances, K1 and K2.

Then, I have a cluster resource named :

ora.racprodk.db

1 ONLINE ONLINE plutonium Open,STABLE

2 ONLINE ONLINE uranium Open,STABLE

I would like to configure client tnsnames.ora to connect firstly to node1, plutonium, and after in case of node1 failuren, to node 2:

RACPRODK_K_two.ARTE.GEIE =

(DESCRIPTION=

(SOURCE_ROUTE=yes)

(ADDRESS=(PROTOCOL=tcp)(HOST=prod-node1-vip.strg.arte)(PORT=1521)) # hop 1

(ADDRESS_LIST=

(FAILOVER=on)

#(LOAD_BALANCE=off) # hop 2

(ADDRESS=(PROTOCOL=tcp)(HOST=prod-node2-vip.strg.arte)(PORT=1521)) # hop 2

)

(CONNECT_DATA=(SERVICE_NAME=RACPRODK))

)

But when I shutdown K1, the client cannot connect to the second HOP.

He have an

ORA-12514: TNS:listener does not currently know of service

From the node 1, I can do :

K1:F:\ORACLE\DBBASE\product\12.1.0\dbhome_1>lsnrctl status

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 29-MAY-2019 15:10:22

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production

Start Date 29-MAY-2019 08:43:00

Uptime 0 days 6 hr. 27 min. 25 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File F:\ORACLE\PRODUCTS\12.1.0\GRID\network\admin\listener.ora

Listener Log File F:\ORACLE\GRIDBASE\diag\tnslsnr\PLUTONIUM\listener\alert\log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\LISTENERipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.25.4.251)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.25.4.252)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=PLUTONIUM.mail.strg.arte)(PORT=5501))(Security=(my_wallet_directory=F:\ORACLE\DBBASE\admin\RACSTO\xdb_wallet))(Presentation=HTTP)(Session=RAW))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=PLUTONIUM.mail.strg.arte)(PORT=5502))(Security=(my_wallet_directory=F:\ORACLE\DBBASE\admin\RACWEB\xdb_wallet))(Presentation=HTTP)(Session=RAW))

Services Summary...

Service "+ASM" has 1 instance(s).

Instance "+asm1", status READY, has 1 handler(s) for this service...

Service "CCESTO.ARTE.GEIE" has 1 instance(s).

Instance "sto1", status READY, has 1 handler(s) for this service...

Service "K" has 1 instance(s).