Changing ORABPEL /ORAESB schema password

Step 1: Change ORABPEL Schema Password: Execute the following steps,

$ sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> ALTER USER orabpel IDENTIFIED BY

E.g. ALTER USER orabpel IDENTIFIED BY welcome1 Step 2: Manually change password in Oracle Internet Directory (OID): Login as (root) orcladmin in Oracle Directory Manager

Navigate to OrclResourceName=ORABPEL,orclReferenceName=SERVICE_NAME,cn=IAS

Infrastructure Databases,cn=IAS,cn=Products,cn=OracleContext in the System Objects Frame In the properties frame, input the new password across the orclpasswordattribute and click ‘Apply’ Step 3: Change OC4J JDBC Datasources in OC4J_SOA

Login to Application Server Console as ‘oc4jadmin’ and navigate to OC4J_SOA. Click on Administration Tab -> JDBC Resources

Click on BPELPM_CONNECTION_POOL link. In the credentials, provide this new password after clicking on ‘Use Cleartext Password’ radio button.

Making connections to Oracle lite Database

If you have done a basic installation of SOA Suite 10.1.3.3 or 10.1.3.4 version, it installs a default Olite database with orabpel, oraesb and orawsm schemas. Here is the solution to connect to these schemas through sql/Jdev Using msql, Mobile SQL Client ($ORACLE_HOME\Mobile\Sdk\BIN\msql.exe): Conencting to orabpel schema: >msql system/manager@jdbc:polite:orabpel Conencting to oraesb schema: >msql system/any@jdbc:polite:oraesb Using Jdev Making connections to Orabpel schema: Connection Type: Olite DB User id/ Password: system/ manager Host name: localhost or your SOA server name Port: 1531 Sid: orabpel Making Conenctiosn to Oraesb schema: Connection Type: Olite DB User id/ Password: system/ any Host name: localhost or your SOA server name Port: 1531 Sid: oraesb For ESB schema connection you to select the driver path located at SOA_HOME/Integration/esb/lib/olite40.jar. This has to be added to your class path