1. ORABPEL or ORAESB are schema in SOA dehydration store (SOA Suite database)
2. Changing ORABPEL, ORAESB or ORAWSM schema is two step process (Three if SOA suite is integrated with OID)
2.1 Change schema password in database (SQL> alter user <orabpel/oraesb/orawsm> identified by <newpassword>;)
2.2 Change schema password in middle tier configuration file ($ORACLE_HOME/ j2ee/ oc4j_soa/ config/ system-jazn-data.xml)
for ORABPEL
Change below content
<name>pwForOrabpel</name>
<guid>4F87BD301E0111DEAF4575069469A904</guid>
<credentials>{903}309wIYgWZhq5YvC47p8Kd1+R+0hg+EQ0</credentials>
To
<name>pwForOrabpel</name>
<guid>4F87BD301E0111DEAF4575069469A904</guid>
<credentials>!newpassword</credentials>
Note* ! mark in front which denotes unencrypted text
For ORAESB
Change below content
<name>pwdforOraesb</name>
<guid>D997E5101DFF11DE9F0075069469A904</guid>
<credentials>{903}M+n1vqVNCbUffSBAp1bZh+RknVLfdpwU</credentials>
To
<name>pwdforOraesb</name>
<guid>D997E5101DFF11DE9F0075069469A904</guid>
<credentials>!newpassword</credentials>
2.3 In OID (optional – only if SOA suite is integrated with OID)
Start OIDADMIN and change password under cn=OracleContext, cn=Products, cn=IAS, cn=IAS Infrastructure Databases, orclReferenceName = dbname for the Metadata Repository.
3. Restart application server like
opmnctl stopall; opmnctl startall
(This step will encrypt password in config file system-jazn-data.xml)
.
References