Connection to RAC database and Listener Log files
Hi,
We have a 2 node RAC 11.2.0.3 database on Linux X64
There are 3 SCAN listeners out of which one is running on node-1 and two running on node-2
We have multiple (java) clients that connects to database using the following connection string
jdbc:oracle:oci:@(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE = ON)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.17)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.18)(PORT = 1521)) )
(CONNECT_DATA =
(SERVICE_NAME = app.kusdcn.net)
(FAILOVER_MODE=
(METHOD=BASIC)
(TYPE=SELECT) ) ))
Now we are trying to determine the client connection frequnecy / connection errors using the listener log files
But when we look at the SCAN_LISTENERS(1 thru 3) log files, they were last updated about a month ago or so
0