Unable to start WP/CP processes after changing a Database password
Article ID: 89034
Updated On:
Products
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:
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.
Feedback
