WA server status show connection failed ORA-12557

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - System Agent (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent
• CA Workload Automation AE

Issue/Introduction

The  WA server show some errors while startup after oracle server version upgrade from 18 to version 19, the oracle client on Workload Automation AE server did not change

[04/16/2020 15:58:42]     CAUAJM_I_40275 Log Rollover level set to <MIDNIGHT,SIZE(100),PURGE(7)>.

[04/16/2020 15:58:42]     CAUAJM_I_40244 EnableIPCaching value set to <1>.

[04/16/2020 15:58:42]     CAUAJM_I_40244 LogMaxEndLines value set to <2,000>.

[04/16/2020 15:58:42]     CAUAJM_I_10655 System is running in single server mode.  Event server:  AEDBSDC.

[04/16/2020 15:58:45]     CAUAJM_E_18407 Failed to connect to Oracle server: AEDBSDC

[04/16/2020 15:58:45]     CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.

[04/16/2020 15:58:45]     CAUAJM_E_18401 Function <Olog> invoked from <openProc> failed <154>

[04/16/2020 15:58:45]     CAUAJM_E_18402 ORA-12557: TNS:protocol adapter not loadable

[04/16/2020 15:58:45]     CAUAJM_E_10649 Server AEDBSDC was not available during connection operation.

[04/16/2020 16:00:39]     CAUAJM_E_18407 Failed to connect to Oracle server: AEDBSDC

[04/16/2020 16:00:39]     CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.

[04/16/2020 16:00:39]     CAUAJM_E_18401 Function <Olog> invoked from <openProc> failed <154>

[04/16/2020 16:00:39]     CAUAJM_E_18402 ORA-12557: TNS:protocol adapter not loadable

[04/16/2020 16:00:39]     CAUAJM_E_10649 Server AEDBSDC was not available during connection operation.

[04/16/2020 16:01:39]     CAUAJM_E_18407 Failed to connect to Oracle server: AEDBSDC

[04/16/2020 16:01:39]     CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.

[04/16/2020 16:01:39]     CAUAJM_E_18401 Function <Olog> invoked from <openProc> failed <154>

[04/16/2020 16:01:39]     CAUAJM_E_18402 ORA-12557: TNS:protocol adapter not loadable

[04/16/2020 16:01:39]     CAUAJM_E_10649 Server AEDBSDC was not available during connection operation.

[04/16/2020 16:02:39]     CAUAJM_E_18407 Failed to connect to Oracle server: AEDBSDC

[04/16/2020 16:02:39]     CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.

[04/16/2020 16:02:39]     CAUAJM_E_18401 Function <Olog> invoked from <openProc> failed <154>

[04/16/2020 16:02:39]     CAUAJM_E_18402 ORA-12557: TNS:protocol adapter not loadable

[04/16/2020 16:02:39]     CAUAJM_E_10649 Server AEDBSDC was not available during connection operation.

[04/16/2020 16:03:39]     CAUAJM_E_18407 Failed to connect to Oracle server: AEDBSDC

[04/16/2020 16:03:39]     CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.

[04/16/2020 16:03:39]     CAUAJM_E_18401 Function <Olog> invoked from <openProc> failed <154>

[04/16/2020 16:03:39]     CAUAJM_E_18402 ORA-12557: TNS:protocol adapter not loadable

[04/16/2020 16:03:39]     CAUAJM_E_10649 Server AEDBSDC was not available during connection operation.

[04/16/2020 16:04:39]     CAUAJM_E_18407 Failed to connect to Oracle server: AEDBSDC

[04/16/2020 16:04:39]     CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.

[04/16/2020 16:04:39]     CAUAJM_E_18401 Function <Olog> invoked from <openProc> failed <154>

[04/16/2020 16:04:39]     CAUAJM_E_18402 ORA-12557: TNS:protocol adapter not loadable

[04/16/2020 16:04:39]     CAUAJM_E_10649 Server AEDBSDC was not available during connection operation.

 

Environment

Release : 11.3.6 SP6

Component : CA Workload Automation AE (AutoSys)

Resolution

The Oracle error ORA-12557 in windows is caused due to the incorrect setting of ORACLE_HOME variable.

After setting the ORACLE_HOME to point to the correct location in Windows Environment variables the problem was resolved.

Additional Information

For more details you can refer to this article

http://www.dba-oracle.com/t_ora_12577.htm