4 Replies Latest reply on Oct 11, 2011 2:34 PM by Orv-Oracle

    APEX Install working w/WebLogic and the APEX Listener

    575128
      Right now I get the following message when supplying "http://localhost:7001/apex/listenerConfigure" as a URL in Internet Explorer

      The APEX Listener is already configured. Please login as Administrator to access APEX Listener Administration.

      How can I unconfigure the "Apex Listener" so that when I try to get to the above URL it gets me to the settings page?

      I've also tried this URL:

      http://localhost:7001/apex/apex_admin

      it results in the following exception. After seeing the below exception I immediately altered the APEX_PUBLIC_USER password in Oracle
      to a new password. So now that I have a new password for the APEX_PUBLIC_USER in Oracle, where do I need to update config files?

      *oracle.dbtools.rt.service.ServiceLocatorException: Exception occurred in activate() method
           at oracle.dbtools.rt.service.Provider.activate(Provider.java:56)
           at oracle.dbtools.rt.service.Provider.match(Provider.java:111)
           at oracle.dbtools.rt.service.Providers.match(Providers.java:22)
           at oracle.dbtools.rt.service.ServiceLocator.acquireAll(ServiceLocator.java:97)
           at oracle.dbtools.rt.service.ServiceLocator.acquire(ServiceLocator.java:74)
           at oracle.dbtools.rt.service.Provider.inject(Provider.java:137)
           at oracle.dbtools.rt.service.Provider.activate(Provider.java:39)
           at oracle.dbtools.rt.service.Provider.match(Provider.java:111)
           at oracle.dbtools.rt.service.Providers.match(Providers.java:22)
           at oracle.dbtools.rt.service.ServiceLocator.acquireAll(ServiceLocator.java:97)
           at oracle.dbtools.rt.service.ServiceLocator.acquire(ServiceLocator.java:74)
           at oracle.dbtools.rt.service.Provider.inject(Provider.java:137)
           at oracle.dbtools.rt.service.Provider.activate(Provider.java:39)
           at oracle.dbtools.rt.service.Provider.match(Provider.java:111)
           at oracle.dbtools.rt.service.Providers.match(Providers.java:22)
           at oracle.dbtools.rt.service.ServiceLocator.acquireAll(ServiceLocator.java:97)
           at oracle.dbtools.rt.service.ServiceLocator.acquire(ServiceLocator.java:74)
           at oracle.dbtools.rt.service.Provider.inject(Provider.java:137)
           at oracle.dbtools.rt.service.Provider.activate(Provider.java:39)
           at oracle.dbtools.rt.service.Provider.match(Provider.java:111)
           at oracle.dbtools.rt.service.Providers.match(Providers.java:22)
           at oracle.dbtools.rt.service.ServiceLocator.acquireAll(ServiceLocator.java:97)
           at oracle.dbtools.rt.service.ServiceLocator.acquireAll(ServiceLocator.java:104)
           at oracle.dbtools.rt.web.RequestDispatchers.choose(RequestDispatchers.java:85)
           at oracle.dbtools.rt.web.RequestDispatchers.dispatch(RequestDispatchers.java:52)
           at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:85)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
           at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
           at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.doIt(WebAppServletContext.java:3686)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3650)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
           at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2268)
           at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)
           at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
      Caused by: oracle.dbtools.rt.web.WebException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource
           at oracle.dbtools.rt.web.WebException.internalError(WebException.java:124)
           at oracle.dbtools.rt.query.jdbc.BaseJDBCCallProvider.activated(BaseJDBCCallProvider.java:56)
           at oracle.dbtools.rt.query.jdbc.ora.OraJDBCCallProvider.activate(OraJDBCCallProvider.java:25)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at oracle.dbtools.rt.service.__Reflections.invoke(__Reflections.java:85)
           at oracle.dbtools.rt.service.Provider.activate(Provider.java:43)
           ... 39 more
      Caused by: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource
           at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:541)
           at oracle.ucp.jdbc.PoolDataSourceImpl.throwSQLException(PoolDataSourceImpl.java:588)
           at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:277)
           at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:647)
           at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:614)
           at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:608)
           at oracle.dbtools.apex.Connections.getConnection(Connections.java:116)
           at oracle.dbtools.rt.query.jdbc.ora.OraJDBCCallProvider.connection(OraJDBCCallProvider.java:31)
           at oracle.dbtools.rt.query.jdbc.BaseJDBCCallProvider.activated(BaseJDBCCallProvider.java:44)
           ... 46 more
      Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource
           at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:421)
           at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:389)
           at oracle.ucp.jdbc.DataSourceConnectionFactoryAdapter.createConnection(DataSourceConnectionFactoryAdapter.java:106)
           at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.createOnePooledConnectionInternal(UniversalConnectionPoolImpl.java:1613)
           at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.access$600(UniversalConnectionPoolImpl.java:1421)
           at oracle.ucp.common.UniversalConnectionPoolImpl.createOnePooledConnection(UniversalConnectionPoolImpl.java:488)
           at oracle.ucp.common.UniversalConnectionPoolImpl.addNewConnections(UniversalConnectionPoolImpl.java:988)
           at oracle.ucp.common.UniversalConnectionPoolBase.getInitialConnections(UniversalConnectionPoolBase.java:541)
           at oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBase.java:655)
           at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:271)
           ... 52 more
      Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
           at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:573)
           at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:431)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
           at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366)
           at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752)
           at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:366)
           at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:536)
           at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:228)
           at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
           at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
           at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:280)
           at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:207)
           at oracle.ucp.jdbc.DataSourceConnectionFactoryAdapter.createConnection(DataSourceConnectionFactoryAdapter.java:100)
           ... 59 more*

      Wes

      Edited by: Wes Gibbs on Aug 9, 2011 6:11 PM