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>;

How to Unlock OIM Schema.

To view schema name and status:

SELECT username, account_status FROM dba_users;

Unlock Schema:

ALTER USER <Schema_Name>_OIM ACCOUNT UNLOCK;
ALTER USER <Schema_Name>_MDS ACCOUNT UNLOCK;
ALTER USER <Schema_Name>_OPSS ACCOUNT UNLOCK;
ALTER USER <Schema_Name>_ORASDPM ACCOUNT UNLOCK;
ALTER USER <Schema_Name>_SOAINFRA ACCOUNT UNLOCK;
ALTER USER <Schema_Name>_BIPLATFORM ACCOUNT UNLOCK;

SOA - Configuring BPEL Process Service Engine classpath.

The extra classpath need to be set when compiling bepl generated java source.

 

Login to the em(Enterprise Manager) console and then go to the BEPL Properties as shown in below screen shot:

 

Go to More BEPL Configuration Properties... 

Click on BpelcClasspath.

 

 

Put required classpath in highlighted text box.

Sample value:

MW_HOME/oracle_common/modules/oracle.jps_11.1.1/jps-api.jar:/MW_HOME/oracle_common/modules/oracle.jps_11.1.1/jps-manifest.jar:/MW_HOME/Oracle_IDM1/server/client/oimclient.jar

Click Apply.

 Happy Learning!!!