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
- 552400.1 How to Change the Password for ORABPEL and ORAESB Users in Soasuite 10.1.3.x
- 760076.1 How to change orabpel password on Soa Suite 10.1.3.X (No OID)
- 359194.1 How To Manage Orabpel Password
Related Posts for SOA
- Install Oracle SOA Suite : 10.1.3.1.0
- Upgrade Oracle Database to 10.2.0.2 : SOA Suite Install Part II
- Oracle SOA Suite Installation Part I : Database Installation
- Upgrade SOA / OAS to 10.1.3.3.0
- Integrate SSO with SOA Suite
- Oracle SOA Suite Overview
- 11g SOA / Jdeveloper / Webcenter - Technical Preview
- Step by Step Install of Oracle 11g SOA/JDeveloper/Webcenter
- Install Oracle 11g Jdeveloper/SOA/Webcenter part II
- Oracle SOA Suite 11g Tech. Preview 4
- Install/Configure SOA Repository (Dehydration Store - ORABPEL, ORAESB, ORAWSM) in 11g Database
- How to reset ORABPEL, ORAESB password in SOA Suite 10.1.3.X
- Oracle Fusion Middleware - SOA Suite 11g R1 installation
- Oracle buys Amberpoint : SOA Governance and Management software
- Oracle Launches SOA Governance 11g : Enterprise Repository, Service Registry, SOA management with EM and Web Services Manager
Popularity: 13% [?]
Download R12 VMware
Documentation
Good hands-on exercises (installation, patching, cloning), very experienced trainer worth every penny
8 users commented in " How to reset ORABPEL, ORAESB password in SOA Suite 10.1.3.X "
Follow-up comment rss or Leave a TrackbackThanks
This was great help!!
H atul,
I need a help. we already have soa suite 10.1.3.1.0 and trying to setup one more server.
i already have a database and installed orabpel schemas, can i use the same for the new soa installation? do i need to have a dedicated database for every installation since it is using SYS user?
your input will be great help to me.
@ Ram,
Application uses hard coded orabpel, oraesb, orawsm account so yes If you want dedicated SOA instance then they have to be in separate dedicated database (Though you can use same database binaries and simply create another database using dbca : data base creation assistant).
Atul,
Thank you for the answer.
i will rephrase my question to get the details i need..
I have one SOA installation in one server with oracle Database sitting in a different box.
I want to build one more new SOA server, but i want to use the same database which i already have. do i need to run irca.sh again? does it overwrite the existing schemas?
how does this work? these two soa server use the same set of schema’s as they are in sys user? will it cause any issue to the existing production?
hope this time i am clear.
Thanks again.
Regards,
Ram
@ Ram,
Q. I want to use the same database which i already have. do i need to run irca.sh again? does it overwrite the existing schemas?
A. SOA 10.1.3X expects schema orabpel & orawsm to store BPEL process state. You already have this schema in database. Now if you point another middle tier to same database schema then you will see bpel processes of first soa install and both soa install will share same repository.
If you try to run again irca.sh my guess is that it will fail with error that schema already available.
Q. How does this work? these two soa server use the same set of schema’s as they are in sys user? will it cause any issue to the existing production?
Schemas are not in sys , soa repository is in schema orabpel and sys is just medium to connect to orabpel schema. If you configure second middle tier to existing schema (orabpel) they will become kind of member of cluster.
If you wish to create two separate soa environment then soa 10.1.3.X provide concept of domain (this is different from weblogic domain) so see if SOA domain is sufficient for your requirement
thanks a lot atul
Atul,
while working, i realized one more issue..
The existing SOA Production server is of version 10.1.3.1.0 and SOA reposioty on the database is also the same version.
In new box, i want to patch SOA to 10.1.3.5.0 and as per the installation instructions, i need to run sql scripts to update orabpel,oraesb schema’s.
If that is the case, is my existing server with 10.1.3.1.0 version continue to work new set of updated schema’s as i am planning to use same repository for both servers?
Thanks in advance.
Regards,
Ram
@ Ram,
You will have to upgrade your existing middle tier as well to SOA 10.1.3.5.0 to match with database repository version
Leave A Reply