1 Reply Latest reply on Sep 20, 2012 12:11 PM by 685473

    APEX listener 2.0 EA as Standalone raises ORA-00942: table or view does not

    685473
      Which database table can't be found when running the APEX listener 2.0 EA standalone?

      I have installed the listener as standalone conform the installation guide without the two RESTFUL users.
      After starting the listener standalone and starting APEX in the browser using the given URL, it raises an Internal Error in the browser.
      In the commandbox of the listener it shows ORA-00942: table or view does not exist (See below)

      Why has the db.username value changed from APEX_PUBLIC_USER into APEX_LISTENER after I have run the URL in the browser?

      [oracle@ohi-image ~]$ java -jar apex.war standalone
      Sep 20, 2012 10:58:38 AM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
      INFO: Using configuration folder: /home/oracle/apex/apex
      Sep 20, 2012 10:58:38 AM oracle.dbtools.standalone.Standalone execute
      INFO: NOTE:

      Standalone mode is designed for use in development and test environments. It is not supported for use in production environments.

      Sep 20, 2012 10:58:38 AM oracle.dbtools.standalone.Standalone execute
      INFO: Starting standalone Web Container in: /home/oracle/apex/apex
      Sep 20, 2012 10:58:38 AM oracle.dbtools.standalone.Deployer deploy
      INFO: Will deploy application path = /home/oracle/apex/apex/apex/WEB-INF/web.xml
      Sep 20, 2012 10:58:39 AM oracle.dbtools.standalone.Deployer deploy
      INFO: Deployed application path = /home/oracle/apex/apex/apex/WEB-INF/web.xml
      Sep 20, 2012 10:58:39 AM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
      INFO: Using configuration folder: /home/oracle/apex/apex
      cache.caching=false
      cache.directory=/tmp/apex/cache
      cache.duration=days
      cache.expiration=7
      cache.maxEntries=500
      cache.monitorInterval=60
      cache.procedureNameList=
      cache.type=lru
      db.hostname=localhost
      db.password=******
      db.port=1521
      db.sid=vozg
      debug.debugger=true
      debug.printDebugToScreen=true
      error.keepErrorMessages=true
      error.maxEntries=50
      jdbc.DriverType=thin
      jdbc.InactivityTimeout=1800
      jdbc.InitialLimit=3
      jdbc.MaxConnectionReuseCount=1000
      jdbc.MaxLimit=10
      jdbc.MaxStatementsLimit=10
      jdbc.MinLimit=1
      jdbc.statementTimeout=900
      log.logging=true
      log.maxEntries=50
      misc.compress=
      misc.defaultPage=apex
      security.disableDefaultExclusionList=false
      security.maxEntries=2000
      security.verifySSL=false
      db.username=APEX_PUBLIC_USER
      Using JDBC driver: Oracle JDBC driver version: 11.2.0.1.0
      Sep 20, 2012 10:58:43 AM oracle.dbtools.rt.web.SCListener contextInitialized
      INFO: Oracle Application Express Listener initialized
      Application Express Listener version : 2.0.0.215.16.37
      Application Express Listener server info: Grizzly/1.9.49

      Sep 20, 2012 10:58:43 AM com.sun.grizzly.Controller logVersion
      INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 9/20/12 10:58 AM
      Sep 20, 2012 10:58:43 AM oracle.dbtools.standalone.Standalone execute
      INFO: http://localhost:8083/apex started.
      cache.caching=false
      cache.directory=/tmp/apex/cache
      cache.duration=days
      cache.expiration=7
      cache.maxEntries=500
      cache.monitorInterval=60
      cache.procedureNameList=
      cache.type=lru
      db.hostname=localhost
      db.password=******
      db.port=1521
      db.sid=vozg
      debug.debugger=true
      debug.printDebugToScreen=true
      error.keepErrorMessages=true
      error.maxEntries=50
      jdbc.DriverType=thin
      jdbc.InactivityTimeout=1800
      jdbc.InitialLimit=3
      jdbc.MaxConnectionReuseCount=1000
      jdbc.MaxLimit=10
      jdbc.MaxStatementsLimit=10
      jdbc.MinLimit=1
      jdbc.statementTimeout=900
      log.logging=true
      log.maxEntries=50
      misc.compress=
      misc.defaultPage=apex
      security.disableDefaultExclusionList=false
      security.maxEntries=2000
      security.verifySSL=false
      db.username=APEX_LISTENER
      Sep 20, 2012 10:58:58 AM com.sun.grizzly.http.servlet.ServletAdapter doService
      SEVERE: service exception:
      oracle.dbtools.common.UnrecoverableException: ORA-00942: table or view does not exist

      at oracle.dbtools.common.UnrecoverableException.unrecoverable(UnrecoverableException.java:29)
      at oracle.dbtools.common.config.db.DatabasePoolConfig.loadFromDBFromTime(DatabasePoolConfig.java:179)
      at oracle.dbtools.common.config.db.DatabasePoolConfig.loadFromDB(DatabasePoolConfig.java:152)
      at oracle.dbtools.common.config.db.DatabasePoolConfig.getInstance(DatabasePoolConfig.java:291)
      at oracle.dbtools.rt.jdbc.DatabaseConnectionFilter.poolInfo(DatabaseConnectionFilter.java:60)
      at oracle.dbtools.rt.jdbc.DatabaseConnectionFilter.applyDatabaseConnectionInfo(DatabaseConnectionFilter.java:71)
      at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:132)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.doFilter(ServletAdapter.java:1059)
      at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.invokeFilterChain(ServletAdapter.java:999)
      at com.sun.grizzly.http.servlet.ServletAdapter.doService(ServletAdapter.java:434)
      at oracle.dbtools.standalone.SecureServletAdapter.doService(SecureServletAdapter.java:65)
      at com.sun.grizzly.http.servlet.ServletAdapter.service(ServletAdapter.java:379)
      at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)
      at com.sun.grizzly.tcp.http11.GrizzlyAdapterChain.service(GrizzlyAdapterChain.java:196)
      at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)
      at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:849)
      at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:746)
      at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1045)
      at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:228)
      at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
      at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
      at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
      at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
      at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
      at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
      at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
      at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
      at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
      at java.lang.Thread.run(Thread.java:662)
      Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
      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.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:111)
      at $Proxy43.executeQuery(Unknown Source)
      at oracle.dbtools.common.config.db.DatabasePoolConfig.readPoolConfig(DatabasePoolConfig.java:247)
      at oracle.dbtools.common.config.db.DatabasePoolConfig.loadFromDBFromTime(DatabasePoolConfig.java:175)
      ... 28 more
        • 1. Re: APEX listener 2.0 EA as Standalone raises ORA-00942: table or view does not
          685473
          Luckily I found the error myself.

          It was due to the fact that I had created a APEX_REST_PUBLIC_USER and a APEX_LISTENER user by hand in the database in a previous step after a message in SQL developer trying to upload listener settings.
          After dropping the two users by hand the error didn't appear any more and APEX was started correctly in the browser.

          If you need those two users, don't create them by hand, but use the patch script in the folder apex_patch of downloaded zip file.
          It is mentioned in the installation guide, but I had missed it.

          Mathieu