11.2.0.3 RAC - Connection logging
Hi
We have a 11.2.0.3 2 node RAC database running on Windows 2008
we are using the following tnsnames entry to connect using sqlplus
RAC11203 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.71)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.73)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = apps)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
All the scan listeners are up and running. LISTENER_SCAN1 on node-2 and LISTENER_SCAN2 and SCAN3 on node-1
When we connect to the database, the connection is logged under listener.log file instead of any of the 3 scan listeners. Why is that?
Should not all the connections be logged under SCAN listeners log files?
We have a 11.2.0.3 2 node RAC database running on Windows 2008
we are using the following tnsnames entry to connect using sqlplus
RAC11203 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.71)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.73)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = apps)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
All the scan listeners are up and running. LISTENER_SCAN1 on node-2 and LISTENER_SCAN2 and SCAN3 on node-1
When we connect to the database, the connection is logged under listener.log file instead of any of the 3 scan listeners. Why is that?
Should not all the connections be logged under SCAN listeners log files?
0