OIM - How to change schema password when it got expired.

To view schema name and status: 

 

SELECT username, account_status FROM dba_users;

 

Change Schema Password:

 

Case 1: If password is known to you :-

For 11gR2PS3 :
ALTER USER <Schema_Name>_OIM IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_OPSS IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_ORASDPM IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_SOAINFRA IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_BIPLATFORM IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_MDS IDENTIFIED BY <Password>;

For 11gR2PS2 and 11gR2PS2 :
ALTER USER <Schema_Name>_OIM IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_OPSS IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_ORASDPM IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_SOAINFRA IDENTIFIED BY <Password>;
ALTER USER <Schema_Name>_MDS IDENTIFIED BY <Password>;


Case 2: If you do not know old password and you want to set same password :-

To view old password:
select password from user$ where name='<Schema_Name>_OIM';
<9DFEB538BA32F694>

For 11gR2PS3 :
ALTER USER <Schema_Name>_OIM IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_OPSS IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_ORASDPM IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_SOAINFRA IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_BIPLATFORM IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_MDS IDENTIFIED BY <9DFEB538BA32F694>;

For 11gR2PS2 and 11gR2PS2 :
ALTER USER <Schema_Name>_OIM IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_OPSS IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_ORASDPM IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_SOAINFRA IDENTIFIED BY <9DFEB538BA32F694>;
ALTER USER <Schema_Name>_MDS IDENTIFIED BY <9DFEB538BA32F694>;