4 Replies Latest reply on Jul 25, 2016 12:01 AM by xilan

    404 error tomcat

    2907350

      Hello,

       

      I have configured ORDS for PLSQL Gateway on Apache Tomcat

       

      When I am accessing it, I am getting the error below:

      Capture.PNG

       

      Below is the xml in conf folder

       

      plsqluser-pdb1.xml

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

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

      <properties>

      <comment>Saved on Thu Jul 21 11:07:42 MUT 2016</comment>

      <entry key="db.password">@0576D7F1F516BCFD7030DB872CBD6428001046B49E1F5B7741</entry>

      <entry key="db.username">plsqluser</entry>

      </properties>


      Regards,

      Joe

        • 1. Re: 404 error tomcat
          Mike Kutz

          Please post relevant lines from TomCat's error logs.

           

          Did you configure the .war file?

          Did you import that .war file into tomcat or did you use "a fresh copy"?

           

          Why are you not connecting to the database as APEX_PUBLIC_USER or (i forgot name) ORDS_PUBLIC_REST_USER?

           

          I believe the accounts need to have specific permissions in order to operate correctly.  (specifically, PROXY USER capabilities)

          IMHO - Only those accounts that were created through the methods described in the installation guide should be used.

           

          MK

          • 2. Re: 404 error tomcat
            xilan

            Can you please show us all the steps ?

            Seems like the configuration  files cannot be found by ords.war.

             

            What's the output from java -jar ords.war configdir ?  If the output is a relative path, change it to a full path and copy ords.war again to override the old one under webapps of tomcat.

             

            Thanks,

            Xiaohe

            • 3. Re: 404 error tomcat
              2907350

              Hi Xiaohe,

               

              I followed the steps from https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-3-installation-on-tomcat-7

               

              please find attached java -jar ords.war configdir

               

              in ords folder and webapps folder for ords.war file.

               

              configdir.PNG

               

              ordsfolder.PNG

               


              "If the output is a relative path, change it to a full path and copy ords.war again to override the old one under webapps of tomcat."


              How do I change it to the full path? Do I need to reconfigure ORDS?


              Regards,

              SRL SUpport

              • 4. Re: 404 error tomcat
                xilan

                From the directory you unzipped ords, execute configdir command like:

                java -jar ords.war configdir /home/xilan/ords/ORDS-Config

                (Change the path to the correct one on your machine)

                 

                Then just copy ords.war to webapps/ and restart tomcat.

                 

                Hope this helps.

                 

                Thanks,

                Xiaohe

                1 person found this helpful