changing ODS password in OID

[oracle@oracle bin]$ opmnctl startall
opmnctl startall: starting opmn and all managed processes...
================================================================================
opmn id=orasystemsusa.com:6701
    0 of 1 processes started.
ias-instance id=asinst_1
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
    oid1/oidmon/OID/
Error
--> Process (index=1,uid=90987534,pid=25146)
    time out while waiting for a managed process to start
    Log:
    /u01/Middleware/asinst_1/diagnostics/logs/OID/oid1/console~OID~1.lo




at oidmon-0000.log below error


OID] [NOTIFICATION:16] [] [OIDMON] [host: orasystemsusa.com] [pid: 5941] [tid: 0] Guardian: Connecting to database, connect string is oiddb

 [OID] [NOTIFICATION:16] [] [OIDMON] [host: orasystemsusa.com] [pid: 5941] [tid: 0] Guardian: [gsdsiConnect] ORA-28002, ORA-28002: the password will expire within 7 days


 [OID] [NOTIFICATION:16] [] [OIDMON] [host: orasystemsusa.com] [pid: 5941] [tid: 0] Guardian: [oidmon]: Unable to connect to database, will retry again after 10 sec


at database it shows
SQL> select account_status,profile from dba_users where username='ODS';

ACCOUNT_STATUS                   PROFILE
-------------------------------- ------------------------------
EXPIRED(GRACE)                   DEFAULT


and when connecting you will get below error

SQL> connect ods/password1
ERROR:
ORA-28002: the password will expire within 4 days


Connected.

Issue:
when ODS schema user shows that password is EXPIRED, it will not start opmnctl services


Solution:

update ODS password by following below steps


lways set the env variables correctly prior to using any command line tools:

export ORACLE_HOME=

export ORACLE_SID=
export

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/ldap/bin:$PATH

(path must always have OID home dir's first in the list)


Go to the $ORACLE_HOME/ldap/admin directory.

Rename the oidpwdlldap1 and oidpwddrxxxx files, where xxxx is the instance name.

Login to the OID database via sql*plus as the user system.

Reset the ODS schema password:

SQL> alter user ods identified by <password>

Issue the oidpasswd create_wallet = truecommand to recreate the files you renamed in step 2.

oidpasswd connect=<connect string> create_wallet = true

Then run oidpasswdto reset the password to the same as you set with the Alter command via sql*plus in step 4, as follows:

% oidpasswd connect=<connect string> change_oiddb_pwd=true