Hi
I'm a newbie to APEX. I'm installing apex and ran into "The connection pool named: apex is not correctly configured, due to the following error(s): IO Error: The Network Adapter could not establish the connection " error.
But apex|al, apex|pu, apex|rt are configured correctly according to the log files.
Below are the details.
- APEX Installation steps performed by DBAs on the Database Linux server: https://docs.oracle.com/database/apex-5.1/HTMIG/downloading-installing-Oracle-AE.htm#HTMIG29331 (completed through the end of section 4.5)
- APEX ORDS installation and configuration on Windows 2016 Server: Deploying to Apache Tomcat https://docs.oracle.com/cd/E56351_01/doc.30/e87809/installing-REST-data-services.htm#AELIG7224
- Reference article: Oracle REST Data Services (ORDS) 3.0 and 17.x Installation on Tomcat 7, 8 and 9: https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-installation-on-tomcat
tomcat8-stderr.2017-10-06.log
2017-10-06 09:30:50 Commons Daemon procrun stderr initialized
06-Oct-2017 09:30:55.211 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.5.23
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Sep 28 2017 10:30:11 UTC
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.5.23.0
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows Server 2016
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 10.0
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: C:\Program Files\Java\jre1.8.0_144
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_144-b01
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: D:\app\Tomcat8.5
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: D:\app\Tomcat8.5
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=D:\app\Tomcat8.5
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=D:\app\Tomcat8.5
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=D:\app\Tomcat8.5\temp
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=D:\app\Tomcat8.5\conf\logging.properties
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: exit
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms128m
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx256m
06-Oct-2017 09:30:55.258 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [D:\app\Tomcat8.5\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files\Java\jre1.8.0_144\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\system32\config\systemprofile\AppData\Local\Microsoft\WindowsApps;.]
06-Oct-2017 09:30:55.965 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
06-Oct-2017 09:30:56.372 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
06-Oct-2017 09:30:56.387 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
06-Oct-2017 09:30:56.387 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
06-Oct-2017 09:30:56.387 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 2948 ms
06-Oct-2017 09:30:56.497 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
06-Oct-2017 09:30:56.497 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.23
06-Oct-2017 09:30:56.590 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [D:\app\Tomcat8.5\webapps\ords.war]
06-Oct-2017 09:31:03.233 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
06-Oct-2017 09:31:04.586 INFO [localhost-startStop-1] . Using configuration folder: D:\app\ords\conf\ords\conf\ords
06-Oct-2017 09:31:04.638 INFO [localhost-startStop-1] . Validating pool: |apex||
06-Oct-2017 09:31:06.543 SEVERE [localhost-startStop-1] . The connection pool named: apex is not correctly configured, due to the following error(s): IO Error: The Network Adapter could not establish the connection
oracle.dbtools.common.jdbc.ConnectionPoolConfigurationException: The connection pool named: apex is not correctly configured, due to the following error(s): IO Error: The Network Adapter could not establish the connection
at oracle.dbtools.common.config.db.DatabasePools.validateConnection(DatabasePools.java:427)
at oracle.dbtools.common.config.db.DatabasePools.access$100(DatabasePools.java:61)
at oracle.dbtools.common.config.db.DatabasePools$1.call(DatabasePools.java:306)
at oracle.dbtools.common.config.db.DatabasePools$1.call(DatabasePools.java:297)
at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4742)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
at com.google.common.cache.LocalCache.get(LocalCache.java:3937)
at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4739)
at oracle.dbtools.common.config.db.DatabasePools.load(DatabasePools.java:296)
at oracle.dbtools.common.config.db.DatabasePools.databasePool(DatabasePools.java:244)
at oracle.dbtools.common.config.db.DatabasePools.isValid(DatabasePools.java:130)
at oracle.dbtools.common.config.db.DatabasePools.validatePool(DatabasePools.java:441)
at oracle.dbtools.common.config.db.DatabasePools.access$700(DatabasePools.java:61)
at oracle.dbtools.common.config.db.DatabasePools$PoolConfigurationListener.configurationChanged(DatabasePools.java:502)
at oracle.dbtools.common.config.file.ConfigurationFilesBase.addListener(ConfigurationFilesBase.java:79)
at oracle.dbtools.common.config.file.ConfigurationFilesProvider.addListener(ConfigurationFilesProvider.java:21)
at oracle.dbtools.common.config.db.DatabasePools.listenForConfChanges(DatabasePools.java:286)
at oracle.dbtools.common.config.db.DatabasePools.activate(DatabasePools.java:93)
at oracle.dbtools.common.activation.Activator.activate(Activator.java:60)
at oracle.dbtools.common.activation.Activatables.activate(Activatables.java:37)
at oracle.dbtools.common.di.Singletons.get(Singletons.java:113)
at oracle.dbtools.common.di.ServiceFactory.newInstance(ServiceFactory.java:51)
at oracle.dbtools.common.di.Services._acquireAll(Services.java:329)
at oracle.dbtools.common.di.Services.acquire(Services.java:195)
at oracle.dbtools.common.di.Services.acquire(Services.java:175)
at oracle.dbtools.common.jdbc.provider.LegacyDataSourceTargets.setup(LegacyDataSourceTargets.java:31)
at oracle.dbtools.rt.web.SCListener.contextInitialized(SCListener.java:111)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4745)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5207)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:988)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1860)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:743)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:317)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:241)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:184)
at oracle.dbtools.common.config.db.ValidatedConnection.validate(ValidatedConnection.java:74)
at oracle.dbtools.common.config.db.ValidatedConnection.<init>(ValidatedConnection.java:28)
at oracle.dbtools.common.config.db.DatabasePools.validateConnection(DatabasePools.java:422)
... 42 more
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:475)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:506)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:595)
at oracle.net.ns.NSProtocolStream.negotiateConnection(NSProtocolStream.java:221)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:264)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1452)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:496)
... 51 more
Caused by: java.net.SocketTimeoutException: connect timed out
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:161)
at oracle.net.nt.ConnOption.connect(ConnOption.java:159)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:431)
... 57 more
06-Oct-2017 09:31:06.559 SEVERE [localhost-startStop-1] . *** Pool: |apex|| is not correctly configured and will be ignored ***
06-Oct-2017 09:31:06.559 INFO [localhost-startStop-1] . Validating pool: |apex|al|
06-Oct-2017 09:31:07.465 INFO [localhost-startStop-1] . Pool: |apex|al| is correctly configured
06-Oct-2017 09:31:07.465 INFO [localhost-startStop-1] . Validating pool: |apex|pu|
06-Oct-2017 09:31:07.855 INFO [localhost-startStop-1] . Pool: |apex|pu| is correctly configured
06-Oct-2017 09:31:07.855 INFO [localhost-startStop-1] . Validating pool: |apex|rt|
06-Oct-2017 09:31:08.230 INFO [localhost-startStop-1] . Pool: |apex|rt| is correctly configured
06-Oct-2017 09:31:08.605 INFO [localhost-startStop-1] . Oracle REST Data Services initialized
Oracle REST Data Services version : 3.0.12.263.15.32
Oracle REST Data Services server info: Apache Tomcat/8.5.23
06-Oct-2017 09:31:08.668 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [D:\app\Tomcat8.5\webapps\ords.war] has finished in [12,078] ms
06-Oct-2017 09:31:08.668 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [D:\app\Tomcat8.5\webapps\docs]
06-Oct-2017 09:31:08.715 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [D:\app\Tomcat8.5\webapps\docs] has finished in [47] ms
06-Oct-2017 09:31:08.715 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [D:\app\Tomcat8.5\webapps\i]
06-Oct-2017 09:31:08.793 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [D:\app\Tomcat8.5\webapps\i] has finished in [78] ms
06-Oct-2017 09:31:08.793 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [D:\app\Tomcat8.5\webapps\manager]
06-Oct-2017 09:31:08.855 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [D:\app\Tomcat8.5\webapps\manager] has finished in [62] ms
06-Oct-2017 09:31:08.855 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [D:\app\Tomcat8.5\webapps\ROOT]
06-Oct-2017 09:31:08.871 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [D:\app\Tomcat8.5\webapps\ROOT] has finished in [16] ms
06-Oct-2017 09:31:08.887 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
06-Oct-2017 09:31:08.902 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]
06-Oct-2017 09:31:08.918 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 12526 ms
06-Oct-2017 09:31:47.336 INFO [http-nio-8080-exec-10] . Configuration properties for: |apex|pu|
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=<database-host.domain obfuscated>
db.port=<port obfuscated>
db.servicename=<database service obfuscated>
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
security.crypto.enc.password=******
security.crypto.mac.password=******
security.disableDefaultExclusionList=false
security.maxEntries=2000
security.requestValidationFunction=wwv_flow_epg_include_modules.authorize
security.validationFunctionType=plsql
db.password=******
db.username=ORDS_PUBLIC_USER
06-Oct-2017 09:31:47.336 WARNING [http-nio-8080-exec-10] . *** jdbc.MaxLimit in configuration |apex|pu| is using a value of 10, this setting may not be sized adequately for a production environment ***
06-Oct-2017 09:31:47.336 WARNING [http-nio-8080-exec-10] . *** jdbc.InitialLimit in configuration |apex|pu| is using a value of 3, this setting may not be sized adequately for a production environment ***
06-Oct-2017 09:31:47.352 INFO [http-nio-8080-exec-10] . 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=<hostname>
db.port=<port>
db.servicename=<service name>
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
security.crypto.enc.password=******
security.crypto.mac.password=******
security.disableDefaultExclusionList=false
security.maxEntries=2000
security.requestValidationFunction=wwv_flow_epg_include_modules.authorize
security.validationFunctionType=plsql
db.password=******
db.username=APEX_LISTENER
06-Oct-2017 09:31:47.352 WARNING [http-nio-8080-exec-10] . *** jdbc.MaxLimit in configuration |apex|al| is using a value of 10, this setting may not be sized adequately for a production environment ***
06-Oct-2017 09:31:47.352 WARNING [http-nio-8080-exec-10] . *** jdbc.InitialLimit in configuration |apex|al| is using a value of 3, this setting may not be sized adequately for a production environment ***
06-Oct-2017 09:31:47.461 INFO [http-nio-8080-exec-10] oracle.ucp.common.UniversalConnectionPoolBase.initInactiveConnectionTimeoutTimer inactive connection timeout timer scheduled
06-Oct-2017 09:31:52.022 INFO [http-nio-8080-exec-10] oracle.ucp.common.UniversalConnectionPoolBase.initInactiveConnectionTimeoutTimer inactive connection timeout timer scheduled
ORDS config files
Error in the web browser
---
thank you
Message was edited by: orawin2; added url images.
Message was edited by: orawin2