Oracle SOA 10g BPEL Error: No domains accessible to the user logged in.

When logging into BPEL console, got an error message

No domains accessible to the user logged in.

* XP machine.
* Oracle 10g DB
* SOA 10.1.3.5

* Check BPEL domain log:
C:\product\10.1.3.1\OracleAS_2\bpel\domains\default\logs\domain.log

* Check BPEL system log:
C:\product\10.1.3.1\OracleAS_2\bpel\system\logs\orabpel.log
C:\product\10.1.3.1\OracleAS_2\bpel\system\logs\log.xml

* Check opmn log for oc4j_soa:
C:\product\10.1.3.1\OracleAS_2\opmn\logs\default_group~oc4j_soa~default_group~1.log
and found:

10/10/15 13:44:59 java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
10/10/15 13:44:59 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
...
Cannot lookup datasource type.
The process domain was unable to determine the database type.  The version table contains the vendor type for the current datasource.  The exception reported is: Cannot fetch a datasource connection.
The process domain was unable to establish a connection with the datasource with the connection URL "jdbc/BPELServerDataSourceWorkflow".  The exception reported is: Io exception: The Network Adapter could not establish the connection
Please check that the machine hosting the datasource is physically connected to the network.  Otherwise, check that the datasource connection parameters (user/password) is currently valid.

Please check that:
     + the machine hosting the datasource is physically connected to the network.
     + the connection pool properties as defined in the application server startup properties are valid.
     + the database schema for OraBPEL has been installed in the datasource.

* Check oc4j_soa log.xml:
C:\product\10.1.3.1\OracleAS_2\j2ee\oc4j_soa\log\oc4j_soa_default_group_1\oc4j\log.xml
and found:

    <TSTZ_ORIGINATING>2010-10-15T13:44:22.281-04:00</TSTZ_ORIGINATING>
    <COMPONENT_ID>tip</COMPONENT_ID>
    <MSG_TYPE TYPE="ERROR"></MSG_TYPE>
    <MSG_LEVEL>1</MSG_LEVEL>
    <MODULE_ID>esb.server.bootstrap</MODULE_ID>
    <THREAD_ID>11</THREAD_ID>
    <USER_ID>SYSTEM</USER_ID>
  </HEADER>
  <CORRELATION_DATA>
    <EXEC_CONTEXT_ID><UNIQUE_ID>1277827932:82234:1287164655750:1</UNIQUE_ID><SEQ>0</SEQ></EXEC_CONTEXT_ID>
  </CORRELATION_DATA>
  <PAYLOAD>
    <MSG_TEXT>ESB bootstrap: Failed to start ESB server as the repository is not reachable</MSG_TEXT>
    <SUPPL_DETAIL><![CDATA[oracle.tip.esb.model.repository.exception.RepositoryException: Unable to get connection to Repository
Ensure repository is accessible
	at oracle.tip.esb.model.repository.database.DatabaseRepository.getConnection(DatabaseRepository.java:1275)
Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
    </SUPPL_DETAIL>
  </PAYLOAD>

* Check oc4j_soa coreman.log:
C:\product\10.1.3.1\OracleAS_2\j2ee\oc4j_soa\log\coreman.log
and Found:

target exception:

java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
//localhost:1521/orcl
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)

* Check database is up and running.
* Check logging into orabpel user.
* Restart SOA.

* Solaris OS
* Oracle 10g DB
* SOA 10.1.3.5

* vi j2ee/oc4j_soa/log/oc4j_soa_default_group_1/oc4j/log.xml

<MESSAGE>
  <HEADER>
    <TSTZ_ORIGINATING>2010-10-15T19:34:44.447+00:00</TSTZ_ORIGINATING>
    <COMPONENT_ID>tip</COMPONENT_ID>
    <MSG_TYPE TYPE="ERROR"></MSG_TYPE>
    <MSG_LEVEL>1</MSG_LEVEL>
    <HOST_ID>myhost</HOST_ID>
    <HOST_NWADDR>192.168.1.10</HOST_NWADDR>
    <MODULE_ID>esb.server.service.impl.soap</MODULE_ID>
    <THREAD_ID>10</THREAD_ID>
    <USER_ID>oracle</USER_ID>
  </HEADER>
  <CORRELATION_DATA>
    <EXEC_CONTEXT_ID><UNIQUE_ID>1483312815:87239:1287171244788:0</UNIQUE_ID><SEQ>34</SEQ></EXEC_CONTEXT_ID>
  </CORRELATION_DATA>
  <PAYLOAD>
    <MSG_TEXT>Registering ESB services to Oracle SOAP Provider failed</MSG_TEXT>
    <SUPPL_DETAIL><![CDATA[oracle.tip.esb.model.repository.exception.RepositoryException: Unable to get connection to Repository
Ensure repository is accessible
        at oracle.tip.esb.model.repository.database.DatabaseRepository.getConnection(DatabaseRepository.java:1275)

* Update orabpel password by editing system-jazn-data.xml file.
vi j2ee/oc4j_soa/config/system-jazn-data.xml

<user>
  <name>pwForOrabpel</name>
  <guid>120C6951EB9511DCBFF1AD21958DF927</guid>
  <credentials>!myBpelPassword</credentials>
</user>

Notice the ‘!’ before the new password so that the password will get encrypted when oc4j is restarted.
* Check same password is used in j2ee/oc4j_soa/config/data-sources.xml

<connection-pool name="BPELPM_CONNECTION_POOL">
  <connection-factory 
    factory-class="oracle.jdbc.pool.OracleDataSource" 
    user="orabpel" password="myBpelPassword" 
    url="jdbc:oracle:thin:@localhost:1521/soa" 
    commit-record-table-name=""/>
</connection-pool>

* Restart
opmnctl stopall
opmnctl startall

* http://sathyam-soa.blogspot.com/2009/01/oracle-bpel-console-throws-no-domains.html
* http://onlineappsdba.com/index.php/2009/04/14/how-to-reset-orabpel-oraesb-password-in-soa-suite-1013x/