Title
ESB Control shows "Designtime cache has not been initialized"

Date
2008-06-02

Summary
After installing Oracle SOA Suite 10g (10.1.3.3) and logging on to the ESB Control, the following error appears:
    Designtime cache has not been initialized Please look in logs for following signs of failure.
Fix them and restart. (a) Database access errors (b) ESB Bootstrap errors
(c) OC4J class load errors (d) Product installation errors
(e) Export ESB params and verify if host and port parameters are correct.
Please contact Oracle Support if unable to fix the issue.
Similarly, the OC4J log shows the following: 
    08/06/01 23:56:57 oracle.tip.esb.infra.exception.ESBRuntimeException: Designtime cache has not been initialized
Please look in logs for following signs of failure.
Fix them and restart. (a) Database access errors (b) ESB Bootstrap errors
(c) OC4J class load errors (d) Product installation errors
(e) Export ESB params and verify if host and port parameters are correct.
Please contact Oracle Support if unable to fix the issue.
08/06/01 23:56:57       at oracle.tip.esb.console.CacheManager.getInitializedInstance(CacheManager.java:319)
08/06/01 23:56:57       at oracle.tip.esb.console.XMLConsoleManagerImpl.(XMLConsoleManagerImpl.java:218)
08/06/01 23:56:57       at oracle.tip.esb.console.ConsoleManagerFactory.getConsoleManager(ConsoleManagerFactory.java:57)
08/06/01 23:56:57       at oracle.tip.esb.configuration.servlet.command.ServiceExplorerCommand.execute(ServiceExplorerCommand.java:45)
08/06/01 23:56:57       at oracle.tip.esb.configuration.servlet.CommandServlet.doJob(CommandServlet.java:109)
08/06/01 23:56:57       at oracle.tip.esb.configuration.servlet.CommandServlet.doPost(CommandServlet.java:76)
08/06/01 23:56:57       at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
08/06/01 23:56:57       at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
08/06/01 23:56:57       at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
08/06/01 23:56:57       at oracle.security.jazn.oc4j.JAZNFilter$1.run(JAZNFilter.java:396)
08/06/01 23:56:57       at java.security.AccessController.doPrivileged(Native Method)
08/06/01 23:56:57       at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
08/06/01 23:56:57       at oracle.security.jazn.oc4j.JAZNFilter.doFilter(JAZNFilter.java:410)
08/06/01 23:56:57       at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:623)
08/06/01 23:56:57       at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
08/06/01 23:56:57       at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
08/06/01 23:56:57       at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
08/06/01 23:56:57       at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:302)
08/06/01 23:56:57       at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:190)
08/06/01 23:56:57       at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
08/06/01 23:56:57       at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
08/06/01 23:56:57       at java.lang.Thread.run(Thread.java:595)
If you are running ESB in a cluster, before attempting the solution below, try shutting down both the ESB Design Time and ESB Runtime. Then start up all your ESB Design Times before starting up ESB Runtime, and try logging in again.

Details
1. If the hostname or IP address of the server has changed (e.g., if this is a DHCP host), this is the root cause of this error.
If that is the case, perform the following steps to resolve the issue, otherwise proceed to Step 2 to reset your metadata.

a. Edit the ServerName and Port directives in $ORACLE_HOME/Apache/Apache/conf/httpd.conf and ensure that it is set to a valid hostname.

b. Log in to the database as the ORAESB user, and issue the following SQL statement: 
UPDATE oraesb.esb_parameter
SET    dt_oc4j_host      = '<valid_hostname>',
       dt_oc4j_http_port = '<valid_port>';

2. Steps 2-4 describe how to reset your metadata. If the solution above resolves your issue, do not proceed.

Shutdown the SOA Suite: 
export ORACLE_HOME=/u01/app/oracle/product/10.1.3/soa_1
$ORACLE_HOME/opmn/bin/opmnctl stopall

3. Run the reset.sh script. However, it will reset all your metadata (i.e., delete all existing metadata). The command below backs up the existing metadata to a file called metadata.zip.
cd $ORACLE_HOME/integration/esb/bin
reset.sh -Dexport true -Dmetadatafile /u01/app/oracle/product/10.1.3/soa_1/metadata.zip -DDB_URL=jdbc:oracle:thin:@<db_hostname>:1521:<oracle_sid> -DDB_USER oraesb -DDB_PASSWORD <oraesb_password> -DDB_DRIVER oracle.jdbc.driver.OracleDriver

The output will be similar to: 
oracle@oradev:/u01/app/oracle/product/10.1.3/soa_1/integration/esb/bin> /u01/app/oracle/product/10.1.3/soa_1/integration/esb/bin/reset.sh -Dexport true -Dmetadatafile /u01/app/oracle/product/10.1.3/soa_1/metadata.zip -DDB_URL=jdbc:oracle:thin:@oradev:1521:soadb -DDB_USER oraesb -DDB_PASSWORD oraesb -DDB_DRIVER oracle.jdbc.driver.OracleDriver
Buildfile: build.xml
     [echo] ${env.PCHOME}

reset-esb:
     [java] Creating database connection with DB_URL=jdbc:oracle:thin:@oradev:1521:orcl, DB_USER=oraesb DB_PASSWORD=oraesb DB_DRIVER=oracle.jdbc.driver.OracleDriver.
     [java] Running this Command will reset all the metadata. Existing metadata will be backed up. Press y to continue and any other key to exit.
y
     [java] Jun 2, 2008 1:28:48 PM oracle.tip.esb.lifecycle.HttpHandler logInfo
     [java] INFO: Exporting metadata from the server [host=oradev.local.com,port=7777,user=oc4jadmin] to file "/u01/app/oracle/product/10.1.3/soa_1/metadata.zip"
     [java] Exported metadata to File /u01/app/oracle/product/10.1.3/soa_1/metadata.zip.
     [java] Exported parameters to File /u01/app/oracle/product/10.1.3/soa_1/integration/esb/bkup/20080602_1328/esbparam.properties.
     [java] Running:/u01/app/oracle/product/10.1.3/soa_1/integration/esb/sql/other/drop_esb_tables.sql
     [java] Running:/u01/app/oracle/product/10.1.3/soa_1/integration/esb/sql/other/wfeventc.sql
     [java] Running:/u01/app/oracle/product/10.1.3/soa_1/integration/esb/sql/other/seed_service_types.sql
     [java] Running:/u01/app/oracle/product/10.1.3/soa_1/integration/esb/sql/other/seed_default_system.sql
     [java] -- listing properties --
     [java] PROP_NAME_MONITOR_TOPIC_JNDI=OracleASjms/ESBMonitorTopic
     [java] PROP_NAME_ERROR_XATCF_JNDI=OracleASjms/MyXATCF
     [java] PROP_NAME_ERROR_RETRY_JNDI=OracleASjms/ESBErrorRetryTopic
     [java] DT_OC4J_HTTP_PORT=7777
     [java] PROP_NAME_CONTROL_TCF_JNDI=OracleASjms/MyXATCF
     [java] PROP_NAME_ERROR_TOPIC_JNDI=OracleASjms/ESBErrorTopic
     [java] PROP_NAME_MONITOR_TCF_JNDI=OracleASjms/MyTCF
     [java] PROP_NAME_ERROR_TCF_JNDI=OracleASjms/MyTCF
     [java] PROP_NAME_CONTROL_TOPIC_JNDI=OracleASjms/ESBControlTopic
     [java] PROP_NAME_DEFERRED_TCF_JNDI=OracleASjms/MyTCF
     [java] DT_OC4J_HOST=oradev.local.com
     [java] PROP_NAME_DEFERRED_XATCF_JNDI=OracleASjms/MyXATCF
     [java] PROP_NAME_ERROR_RETRY_TCF_JNDI=OracleASjms/MyXATCF
     [java] Imported parameters from file /u01/app/oracle/product/10.1.3/soa_1/integration/esb/bkup/20080602_1328/esbparam.properties.
     [java] Please restart server before continuing.
     [echo] ${env.PCHOME}

reset-filerepo:
     [echo] Removing slide repository
   [delete] Deleting directory /u01/app/oracle/product/10.1.3/soa_1/integration/esb/oraesb/artifacts

BUILD SUCCESSFUL
Total time: 21 seconds

4. Startup the SOA Suite: 
$ORACLE_HOME/opmn/bin/opmnctl startall

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