SOA Suite Olite

There are times that you may need to connect to the database that is used by Oracle SOA Suite to perform post-patch processing.  I have included the following as a reminder of how to connect to the associated Olite database.

Mobile SQL Client ($ORACLE_HOME\Mobile\Sdk\BIN\msql.exe) is used to connect to an Olite database. The version distributed with SOA Suite is 10.2.0.2. Here is a typical connection string:

msql system/manager@jdbc:polite:

For the SOA Suite there are three databases: orabpel, oraesb, orawsm. Connecting to the schema that is used by the Oracle BPEL Process Manager is:

  msql system/manager@jdbc:polite:orabpel

Additional:  One thing to keep in mind is that the oraesb password is "any" as opposed to "manager".