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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORDS 19.4 with TOMCAT 9.0.30 problem

tironeJan 7 2020 — edited Jan 30 2020

hi,

i am working in the following environment and everything is ok.

I mean that using the following URL http://localhost/apex I access the apex login page

TomCat 9.0.19

Windows server 2016,

ORDS 19.4 used only for APEX 19.2 on

Oracle Database 18c Standard Edition 2 Release 18.0.0.

Version 18.3.0.0.0

Now I have :

- installed, on the same system (new folder), the new version of tomcat 9.0.30.

- stopped ORDS and tomcat 9.0.19

- copied the same apex.war and the same image folder i used in version 9.0.19 to the webapps folder of the of the new tomcat installation

- restarted ords in the new tomcat

but now using the same URL http://localhost/apex I get the following error

pastedImage_9.png

The request could not be mapped to any database. **Check that the request URL is valid and that the database mappings URL has been configured correctl**y..

Stopping ords and the tomcat 9.0.30 service and restarting the tomcat 9.0.19 and ords service is all right again.

what am I doing wrong or missing ?
any help will be appreciated

thank you

saverio

Catalina log_file;

08-Jan-2020 18:02:55.453 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name: Apache Tomcat/9.0.30

08-Jan-2020 18:02:55.453 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Dec 7 2019 16:42:04 UTC

08-Jan-2020 18:02:55.453 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 9.0.30.0

08-Jan-2020 18:02:55.453 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows Server 2016

08-Jan-2020 18:02:55.453 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 10.0

08-Jan-2020 18:02:55.453 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64

08-Jan-2020 18:02:55.453 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: C:\Program Files\Java\jre1.8.0_181

08-Jan-2020 18:02:55.453 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_181-b13

08-Jan-2020 18:02:55.453 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation

08-Jan-2020 18:02:55.453 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: C:\Program Files\Apache Software Foundation\Tomcat930

08-Jan-2020 18:02:55.453 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: C:\Program Files\Apache Software Foundation\Tomcat930

08-Jan-2020 18:02:55.484 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:\Program Files\Apache Software Foundation\Tomcat930

08-Jan-2020 18:02:55.484 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Program Files\Apache Software Foundation\Tomcat930

08-Jan-2020 18:02:55.484 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:\Program Files\Apache Software Foundation\Tomcat930\temp

08-Jan-2020 18:02:55.484 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager

08-Jan-2020 18:02:55.484 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Program Files\Apache Software Foundation\Tomcat930\conf\logging.properties

08-Jan-2020 18:02:55.484 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: exit

08-Jan-2020 18:02:55.484 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: abort

08-Jan-2020 18:02:55.484 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms128m

08-Jan-2020 18:02:55.484 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx256m

08-Jan-2020 18:02:55.484 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: [C:\Program Files\Apache Software Foundation\Tomcat930\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files\Java\jre1.8.0_181\bin;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;D:\app\oracle\base\oradba\product\18.0.3\dbhome_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\ServiceProfiles\LocalService\AppData\Local\Microsoft\WindowsApps;.]

08-Jan-2020 18:02:56.562 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-80"]

08-Jan-2020 18:02:56.750 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]

08-Jan-2020 18:02:56.765 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [2,037] milliseconds

08-Jan-2020 18:02:56.875 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]

08-Jan-2020 18:02:56.875 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.30]

08-Jan-2020 18:02:56.968 INFO [main] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [C:\Program Files\Apache Software Foundation\Tomcat930\webapps\apex.war]

08-Jan-2020 18:03:03.562 INFO [main] 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.

08-Jan-2020 18:03:08.828 INFO [main] . No pools configured yet ?????????

08-Jan-2020 18:03:08.906 INFO [main] . Oracle REST Data Services initialized

Oracle REST Data Services version : 19.4.0.r3521226

Oracle REST Data Services server info: Apache Tomcat/9.0.30

08-Jan-2020 18:03:08.984 INFO [main] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [C:\Program Files\Apache Software Foundation\Tomcat930\webapps\apex.war] has finished in [12,016] ms

08-Jan-2020 18:03:09.000 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat930\webapps\docs]

08-Jan-2020 18:03:09.031 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat930\webapps\docs] has finished in [31] ms

08-Jan-2020 18:03:09.031 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat930\webapps\host-manager]

08-Jan-2020 18:03:09.125 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat930\webapps\host-manager] has finished in [78] ms

08-Jan-2020 18:03:09.125 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat930\webapps\i]

08-Jan-2020 18:03:09.172 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat930\webapps\i] has finished in [47] ms

08-Jan-2020 18:03:09.172 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat930\webapps\manager]

08-Jan-2020 18:03:09.343 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat930\webapps\manager] has finished in [171] ms

08-Jan-2020 18:03:09.343 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat930\webapps\ROOT]

08-Jan-2020 18:03:09.390 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat930\webapps\ROOT] has finished in [47] ms

08-Jan-2020 18:03:09.406 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-80"]

08-Jan-2020 18:03:09.437 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]

08-Jan-2020 18:03:09.437 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in [12,683] milliseconds

Added catalina log_file by tirone

This post has been answered by tirone on Jan 30 2020
Jump to Answer

Comments

Post Details

Added on Jan 7 2020
11 comments
4,576 views