The DB team has migrated the Database to another host.
The DB version is Oracle 188.8.131.52 and Autosys version is R11.3.
We have updated the tnsnames.ora file and the Autosys configuration file to point to the new Oracle SID.
Autosys still does not come up with error:
CAUAJM_E_18407 failed to connect to Oracle server: mutilsys.world
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <Olog> invoked from <openProc> failed <233>
CAUAJM_E_18402 ORA-12154: TNS: could not resolve the connect identifier specified
In the customer environment, there were multiple TNS_NAMES variables pointing to different Oracle environments.
While logged on as "root" or "autosys", the execution of "echo $TNS_ADMIN" was showing another location which also contained a tnsnames.ora file.
But this location was not used by Autosys.
The Autosys environment is set by the the different $AUTOUSER/autosys.*.<host_name> scripts.
In these scripts the TNS_NAMES variable is also set in the "# Set Oracle variables" section and used by Autosys during its startup.
By updating the tnsnames.ora file pointed to by variable $TNS_ADMIN, which is set in the $AUTOUSER/autosys.*.<host_name> script, fixed the problem.
When executing, unisrvcntr start xxxxx , to start Autosys, environment profile $AUTOUSER/autosys.sh.<host_name> is always executed.