Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

WARNING: The pool_config view or table was not found in schema: APEX_LISTENER

Brad537152Aug 14 2014 — edited Aug 15 2014

Hi we are getting this error in an ORDS Standalone on Grizzly set up.

Aug 14, 2014 9:59:05 AM

oracle.dbtools.common.config.db.DatabasePoolConfig readPoolConfig

WARNING: The pool_config view or table was not found in schema:

APEX_LISTENER

Aug 14, 2014 9:59:05 AM oracle.dbtools.rt.web.WebErrorResponse

internalError

SEVERE: JDBCException [kind=NO_DATA]

JDBCException [kind=NO_DATA]

defaults.xml  "XXXXX" denote removed for security, before post

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">

<properties>

<comment>Saved on Mon Aug 04 16:25:09 EDT 2014</comment>

<entry key="cache.caching">false</entry>

<entry key="cache.directory">/tmp/apex/cache</entry>

<entry key="cache.duration">days</entry>

<entry key="cache.expiration">7</entry>

<entry key="cache.maxEntries">500</entry>

<entry key="cache.monitorInterval">60</entry>

<entry key="cache.procedureNameList"/>

<entry key="cache.type">lru</entry>

<entry key="db.hostname">XXXXXXXXX</entry>

<entry key="db.password">XXXXXXXXXXX</entry>

<entry key="db.port">XXXX</entry>

<entry key="db.sid">XXXXXX</entry>

<entry key="debug.debugger">false</entry>

<entry key="debug.printDebugToScreen">false</entry>

<entry key="error.keepErrorMessages">true</entry>

<entry key="error.maxEntries">50</entry>

<entry key="jdbc.DriverType">thin</entry>

<entry key="jdbc.InactivityTimeout">1800</entry>

<entry key="jdbc.InitialLimit">3</entry>

<entry key="jdbc.MaxConnectionReuseCount">1000</entry>

<entry key="jdbc.MaxLimit">10</entry>

<entry key="jdbc.MaxStatementsLimit">10</entry>

<entry key="jdbc.MinLimit">1</entry>

<entry key="jdbc.statementTimeout">900</entry>

<entry key="log.logging">false</entry>

<entry key="log.maxEntries">50</entry>

<entry key="misc.compress"/>

<entry key="misc.defaultPage">apex</entry>

<entry key="misc.enableOldFOP">true</entry>

<entry key="security.disableDefaultExclusionList">false</entry>

<entry key="security.maxEntries">2000</entry>

</properties>

Full Log

Aug 14, 2014 11:28:13 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.

Aug 14, 2014 11:28:13 AM oracle.dbtools.standalone.Standalone execute

INFO: Starting standalone Web Container in: /u00/home/oracle/ords/ords

Aug 14, 2014 11:28:14 AM oracle.dbtools.standalone.Deployer deploy

INFO: Will deploy application path = /u00/home/oracle/ords/ords/ords/WEB-INF/web.xml

Aug 14, 2014 11:28:17 AM oracle.dbtools.standalone.Deployer deploy

INFO: Deployed application path = /u00/home/oracle/ords/ords/ords/WEB-INF/web.xml

Aug 14, 2014 11:28:18 AM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder

INFO: Using configuration folder: /u00/home/oracle/ords/ords

Configuration properties for: 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=XXXXXXXXXXXXXXXXXXX

db.password=******

db.port=XXXXXXXXXXXXXXXXXXX

db.sid=XXXXXXXXXXXXXXXXXXX

debug.debugger=false

debug.printDebugToScreen=false

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=false

log.maxEntries=50

misc.compress=

misc.defaultPage=apex

misc.enableOldFOP=true

security.disableDefaultExclusionList=false

security.maxEntries=2000

db.username=APEX_PUBLIC_USER

Aug 14, 2014 11:28:26 AM oracle.dbtools.common.config.db.ConfigurationValues intValue

WARNING: *** jdbc.MaxLimit in configuration apex is using a value of 10, this setting may not be sized adequately for a production environment ***

Aug 14, 2014 11:28:26 AM oracle.dbtools.common.config.db.ConfigurationValues intValue

WARNING: *** jdbc.InitialLimit in configuration apex is using a value of 3, this setting may not be sized adequately for a production environment ***

Using JDBC driver: Oracle JDBC driver version: 11.2.0.3.0

Aug 14, 2014 11:28:28 AM oracle.dbtools.rt.web.SCListener contextInitialized

INFO: Oracle REST Data Services initialized

Oracle REST Data Services version : 2.0.8.163.10.40

Oracle REST Data Services server info: Grizzly/1.9.49

Aug 14, 2014 11:28:28 AM com.sun.grizzly.Controller logVersion

INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 8/14/14 11:28 AM

Aug 14, 2014 11:28:28 AM oracle.dbtools.standalone.Standalone execute

INFO: http://localhost:8080/ords/ started.

Configuration properties for: apex_al

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=XXXXXXXXXXXXXXXXXXX

db.password=******

db.port=XXXXXXXXXXXXXXXXXXX

db.sid=BXXXXXXXXXXXXXXXXXXX

debug.debugger=false

debug.printDebugToScreen=false

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=false

log.maxEntries=50

misc.compress=

misc.defaultPage=apex

misc.enableOldFOP=true

security.disableDefaultExclusionList=false

security.maxEntries=2000

db.username=APEX_LISTENER

Aug 14, 2014 11:32:01 AM oracle.dbtools.common.config.db.ConfigurationValues intValue

WARNING: *** jdbc.MaxLimit in configuration apex_al is using a value of 10, this setting may not be sized adequately for a production environment ***

Aug 14, 2014 11:32:01 AM oracle.dbtools.common.config.db.ConfigurationValues intValue

WARNING: *** jdbc.InitialLimit in configuration apex_al is using a value of 3, this setting may not be sized adequately for a production environment ***

Aug 14, 2014 11:32:03 AM oracle.dbtools.common.config.db.DatabasePoolConfig readPoolConfig

WARNING: The pool_config view or table was not found in schema: APEX_LISTENER

Aug 14, 2014 11:40:49 AM oracle.dbtools.common.config.db.DatabasePoolConfig readPoolConfig

WARNING: The pool_config view or table was not found in schema: APEX_LISTENER

Aug 14, 2014 11:40:50 AM oracle.dbtools.rt.web.WebErrorResponse internalError

SEVERE: JDBCException [kind=NO_DATA]

JDBCException [kind=NO_DATA]

    at oracle.dbtools.common.jdbc.JDBCException.wrap(JDBCException.java:88)

    at oracle.dbtools.common.jdbc.JDBCQueryProvider.query(JDBCQueryProvider.java:63)

    at oracle.dbtools.common.jdbc.JDBCQueryProvider.query(JDBCQueryProvider.java:38)

    at oracle.dbtools.rt.jdbc.entity.JDBCTenantDispatcher.tenant(JDBCTenantDispatcher.java:98)

    at oracle.dbtools.rt.jdbc.entity.TenantDispatcherBase.target(TenantDispatcherBase.java:71)

    at oracle.dbtools.rt.jdbc.entity.TenantDispatcherBase.target(TenantDispatcherBase.java:37)

    at oracle.dbtools.rt.web.ReTargetingDispatcher.canDispatch(ReTargetingDispatcher.java:45)

    at oracle.dbtools.rt.web.RequestDispatchers.choose(RequestDispatchers.java:160)

    at oracle.dbtools.rt.web.RequestDispatchers.dispatch(RequestDispatchers.java:75)

    at oracle.dbtools.rt.web.ETags.checkPrecondition(ETags.java:93)

    at oracle.dbtools.rt.web.HttpEndpointBase.restfulServices(HttpEndpointBase.java:426)

    at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:164)

    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:91)

    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:447)

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)

    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:505)

    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:223)

    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)

    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)

    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)

    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1288)

    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3612)

    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3656)

    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)

    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 com.sun.proxy.$Proxy44.executeQuery(Unknown Source)

    at oracle.dbtools.common.jdbc.JDBCQueryImpl.resultSet(JDBCQueryImpl.java:92)

    at oracle.dbtools.common.jdbc.JDBCResultRowIterator.<init>(JDBCResultRowIterator.java:29)

    at oracle.dbtools.common.jdbc.JDBCQueryImpl.execute(JDBCQueryImpl.java:52)

    at oracle.dbtools.common.jdbc.JDBCQueryProvider.query(JDBCQueryProvider.java:60)

    ... 33 more

This post has been answered by Brad537152 on Aug 15 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 12 2014
Added on Aug 14 2014
1 comment
1,541 views