Upgrade ro r12.1 Error

Products

• CA Workload Automation AE

Issue/Introduction

Hi, we have faced an error when trying to upgrade Autosts r11.3.7 to R12:

./instal.bin

===============================================================================
Oracle Properties
-----------------

Specify the 64-bit Oracle details.

Oracle home directory (Default: /oracle/product/19.0/instantclient_19_18):

===============================================================================
Database Validation
-------------------

Error:
[CAUAJM_E_112515] Unable to connect to the "ace" database server using the
database client utility. For more information, refer to the log file.

PRESS <ENTER> TO ACCEPT THE FOLLOWING (OK):

I'm attaching the logs.

 

 

 

 

Environment

Autosyus  12.1.01

Cause

The installer uses a command line operations to SQLPUS Oracle Utility.
On Linux, if the Oracle User password stored in the configuration file has a $ in it, when this is passed to the SQLPLUS utility,
The part after the $ is treated as available by the OS and the operation fails.

Resolution

The installer uses the sqlplus command in the below format for certain activities.
As Dollar ($) has a special meaning on Linux the sqlplus utility fails.
sqlplus "user"/"password"@SID @chk.sql

Example:
sqlplus c5/"sysadmin$var"@AEORA01

in the above example, the Linux shell will try to resolve the $var to some value or empty. which will result in an invalid password.
hence we recommend using any other special character other than Dollar ($).

KB on changing Oracle user password
https://knowledge.broadcom.com/external/article?articleId=121400