Hello, we are experiencing this same exact situation after an Oracle client upgrade from Client 11.2 32-bit to Oracle Client 12.2 32-bit on our Secondary Scheduler in Production. Only thing is we are running Scheduler on Windows with Oracle vs. Linux with Oracle as in the above example.
This same upgrade went seamless in Development. ORACLE_HOME, TNS_ADMIN paths in Administrator console are accurate. Tnsping works fine, chk_auto_up runs OK, however, App Server fails to restart. Both the DB as well as the Scheduler servers were rebooted and still no luck with App Server starting up.
Here's chk_auto_up output:
E:\SrvApps\CA\Workload Automation AE>chk_auto_up
______________________________________________________________________________
CAUAJM_E_10029 Communication attempt with the CA WAAE Application Server has failed! [gaxgpba57:9000]
CAUAJM_I_50054 Attempting (1) to Connect with Database: pnhap209
CAUAJM_I_50055 *** Have Connected successfully with Database: pnhap209. ***
______________________________________________________________________________
CAUAJM_I_50128 Connected with Event Server: pnhap209
______________________________________________________________________________
______________________________________________________________________________
CAUAJM_E_10029 Communication attempt with the CA WAAE Application Server has failed! [gaxgpba57:9000]
CAUAJM_I_50038 Checking CA WAAE Primary Scheduler on Machine: GAXGPBA56.southernco.com
CAUAJM_I_50044 Primary Scheduler is RUNNING on machine: GAXGPBA56.southernco.com
______________________________________________________________________________
E:\SrvApps\CA\Workload Automation AE>
tnsping output:
E:\SrvApps\CA\Workload Automation AE>tnsping pnhap209
TNS Ping Utility for 32-bit Windows: Version 12.2.0.1.0 - Production on 25-OCT-2021 20:00:09
Copyright (c) 1997, 2016, Oracle. All rights reserved.
Used parameter files:
E:\Southern\DBConnectivity\Oracle\Network\Admin\sqlnet.ora
Used LDAP adapter to resolve the alias
Attempting to contact (description=(connect_timeout=5)(transport_connect_timeout=3)(retry_count=3)(address_list=(address=(protocol=tcp)(host=lrxgpor062pr-scan.southernco.com)(port=3020)))(connect_data=(service_name=pnhap209_app_user.world)(ur=a)))
OK (0 msec)
E:\SrvApps\CA\Workload Automation AE>
Here's an excerpt of
App Server log:
CA WAAE Application Server Log [10/25/2021 19:54:18]
Time Message
------------------------- ------------------------------------------------------------------------------
[10/25/2021 19:54:18] CAUAJM_I_40275 Log Rollover level set to <MIDNIGHT,SIZE(100),PURGE(7)>.
[10/25/2021 19:54:18] CAUAJM_I_40244 EnableIPCaching value set to <1>.
[10/25/2021 19:54:18] CAUAJM_I_40244 LogMaxEndLines value set to <2,000>.
[10/25/2021 19:54:18] CAUAJM_I_10655 System is running in single server mode. Event server: pnhap209_app_user.world.
[10/25/2021 19:54:20] CAUAJM_E_18407 Failed to connect to Oracle server: pnhap209_app_user.world
[10/25/2021 19:54:20] CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
[10/25/2021 19:54:20] CAUAJM_E_18401 Function <Olog> invoked from <openProc> failed <160>
[10/25/2021 19:54:20] CAUAJM_E_18402 ORA-12154: TNS:could not resolve the connect identifier specified
[10/25/2021 19:54:20] CAUAJM_E_10649 Server pnhap209_app_user.world was not available during connection operation.
[10/25/2021 19:55:20] CAUAJM_E_18407 Failed to connect to Oracle server: pnhap209_app_user.world
[10/25/2021 19:55:20] CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
[10/25/2021 19:55:20] CAUAJM_E_18401 Function <Olog> invoked from <openProc> failed <160>
[10/25/2021 19:55:20] CAUAJM_E_18402 ORA-12154: TNS:could not resolve the connect identifier specified
[10/25/2021 19:55:20] CAUAJM_E_10649 Server pnhap209_app_user.world was not available during connection operation.
[10/25/2021 19:56:20] CAUAJM_E_18407 Failed to connect to Oracle server: pnhap209_app_user.world
[10/25/2021 19:56:20] CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
[10/25/2021 19:56:20] CAUAJM_E_18401 Function <Olog> invoked from <openProc> failed <160>
[10/25/2021 19:56:20] CAUAJM_E_18402 ORA-12154: TNS:could not resolve the connect identifier specified
[10/25/2021 19:56:20] CAUAJM_E_10649 Server pnhap209_app_user.world was not available during connection operation.
Original Message:
Sent: 05-03-2013 12:27 AM
From: Mark Hanson
Subject: App Server can't connect to oracle DB
This seems like an Oracle client configuration issue.
Make sure you are using a 32 bit Oracle client.
Also check the Oracle settings in $AUTOUSER/autosys.sh.$hostname. For the aslibs= line, ensure that the $ORACLE_HOME/lib definition is pointing to the correct 32 bit Oracle client.
If this continues to be an issue please open a case with support.