Unable to start WP/CP processes after changing a Database password
search cancel

Unable to start WP/CP processes after changing a Database password

book

Article ID: 89034

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Unable to start WP/CP processes after changing a Database password.

When attempting to start the WPs or CPs after a database password change, the process fails and the following shows in the logs:

20150219/082302.606 - U0003592 UCUDB - Status: '' Native error: '1017' Msg: 'ORA-01017: invalid username/password; logon denied'

20150219/082302.606 - U0003590 UCUDB - DB error: 'OCILogon', 'ERROR   ', '', 'ORA-01017: invalid username/password; logon denied'

Environment

Automation Engine 12.3.x, 21.x and 24.x

Cause

An incorrect password has been specified, or a correct password has been encrypted incorrectly.

Resolution

The first step for checking issues such as the above will be to place the password in plain text in the ucsrv.ini file under the [ODBC] section, such as the example below:

SQLDRIVERCONNECT=ODBCVAR=SNNNNNRN,DSN=local;UID=AutomicUser;PWD=PlainPassword1

This username/password should be able to log into SQLPlus with the same information such as in the example below:

sqlplus [username]/[password]@DS

If this does not work, please double-check the password and re-enter it. If the password works at this point, it may be that the password was encrypted incorrectly. Automic documentation has steps provided on this procedure, which can be found at the link below:

https://docs.automic.com/documentation/webhelp/english/AA/24.0/DOCU/24.0/Automic%20Automation%20Guides/Content/AWA/Admin/admin_EncodingPasswords.htm?Highlight=%20UCYBCRYP.EXE%20

The file UCYBCRYP.EXE is stored in the directory IMAGE:TOOLS\ENCRYPT. Before going through the procedure, be sure to delete the "password.ucc" file that's in the same directory. Afterwards, use the following parameters to enter the program via the command line (ensuring replacement of the example password):

UCYBCRYP[.EXE] -p -n PlainPassword1

The file PASSWORD.UCC which contains the encoded password is created in the same directory. The encoded password can now be copied to the INI file.