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

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Environment

Release: AUTWAB99000-10.0-Automic Workload Automation-Base Edition
Component:

Resolution

Symptoms

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.111 - U0003545 UCUDB: Opening database <85>

20150219/082302.111 - U0029112 UCUDB - Length of the DB-History area: 100

20150219/082302.606 - U0029108 UCUDB: SQL_ERROR Database handles DB-HENV: 278df90 DB-HDBC: 0

20150219/082302.606 - U0003591 UCUDB - DB error info: OPC: 'OCILogon' Return code: 'ERROR'

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'

20150219/082302.606 - U0003611 DB OPEN executed. Return Code = '0000003590'

20150219/082302.606 - U0003620 Routine 'UCMAIN_R' forces trace because of error.

20150219/082302.606 - U0003450 The TRACE file was opened with the switches '0000000000000001'.

20150219/082302.606 - U0003380 Server '%' version '%' (Runtime '0/00:00:01', Log# '1', Trc# '1').

20150219/082302.607 - U0003491 There is a time difference of '0/00:00:00' or '0' seconds to the Primary Server.

20150219/082302.607 - U0003375 Server usage of the last minute '0%', the last 10 minutes '0%' and the last hour '0%'.

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

20150219/082302.641 - U0003449 Output to the TRACE file is finished.

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

20150219/082302.737 - U0003410 UC4.Server '%' version '%' ended abnormally.

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]@DSN

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:

http://docs.automic.com/documentation/AE/10.0.4/english/AE_WEBHELP/help.htm#ucaber.htm

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.