Database - RAC/Scalability (MOSC)

MOSC Banner

Connection to RAC database and Listener Log files

edited Jan 18, 2014 3:46AM in Database - RAC/Scalability (MOSC) 6 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center