Error when Synchronizing AE HA Databases

Document ID : KB000100850
Last Modified Date : 12/06/2018
Show Technical Document Details
Issue:
When attempting to synchronize the AE HA databases, an error is an error message is displayed stating:

Could not locate /opt/CA/WorkloadAutomationAE/autosys/dbobj/ORA/bin/exp
Now exiting autobcpORA.pl
Environment:
UNIX/Linux OS
Oracle 11.x 12.x database
Workload Automation AE r11.3.6.x
Cause:
An incorrect path to Oracle directory has been specified by the user. The oracle_directory parameter is the value of ORACLE_HOME.

Syntax
perl autobcpORA.pl source_server target_server source_userid source_password target_userid target_password dump_file oracle_directory

Example:
perl autobcpORA.pl pri1 sha1 aedbadmin aedbadmin aedbadmin aedbadmin aetstdb /opt/app/oracle/product/12.2.0/dbhome_1

For more information on this topic, please reference as set forth in https://docops.ca.com/ca-workload-automation-ae/11-4-2/en/administrating/ae-administration/maintain-the-event-server/configure-ca-workload-automation-ae-to-run-in-dual-event-server-mode and navigate to the section titled "autobcpDB Script -- Synchronize Databases"
Resolution:
Correct the parameter specified for oracle_directory so that it reflects the true ORACLE_HOME path. You may need to consult your Oracle DBA to determine the correct value for your environment.