Title
"No domains accessible to the user logged in" after SOA Suite 10.1.3.4 or 10.1.3.5 upgrade

Date
2009-09-26

Summary
After upgrading Oracle SOA Suite 10g (10.1.3.1) to either 10.1.3.4 or 10.1.3.5, you may get the following error upon logging in to the BPEL Console, even though you followed the pre and post-installation instructions to the letter:
    No domains accessible to the user logged in
You will notice the following error in the opmn log file default_group~oc4j_soa~default_group~1.log:
    <2009-09-26 13:07:56,484> <INFO> <collaxa> <ConnectionFactoryImpl::init> Initialized connection factory jdbc/BPELServerDataSourceWorkflow
    <2009-09-26 13:07:56,484> <INFO> <collaxa> <ConnectionFactoryImpl::init> Initialized connection factory jdbc/BPELServerDataSource
    09/09/26 13:07:56 System.getProperty(dehydration.store)=null
    <2009-09-26 13:07:56,656> <INFO> <collaxa> <ServerManager::__init> Detected datasource 'oracle'
    09/09/26 13:07:56 ORABPEL-03003

    Incorrect db schema version.
    The database schema version "2.0.4" from the database does not match the version "10.1.3.4.0" expected by the server.
    The database schema currently in place has probably been configured for a previous release; please re-install the database schema and try to start the server again.

    09/09/26 13:07:56 at com.collaxa.cube.engine.adaptors.util.BaseSchemaManager.getSchemaVersion(BaseSchemaManager.java:96)
    09/09/26 13:07:56 at com.collaxa.cube.engine.adaptors.util.DataSourceSchemaUtils$1.validateCompatibility(DataSourceSchemaUtils.java:72)
Details
1. Shutdown SOA Suite: 
opmnctl stopall

2. Locate the upgrade script directory from the extracted upgrade software. For example, the 10.1.3.5 patchset for Windows is in filename ias_windows_x86_101350.zip and the example below shows where it might be: 

cd c:\soa_upgrade\Disk1\install\soa_schema_upgrade\bpel\scripts
sqlplus orabpel/orabpel @upgrade_10131_10135_oracle.sql

c:\oracle\soa_upgrade\Disk1\install\soa_schema_upgrade\esb\sql\oracle
sqlplus oraesb/oraesb @upgrade_10131_10135_oracle.sql

A few things worth noting:
  • You must run these upgrade scripts as ORABPEL and ORAESB and not SYSTEM.
  • Locate the appropriate SQL script (e.g., if you are upgrading from 10.1.3.1 to 10.1.3.5, then run upgrade_10131_10135_oracle.sql)

    • 3. Startup SOA Suite: 
    opmnctl startall

    Applicable Versions
    Oracle SOA Suite 10g 10.1.3
    Ahmed Aboulnaga
    .com .com