Forum Stats

  • 3,874,324 Users
  • 2,266,719 Discussions
  • 7,911,813 Comments

Discussions

ORDS 22.1 404

I'm trying to configure Oracle Apex 22.1 and ORDS to work with Tomcat. I managed to complete all steps as per the Oracle docs instruction.

on my oracle linux I installed APEX 22.2, tomcat 9 and ORDS 22.1. When i try to call APEX with http://<server-name>:<port>/ords/, i get this error "The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured"

Can someone help me please?


Best Answer

Answers

  • CountOfMonteChristo
    CountOfMonteChristo Member Posts: 14 Red Ribbon

    Sounds like the database config files [email protected] are either incorrectly built or do not exist, look in the ords config directory, if the apex_*.xml files are there the ords installation may have been supplied the wrong database location/credentials.

    Solution: Run the java -jar ords.war install again insuring that the db location/passwords are entered correctly.

  • Paavo
    Paavo Member Posts: 756 Silver Badge

    @Ahmedaldam see this thread: Are these versions ok to migrate to 22.1.0 ? it is actually proof of successful upgrade from 21.x to 22.1.0 in tomcat setup - juiced with apache frontend. You might find it helpful.

    Just hint - look carefully the tomcat logs when it loads the ords.war and then the configurations for your pdbs.

    @User_Y9EO9 please work on your nick, its scary. And see the difference between the recent 22.1.x style to configure ords.

    rgrds Paavo

  • CountOfMonteChristo
    CountOfMonteChristo Member Posts: 14 Red Ribbon
    edited May 3, 2022 5:23PM

    @Ahmedaldam Hum,,, I changed my nick yesterday, might only be displayed on new posts? Just checked it, it is set in profile, but does not display here. Could be issue with forum?? Sorry you are Scared,

  • Ahmedaldam
    Ahmedaldam Member Posts: 11 Green Ribbon
    edited May 3, 2022 6:44PM

    @Paavo I am not doing a migration. I installed ords 22.1 with this installation ORACLE-BASE - Oracle REST Data Services (ORDS) : Installation on Tomcat (ORDS Version 22.1 Onward)

    when i restart tomcat and look into the log file i see this

    03-May-2022 19:23:52.440 INFORMATION [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The Apache Tomcat Native library which allows using OpenSSL was not found on the java.library.path: [/usr/java/packages/lib:/usr/lib64:/lib64:/lib:/usr/lib]


    03-May-2022 19:25:10.122 INFORMATION [Catalina-utility-2] oracle.dbtools.common.logging.JDKLogSink.record No pools configured yet


    03-May-2022 19:25:10.163 INFORMATION [Catalina-utility-2] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/opt/tomcat/webapps/ords.war] has finished in [1.450] ms

    03-May-2022 19:25:10.163 INFORMATION [Catalina-utility-2] org.apache.catalina.startup.HostConfig.deployDirectory Deploye Web-Applikations-Verzeichnis [/opt/tomcat/webapps/host-manager]

    03-May-2022 19:25:10.172 INFORMATION [Catalina-utility-2] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/webapps/host-manager] has finished in [9] ms

    03-May-2022 19:25:10.172 INFORMATION [Catalina-utility-2] org.apache.catalina.startup.HostConfig.deployDirectory Deploye Web-Applikations-Verzeichnis [/opt/tomcat/webapps/i]

    03-May-2022 19:25:10.180 INFORMATION [Catalina-utility-2] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/webapps/i] has finished in [8] ms

    03-May-2022 19:25:10.180 INFORMATION [Catalina-utility-2] org.apache.catalina.startup.HostConfig.deployDirectory Deploye Web-Applikations-Verzeichnis [/opt/tomcat/webapps/manager]

    03-May-2022 19:25:10.188 INFORMATION [Catalina-utility-2] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/webapps/manager] has finished in [8] ms

    03-May-2022 19:25:10.188 INFORMATION [Catalina-utility-2] org.apache.catalina.startup.HostConfig.deployDirectory Deploye Web-Applikations-Verzeichnis [/opt/tomcat/webapps/docs]

    03-May-2022 19:25:10.195 INFORMATION [Catalina-utility-2] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/webapps/docs] has finished in [7] ms

    03-May-2022 19:25:10.195 INFORMATION [Catalina-utility-2] org.apache.catalina.startup.HostConfig.deployDirectory Deploye Web-Applikations-Verzeichnis [/opt/tomcat/webapps/examples]

    03-May-2022 19:25:10.258 INFORMATION [Catalina-utility-2] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/webapps/examples] has finished in [63] ms

    03-May-2022 19:25:10.258 INFORMATION [Catalina-utility-2] org.apache.catalina.startup.HostConfig.deployDirectory Deploye Web-Applikations-Verzeichnis [/opt/tomcat/webapps/ROOT]

    03-May-2022 19:25:10.264 INFORMATION [Catalina-utility-2] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/webapps/ROOT] has finished in [6] ms

    what am I doing wrong or missing ?

    any help will be appreciated

    thank you

    Ahmed

  • Paavo
    Paavo Member Posts: 756 Silver Badge

    @Ahmedaldam the log says little about the deployment of ords.war itself.

    Does your setup work if you run ords standalone without tomcat? Meaning are the ords install logs ok and is the routing configuration ok etc..?

    If this is not migrate but your first installation to e.g. some specific pdb only then I recommend you to create specific user to install the ords and rehearse silent install / uninstall cycles until the standalone works. The migration thread gives you maybe some ideas for that.

    Make sure your apex is installed before and pay attention to install logs.

    rgrds Paavo

  • CountOfMonteChristo
    CountOfMonteChristo Member Posts: 14 Red Ribbon

    Running ORDS (Apex via ORDS listener) in standalone mode


    java  -jar ords.war standalone 
    


  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 8,878 Employee
    Answer ✓

    That's not how you run 22.1 anymore

    ords --config /path/to/config serve

    Paavo
  • User_SN2W3
    User_SN2W3 Member Posts: 1 Green Ribbon

    you need to set the following environment variable to point the the ORDS CONFIG directory, restart the tomcat service and you are good to go..

    export JAVA_OPTS="-Dconfig.url=${ORDS_CONFIG}"

    Enrique Flores-Oracle
  • Test2
    Test2 Member Posts: 183 Blue Ribbon

    @thatJeffSmith-Oracle

    There could be a problem in TomCat9

    It is working perfectly on standalone mode, but not with tomcat 9 even though I made sure to run

    export JAVA_OPTS="-Dconfig.url=${ORDS_CONFIG}"

    and even create a file setenv.sh to ensure java_opts is set.

    -------------------------------------


    16-Jul-2022 00:26:35.570 INFO [Catalina-utility-2] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/opt/tomcat/webapps/ords.war] has finished in [2,481] ms

    16-Jul-2022 00:27:03.377 INFO [main] org.apache.catalina.core.StandardServer.await A valid shutdown command was received via the shutdown port. Stopping the Server instance.

    16-Jul-2022 00:27:03.377 INFO [main] org.apache.coyote.AbstractProtocol.pause Pausing ProtocolHandler ["http-nio-8080"]

    16-Jul-2022 00:27:03.382 INFO [main] org.apache.catalina.core.StandardService.stopInternal Stopping service [Catalina]

    16-Jul-2022 00:27:03.417 WARNING [main] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [ords] appears to have started a thread named [DatabasePoolDestroyService] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:

    16-Jul-2022 00:27:03.423 INFO [main] org.apache.coyote.AbstractProtocol.stop Stopping ProtocolHandler ["http-nio-8080"]

    16-Jul-2022 00:27:03.437 INFO [main] org.apache.coyote.AbstractProtocol.destroy Destroying ProtocolHandler ["http-nio-8080"]

    16-Jul-2022 00:27:07.124 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name:  Apache Tomcat/9.0.64

    16-Jul-2022 00:27:07.126 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:     Jun 2 2022 19:08:46 UTC

    16-Jul-2022 00:27:07.126 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 9.0.64.0

    16-Jul-2022 00:27:07.126 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:        Linux

    16-Jul-2022 00:27:07.126 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:      5.4.17-2136.300.7.el8uek.x86_64

    16-Jul-2022 00:27:07.126 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:     amd64

    16-Jul-2022 00:27:07.127 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:       /usr/lib/jvm/java-11-openjdk-11.0.15.0.10-2.el8_6.x86_64

    16-Jul-2022 00:27:07.127 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:      11.0.15+10-LTS

    16-Jul-2022 00:27:07.127 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:      Red Hat, Inc.

    16-Jul-2022 00:27:07.127 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:     /opt/tomcat

    16-Jul-2022 00:27:07.127 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:     /opt/tomcat

    16-Jul-2022 00:27:07.137 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.lang=ALL-UNNAMED

    16-Jul-2022 00:27:07.137 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.io=ALL-UNNAMED

    16-Jul-2022 00:27:07.137 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.util=ALL-UNNAMED

    16-Jul-2022 00:27:07.137 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.util.concurrent=ALL-UNNAMED

    16-Jul-2022 00:27:07.137 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED

    16-Jul-2022 00:27:07.137 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/opt/tomcat/conf/logging.properties

    16-Jul-2022 00:27:07.137 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager

    16-Jul-2022 00:27:07.137 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.awt.headless=true

    16-Jul-2022 00:27:07.138 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.security.egd=file:/dev/./urandom

    16-Jul-2022 00:27:07.138 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048

    16-Jul-2022 00:27:07.138 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources

    16-Jul-2022 00:27:07.138 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027

    16-Jul-2022 00:27:07.138 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms512M

    16-Jul-2022 00:27:07.138 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx1024M

    16-Jul-2022 00:27:07.139 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+UseParallelGC

    16-Jul-2022 00:27:07.139 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=

    16-Jul-2022 00:27:07.139 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/opt/tomcat

    16-Jul-2022 00:27:07.139 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/opt/tomcat

    16-Jul-2022 00:27:07.139 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/opt/tomcat/temp

    16-Jul-2022 00:27:07.141 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The Apache Tomcat Native library which allows using OpenSSL was not found on the java.library.path: [/usr/java/packages/lib:/usr/lib64:/lib64:/lib:/usr/lib]

    16-Jul-2022 00:27:07.413 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]

    16-Jul-2022 00:27:07.434 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [489] milliseconds

    16-Jul-2022 00:27:07.501 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]

    16-Jul-2022 00:27:07.502 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.64]

    16-Jul-2022 00:27:07.516 INFO [main] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [/opt/tomcat/webapps/ords.war]

    16-Jul-2022 00:27:07.821 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.

    16-Jul-2022 00:27:10.204 INFO [main] oracle.dbtools.common.logging.JDKLogSink.record Oracle REST Data Services initialized

    Oracle REST Data Services version : 22.2.0.r1721758

    Oracle REST Data Services server info: Apache Tomcat/9.0.64

    Oracle REST Data Services java info: OpenJDK 64-Bit Server VM 11.0.15+10-LTS


    16-Jul-2022 00:27:10.223 INFO [main] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/opt/tomcat/webapps/ords.war] has finished in [2,707] ms

    16-Jul-2022 00:27:10.224 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/tomcat/webapps/ROOT]

    16-Jul-2022 00:27:10.241 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of

  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 8,878 Employee

    The thread is marked as having a 'solution accepted.' Please don't piggyback, start a new thread.