Trying to upgrade from 11.3.6 SP8 to 12.0 on our Qualification environment.
The upgrade went successfully on our LAB environment, but not in QA.
Install 64b oracle client version HC-22.214.171.124
-Define entry in tnsnames.ora (since it's mandatory during the installation, we don't use it otherwise)
ORACL=(DESCRIPTION_LIST=(LOAD_BALANCE=OFF) (FAILOVER=ON) (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3) (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORACL)))(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORACL))))
sqlplus aedbadmin/[email protected] -> works
Launch the installation -> FAILED with the message
[CAUAJM_E_112508] An error occurred while connecting to the "ORACL" database
java.sql.SQLRecoverableException: IO Error: SO Exception was generated
When an installer runs database check validates database connection through jdbc jar file, so it expects tnsnames.ora file in correct format otherwise it treats as invalid tnsnames file.
Release : 12.0
Component : WORKLOAD CONTROL CENTER
To resolve the error, need to update tnsnames.ora file entries in correct format.
below example would help:
net_service_name= (DESCRIPTION= (ADDRESS=()) (CONNECT_DATA= (SERVICE_NAME= )))