Oracle ESB Console Error: Unknow Error in ESB. Please see the DT server log for details

* Solaris OS
* Oracle 10g DB
* SOA 10.1.3.5

* After logging into ESB console, you get error message:

Unknow Error in ESB. Please see the DT server log for details

* If you click the ‘Instances’ icon, you get error message:

An unhandled exception has been thrown in the ESB system. The exception reported is: 
"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) at 
oracle.tip.esb.model.repository.database.DatabaseRepository.getESBParameter(DatabaseRepository.java:1108) at ...
oracle.oc4j.sql.ManagedDataSource.getConnection(ManagedDataSource.java:127) at 
oracle.tip.esb.model.repository.database.DatabaseRepository.getConnection(DatabaseRepository.java:1269) ... 
25 more ".

* ESB Design Time application (esb-dt) failed to connect to database as use ‘oraesb’.

* Check Repository DB is Up and Running: ‘tnsping infra’ returns OK.
* Check user ‘oraesb’ can log in repository db.

SQL> conn oraesb/oraesbpass
ERROR:
ORA-28000: the account IS locked

* Unlock user ‘oraesb’ account if locked.

SQL> ALTER USER oraesb account UNLOCK;
 
USER altered.

* Check ‘oraesb’ user password in ‘ocj4j_soa’ container:
– vi j2ee/oc4j_soa/config/system-jazn-data.xml

<user>
  <name>pwdforOraesb</name>
  <guid>SOMEGUIDSTRING</guid>
  <credentials>!oraesbpass</credentials>
</user>

* Check ‘oraesb’ password in oc4j container where esb-dt was deployed if esb-dt is deployed on a different oc4j container (e.g. oc4j_esbdt):
– vi j2ee/oc4j_esbdt/config/system-jazn-data.xml

<user>
  <name>pwdforOraesb</name>
  <guid>SOMEGUIDSTRING</guid>
  <credentials>!oraesbpass</credentials>
</user>

* Check ‘oraesb’ user password in data-sources.xml files just in case.
* Restart all processes where esb-dt is deployed:
./opmnctl stopall
./opmnctl startall
* Verify user ‘oraesb’ can log in repository db.

SQL> conn oraesb/oraesbpass
Connected.

* Login ESB Console and verify the solution.