TNS-12516: TNS:listener could not find available handler with matching protocol stack
Hi,
I get this error when one listener is down in my 2 node RAC, and I try to get a new db-connection through a jdbc-client
with connection string: jdbc:oracle:thin:@(DESCRIPTION= (ADDRESS_LIST= (FAILOVER=ON)\
(ADDRESS=(PROTOCOL=TCP)(HOST=node1-vip)(PORT=1521)) \
(ADDRESS=(PROTOCOL=TCP)(HOST=node2-vip)(PORT=1521))) \
(CONNECT_DATA=(service_name=DB_SERVICE))))
The remaining listener should give me a connection to my db service DB_SERVICE I think, but it doesn't.
The RAC config. is active-active not active-passive.
I'm trying to get a connection through the remaining listener LISTENER_RAC1 on node rac1
to a db-service, DB_SERVICE on node rac2, shouldn't that work?
with connection string: jdbc:oracle:thin:@(DESCRIPTION= (ADDRESS_LIST= (FAILOVER=ON)\
(ADDRESS=(PROTOCOL=TCP)(HOST=node1-vip)(PORT=1521)) \
(ADDRESS=(PROTOCOL=TCP)(HOST=node2-vip)(PORT=1521))) \
(CONNECT_DATA=(service_name=DB_SERVICE))))
The remaining listener should give me a connection to my db service DB_SERVICE I think, but it doesn't.
The RAC config. is active-active not active-passive.
I'm trying to get a connection through the remaining listener LISTENER_RAC1 on node rac1
to a db-service, DB_SERVICE on node rac2, shouldn't that work?
0