Hello,
We have a couple of issues when attempting to upgrade to R12.
During the R12 upgrade, received the following error:
[CAUAJM_E_112508] An error occurred while connecting to the "<name of database>" database
server.
java.sql.SQLRecoverableException: IO Error: could not resolve the connect
identifier "<database service name>"
Able to connect to the db from that server with no problem manually and the server was previously functioning just fine so previous to this and outside of the install, the app was connecting just fine.
Release : 11.3.6 SP8 CUM1
Component : CA Workload Automation AE (AutoSys)
Operating System: Redhat7
The tnsnames.ora file was not formatted correctly for the database used for AutoSys. This was observed using Zulu JRE.
To resolve the oracle error messages that was causing the R12 upgrade to fail, updated the tnsnames.ora file
From:
<database name> =
(DESCRIPTION = (ENABLE = BROKEN)(CONNECT_TIMEOUT = 90)(RETRY_COUNT = 30)(RETRY_DELAY = 3)
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname where database resides>)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <database name>)
)
To:
<database name> =
(DESCRIPTION =
(ENABLE = BROKEN)
(CONNECT_TIMEOUT = 90)
(RETRY_COUNT = 30)
(RETRY_DELAY = 3)
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname where database resides>)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <database name>)
)
)