Title
"No domains accessible to the user logged in" in an already running SOA Suite 10.1.3 environment

Date
2010-06-29

Summary
When logging in to the BPEL Console, you may get the following error:
    No domains accessible to the user logged in
The log file shows the following error:
    <2010-06-29 09:42:30,404> <::> Connection Cache with this Cache Name is Disabled java.sql.SQLException: Connection Cache with this Cache Name is Disabled at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:240) at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:310) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:286) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:179) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:159) at oracle.oc4j.sql.xa.ICCXAConnection.(ICCXAConnection.java:58) at oracle.oc4j.sql.xa.ICCXADataSource.getXAConnection(ICCXADataSource.java:54) at oracle.oc4j.sql.spi.ManagedConnectionFactoryImpl.createXAConnection(ManagedConnectionFactoryImpl.java:211) at oracle.oc4j.sql.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:170) at com.evermind.server.connector.ApplicationConnectionManager.createManagedConnection(ApplicationConnectionManager.java:1377) at oracle.j2ee.connector.ConnectionPoolImpl.createManagedConnectionFromFactory(ConnectionPoolImpl.java:327) at oracle.j2ee.connector.ConnectionPoolImpl.access$800(ConnectionPoolImpl.java:98) at oracle.j2ee.connector.ConnectionPoolImpl$NonePoolingScheme.getManagedConnection(ConnectionPoolImpl.java:1211) at oracle.j2ee.connector.ConnectionPoolImpl.getManagedConnection(ConnectionPoolImpl.java:785)
Also check out:
Details
1. This is because the ORABPEL database account is locked.

Have the DBA run the following command to unlock the ORABPEL database account: 
ALTER USER orabpel ACCOUNT UNLOCK;

2. Bounce the OC4J_SOA container. 
opmnctl restartproc process-type=oc4j_soa

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