[Support tip] - OMU server procs cannot be started when Oracle user pass expires

[Aleherma]

With Oracle 11g, password aging is enabled by default and passwords expire in half a year.
If the password of the Oracle user opc_op expires, the OMU processes are no longer able
to connect to Oracle.

To change the password in the database and in the OMU password file, call opcdbpwd:
# /opt/OV/bin/OpC/opcdbpwd -set

Because of an Oracle defect (Bug 7462851) the opc_op password has to be set manually as well.
IMPORTANT: be sure to use the same password as for "/opt/OV/bin/OpC/opcdbpwd -set" command:
# su - oracle
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> alter user opc_op identified by <password>;
SQL> exit

Update the password in the admin GUI as well:

# /opt/OV/OMU/adminUI/adminui clean
# /opt/OV/OMU/adminUI/adminui password -u ovodb -a -p <password>

After that, the processes should be able to start again. To make sure that processes that were
started before changing the password use the new password, re-start the OMU server processes:
# ovc -kill
# ovc -start

One might also consider changing other Oracle passwords, for example opc_report, sys and system:

# su - oracle
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> alter user opc_report identified by <new-password>;
SQL> alter user system identified by <new-password>;
SQL> alter user sys identified by <new-password>;
SQL> exit

To disable password aging follow these steps:
# su - oracle
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> ALTER PROFILE default LIMIT PASSWORD_LIFE_TIME UNLIMITED;
SQL> exit

For more information about Oracle password aging and password complexity
see the Oracle documentation.