1 Reply Latest reply on Aug 15, 2014 2:08 PM by Brad537152

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

Brad537152 Aug 14, 2014 6:18 PM

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">

<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="db.hostname">XXXXXXXXX</entry>

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

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

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

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

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

<entry key="security.disableDefaultExclusionList">false</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

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

Brad537152 Aug 15, 2014 2:08 PM (in response to Brad537152)

DBA forgot to run apex_rest_config.sql Doh!
Like Show 0 Likes(0)

Actions