Hi I am using Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production. Its a three node RAC.
Recently we have migrated to new linux hardware from AIX and we started seeing intermittent ORA-12545 connection lost issue, that too from one specific application, but not from all applications. So we rerun the jobs, then it works fine. So need expert advice to fix this issue permanently.
ERROR DETAILS:
---------------
The connector could not establish connection to Oracle server PRODDB.
Method: OCIServerAttach, Error code: 12,545, Error message ORA-12545: Connect failed because target host or object does not exist.
DB server side tns entry:
PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = prod-scan)(PORT = 1004))
(CONNECT_DATA =
(UR=A)
(SERVER = DEDICATED)
(SERVICE_NAME = service1)
)
)
App server/client side TNS entry:
PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = prod-scan)(PORT = 1004))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = service1)
)
)