We are faced with the fact that we get a connection error when the application works in the container and we connect to the scan address (RAC). But if we connect to individual nodam, then everything works fine.
This connection line works without problems:
User Id=TEST;
Data Source=(DESCRIPTION=
(TRANSPORT_CONNECT_TIMEOUT=1)
(CONNECT_TIMEOUT=2)(RETRY_COUNT=0)
(ADDRESS_LIST =
(LOAD_BALANCE=off)
(ADDRESS = (PROTOCOL = TCP)(HOST=oraprb01.prb.pmr)(PORT=1521))
(ADDRESS = (PROTOCOL = TCP)(HOST=oraprb02.prb.pmr)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME = odaodb)));
This connection line very often gives the exception of "Connect Timeout Occurred"
User Id=TEST;
Data Source=(DESCRIPTION=
(TRANSPORT_CONNECT_TIMEOUT=1)
(CONNECT_TIMEOUT=2)(RETRY_COUNT=0)
(ADDRESS_LIST =
(LOAD_BALANCE=off)
(ADDRESS = (PROTOCOL = TCP)(HOST=oraprb-scan.prb.pmr)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME = odaodb)));
I attached a trace file.
1.log