Skip to Main Content

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!

RAC Node down and ORA-12514

956426Sep 3 2012 — edited Sep 4 2012
I have a two node rac setup. One Node went down because of hardware issues. And it seems that I cannot connect from client (jdbc) when SCAN gives particular ip.
I receive : ORA-12514, TNS:listener does not currently know of service requested in connect descriptor. If DNS returns the correct ip - everything works fine.

connection string:
jdbc:oracle:thin:@(DESCRIPTION= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=testracscan.internal.int)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=testdb.internal.int)))


Interfaces show that VIPS and SCANS are assigned correctly on Node 1:

-----
vlan65 Link encap:Ethernet HWaddr 2C:76:8A:4F:B5:CC
inet addr:192.168.2.10 Bcast:192.168.2.255 Mask:255.255.255.0
inet6 addr: fe80::2e76:8aff:fe4f:b5cc/64 Scope:Link
UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1
RX packets:937195 errors:0 dropped:0 overruns:0 frame:0
TX packets:852745 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:186434457 (177.7 MiB) TX bytes:141217705 (134.6 MiB)

vlan65:1 Link encap:Ethernet HWaddr 2C:76:8A:4F:B5:CC
inet addr:192.168.2.25 Bcast:192.168.2.255 Mask:255.255.255.0
UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1

vlan65:2 Link encap:Ethernet HWaddr 2C:76:8A:4F:B5:CC
inet addr:192.168.2.35 Bcast:192.168.2.255 Mask:255.255.255.0
UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1

vlan65:3 Link encap:Ethernet HWaddr 2C:76:8A:4F:B5:CC
inet addr:192.168.2.30 Bcast:192.168.2.255 Mask:255.255.255.0
UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1

vlan65:4 Link encap:Ethernet HWaddr 2C:76:8A:4F:B5:CC
inet addr:192.168.2.110 Bcast:192.168.2.255 Mask:255.255.255.0
UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1

vlan65:5 Link encap:Ethernet HWaddr 2C:76:8A:4F:B5:CC
inet addr:192.168.2.115 Bcast:192.168.2.255 Mask:255.255.255.0
UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1

-----
[oracle@srvtestdb1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 03-SEP-2012 15:35:05

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 29-AUG-2012 15:52:57
Uptime 4 days 23 hr. 42 min. 7 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/srvtestdb1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.10)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.110)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "testdb.internal.int" has 1 instance(s).
Instance "testdb1", status READY, has 1 handler(s) for this service...
Service "testdbXDB.internal.int" has 1 instance(s).
Instance "testdb1", status READY, has 1 handler(s) for this service...
Service "testdbsvc.internal.int" has 1 instance(s).
Instance "testdb1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@srvtestdb1 ~]$

-----

SQL> show parameter listener

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.110)(PORT=1521))))
remote_listener string testracscan.internal.int:1521

-----

nslookup testracscan.internal.int
Server: 192.168.0.18
Address: 192.168.0.18#53

Name: testracscan.internal.int
Address: 192.168.2.30
Name: testracscan.internal.int
Address: 192.168.2.25
Name: testracscan.internal.int
Address: 192.168.2.35


Problems arise when client ip is resolved to 192.168.2.35 - i get ORA12514.

When IP is resolved to 192.168.2.110 it simply sits ant waits for a moment and then begins to work, and nestat shows:

tcp 0 0 ::ffff:1 192.168.2.5:51685 ::ffff:192.168.2.110:1521 ESTABLISHED

What might be causing this?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 2 2012
Added on Sep 3 2012
3 comments
646 views