Registry wokrs with Local Oracle DB but not remote DB! URGENT!!

bipikm's picture
I have the registry loading and working ok with a local Oracle 10G database. However we need to move the registry and the database to a shared location and when I try to connect my registry application to the shared database setup for this, it throws an error on startup and does not load the application. Why is this? Can this be fixed asap so we can start using the registry in a shared location. Thanks Setup Details are as follows LOCAL registry.xml ------------------ wso2registry jdbc:oracle:thin:@localhost:1521/WLDEV wso2registry wso2registry oracle.jdbc.driver.OracleDriver LOCAL user-mgt.xml ------------------ jdbc:oracle:thin:@localhost:1521/WLDEV wso2registry wso2registry oracle oracle.jdbc.driver.OracleDriver THE ABOVE WORKS SINCE IT IS CONNECTED TO AN ORACLE DB SETUP ON THE SAME BOX AS THE REGISTRY APPLICATION. REMOTE registry.xml ------------------ wso2registry jdbc:oracle:thin:@server:port/SID wso2registry wso2registry oracle.jdbc.driver.OracleDriver REMOTE user-mgt.xml ------------------ jdbc:oracle:thin:@server:port/SID wso2registry wso2registry oracle oracle.jdbc.driver.OracleDriver THIS DOES NOT WORK. IT IS CONNECTED TO AN ORACLE DB SETUP ON A SEPARATE BOX AS THE REGISTRY APPLICATION. I can connect and login to the remote oracle database without any issues. I also tried to connect my local registry application to the remote oracle db and that also fails with the same error as follows: The local and shared db user(wso2registry) both have the following 2 roles as grants -- 2 Roles for WSO2REGISTRY GRANT RESOURCE TO WSO2REGISTRY; GRANT CONNECT TO WSO2REGISTRY; ALTER USER WSO2REGISTRY DEFAULT ROLE ALL; I thought this was a rights issue since locally I had 'CONNECT' and 'DBA' role granted to the user but the shared db user had 'CONNECT' and 'RESOURCE' roles(we cannot grant 'DBA' rights to a user in a shared db environment) so I changed the local db user to have 'RESOURCE' role instead of 'DBA' and that still works. So it does not seem like the role access has anything to do with this. THE ERROR ON START IS AS FOLLOWS: Jun 22, 2009 11:25:26 AM org.wso2.carbon.server.Main main INFO: Starting WSO2 Carbon... Jun 22, 2009 11:25:26 AM org.wso2.carbon.server.Main main INFO: Using Java Home : C:\jdk1.5.0_16\jre Jun 22, 2009 11:25:26 AM org.wso2.carbon.server.Main main INFO: Using Java Version : 1.5.0_16 Jun 22, 2009 11:25:26 AM org.wso2.carbon.server.Main main INFO: Using Carbon Home : C:\Carbon\Registry\tomcat\WSO2RE~1.1\bin\.. Jun 22, 2009 11:25:26 AM org.apache.catalina.startup.Embedded start INFO: Starting tomcat server Jun 22, 2009 11:25:27 AM org.apache.catalina.core.StandardEngine start INFO: Starting Servlet Engine: Apache Tomcat/5.5.23 Jun 22, 2009 11:25:27 AM org.apache.catalina.core.StandardHost start INFO: XML validation disabled Jun 22, 2009 11:25:27 AM org.apache.coyote.http11.Http11BaseProtocol init INFO: Initializing Coyote HTTP/1.1 on http-9763 Jun 22, 2009 11:25:27 AM org.apache.coyote.http11.Http11BaseProtocol start INFO: Starting Coyote HTTP/1.1 on http-9763 Jun 22, 2009 11:25:27 AM org.apache.coyote.http11.Http11BaseProtocol init INFO: Initializing Coyote HTTP/1.1 on http-9443 Jun 22, 2009 11:25:27 AM org.apache.coyote.http11.Http11BaseProtocol start INFO: Starting Coyote HTTP/1.1 on http-9443 [2009-06-22 11:25:34,436] ERROR - WSO2 Registry is not available {org.wso2.carbon.core.ServerConfigurator} [2009-06-22 11:25:34,436] FATAL - Cannot start WSO2 Registry {org.wso2.carbon.core.ServerManager} org.apache.axis2.deployment.DeploymentException: WSO2 Registry is not available at org.wso2.carbon.core.ServerConfigurator.populateAxisConfiguration(ServerConfigurator.java:240) at org.wso2.carbon.core.ServerConfigurator.getAxisConfiguration(ServerConfigurator.java:170) at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.j ava:65) at org.wso2.carbon.core.CarbonConfigurationContextFactory.createNewConfigurationContext(CarbonConfigurationConte xtFactory.java:79) at org.wso2.carbon.core.ServerManager.start(ServerManager.java:130) at org.wso2.carbon.core.StartupServlet.start(StartupServlet.java:254) at org.wso2.carbon.core.StartupServlet.init(StartupServlet.java:190) at org.eclipse.equinox.http.servlet.internal.ServletRegistration.init(ServletRegistration.java:64) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.registerServlet(ProxyServlet.java:142) at org.eclipse.equinox.http.servlet.internal.HttpServiceImpl.registerServlet(HttpServiceImpl.java:50) at org.wso2.carbon.core.internal.Activator.start(Activator.java:58) at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974) at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346) at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350) at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118) at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634) at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508) at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282) at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195) at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297) org.wso2.carbon.utils.ServerException: WSO2 Registry startup failed. at org.wso2.carbon.core.StartupServlet.start(StartupServlet.java:286) at org.wso2.carbon.core.StartupServlet.init(StartupServlet.java:190) at org.eclipse.equinox.http.servlet.internal.ServletRegistration.init(ServletRegistration.java:64) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.registerServlet(ProxyServlet.java:142) at org.eclipse.equinox.http.servlet.internal.HttpServiceImpl.registerServlet(HttpServiceImpl.java:50) at org.wso2.carbon.core.internal.Activator.start(Activator.java:58) at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974) at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346) at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350) at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118) at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634) at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508) at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282) at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195) at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297) Caused by: org.wso2.carbon.utils.ServerException: Cannot start WSO2 Registry at org.wso2.carbon.core.ServerManager.start(ServerManager.java:159) at org.wso2.carbon.core.StartupServlet.start(StartupServlet.java:254) ... 18 more Caused by: org.apache.axis2.deployment.DeploymentException: WSO2 Registry is not available at org.wso2.carbon.core.ServerConfigurator.populateAxisConfiguration(ServerConfigurator.java:240) at org.wso2.carbon.core.ServerConfigurator.getAxisConfiguration(ServerConfigurator.java:170) at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.j ava:65) at org.wso2.carbon.core.CarbonConfigurationContextFactory.createNewConfigurationContext(CarbonConfigurationConte xtFactory.java:79) at org.wso2.carbon.core.ServerManager.start(ServerManager.java:130) ... 19 more [2009-06-22 11:25:34,499] FATAL - Could not start WSO2 Registry {org.wso2.carbon.core.StartupServlet} org.wso2.carbon.utils.ServerException: WSO2 Registry startup failed. at org.wso2.carbon.core.StartupServlet.start(StartupServlet.java:286) at org.wso2.carbon.core.StartupServlet.init(StartupServlet.java:190) at org.eclipse.equinox.http.servlet.internal.ServletRegistration.init(ServletRegistration.java:64) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.registerServlet(ProxyServlet.java:142) at org.eclipse.equinox.http.servlet.internal.HttpServiceImpl.registerServlet(HttpServiceImpl.java:50) at org.wso2.carbon.core.internal.Activator.start(Activator.java:58) at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974) at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346) at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350) at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118) at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634) at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508) at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282) at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195) at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297) Caused by: org.wso2.carbon.utils.ServerException: Cannot start WSO2 Registry at org.wso2.carbon.core.ServerManager.start(ServerManager.java:159) at org.wso2.carbon.core.StartupServlet.start(StartupServlet.java:254) ... 18 more Caused by: org.apache.axis2.deployment.DeploymentException: WSO2 Registry is not available at org.wso2.carbon.core.ServerConfigurator.populateAxisConfiguration(ServerConfigurator.java:240) at org.wso2.carbon.core.ServerConfigurator.getAxisConfiguration(ServerConfigurator.java:170) at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.j ava:65) at org.wso2.carbon.core.CarbonConfigurationContextFactory.createNewConfigurationContext(CarbonConfigurationConte xtFactory.java:79) at org.wso2.carbon.core.ServerManager.start(ServerManager.java:130) ... 19 more [2009-06-22 11:25:34,546] ERROR - Error initializing org.wso2.core.services component {org.wso2.carbon.core.services.in ternal.Activator} java.lang.NullPointerException at org.wso2.carbon.core.services.authentication.AuthenticationAdminTrackers.init(AuthenticationAdminTrackers.jav a:26) at org.wso2.carbon.core.services.internal.Activator.start(Activator.java:20) at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974) at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346) at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350) at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118) at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634) at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508) at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282) at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195) at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297) [2009-06-22 11:25:34,577] ERROR - Failed to start Carbon UI {org.wso2.carbon.ui.internal.Activator} java.lang.Exception: ConfigurationContext Service is not available at org.wso2.carbon.ui.internal.Activator.start(Activator.java:108) at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974) at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346) at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350) at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118) at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634) at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508) at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282) at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195) at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297)
library project main code
Learn Cloud
Learn
Cloud

The WSO2 Application Server is a reliable application server that can host your enterprise web applications. The WSO2 Application Server as a Service is offered in StratosLive, the WSO2 Platform as a Service. This article explains how a simple web application can be developed and deployed from Carbon Studio to the WSO2 Application Server...

Latest Webinar
Different groups within an organization need to monitor different Key Performance Indicators (KPIs) - An operations team will be interested in the response times of business services and loads of each service,..
Thursday, February 9th 2012, 09.00 AM (PST)

Thursday, February 9th 2012, 10.00 AM (GMT)