14 Replies Latest reply on May 22, 2015 10:04 AM by OrcL-FaN

    ORACLE REST DATA SERVICES 404 NOT FOUND

    OrcL-FaN

      Hello All,

      Please suggest me the possible ways to solve the below issue.

       

      DB:-   11gR2(11.2.0.4)

      OS:-   OEL 6.5

      APEX:- 4.2.6

      ORDS(formerly known as Apex Listener)- 3.0

      Tomcat-  7.0.53

      Jdk-    1.7.0_45

       

      *****Followed the steps mentioned in URL to implement the ORDS for APEX application on APACHE TOMCAT

       

      http://oracle-base.com/articles/misc/oracle-rest-data-services-ords-3-installation-on-tomcat-7.php#downloads

       

                    ===================================Error=================================

       

      while running the URL(www.server-name:8080/ords) in browser it is showing-

       

      ORACLE REST DATA SERVICES

      404 NOT FOUND

       

      [***Note:

      A>  It is showing the version of apex if i execute the below URL.  

             www.server-name:8080/i/apex_version.txt

      B> No problem with tomcat. It is coming very well in browser on URL

             www.server-name:8080

      ]

       

      Thanks & Regards,

      Pinto Das

        • 1. Re: ORACLE REST DATA SERVICES 404 NOT FOUND
          Kiran Pawar

          Hi 2908231,

          2908231 wrote:

               Please change your user handle from "2908231" to something meaningful. Refer : Video tutorial how to change nickname available

          2908231 wrote:

           

          Hello All,

          Please suggest me the possible ways to solve the below issue.

           

          DB:-  11gR2(11.2.0.4)

          OS:-  OEL 6.5

          APEX:- 4.2.6

          ORDS(formerly known as Apex Listener)- 3.0

          Tomcat-  7.0.53

          Jdk-    1.7.0_45

           

          *****Followed the steps mentioned in URL to implement the ORDS for APEX application on APACHE TOMCAT

           

          http://oracle-base.com/articles/misc/oracle-rest-data-services-ords-3-installation-on-tomcat-7.php#downloads

           

                        ===================================Error=================================

           

          while running the URL(www.server-name:8080/ords) in browser it is showing-

           

          ORACLE REST DATA SERVICES

          404 NOT FOUND

           

          [***Note:

          A>  It is showing the version of apex if i execute the below URL.

                www.server-name:8080/i/apex_version.txt

          B> No problem with tomcat. It is coming very well in browser on URL

                www.server-name:8080

          ]

           

          Thanks & Regards,

          Pinto Das

               Why are you following blog when Oracle has given nice documentation for the same purpose?

               Refer : Oracle REST Data Services 3.0 documentation.

               You are using ORDS 3.0 which is in Early Adopter (Beta) release stage, instead you should go for latest stable version of ORDS 2.0 viz. 2.0.10.

               Refer : Oracle REST Data Services 2.0 documentation.

               Lastly, I am sure that something went wrong while installing and configuring ORDS, the reason is that there is fat chance that you have copy pasted the commands from above mentioned blog. Instead you should have read the above documentations and understood what the command does and what input parameters each command requires and what/where are they in my environment context.

           

               Request NOTE : Please use the following forum for Oracle REST Data Services related questions : ORDS, SODA & JSON in the Database

           

               Hope this helps!

           

          Regards,

          Kiran

          • 2. Re: ORACLE REST DATA SERVICES 404 NOT FOUND
            OrcL-FaN

            Hello Kiran Pawar,

            Thanks for your kind reply and sorry for not following up. For your kind information I have not copy pasted the commands, rather i have also followed the oracle documents. Now i have tried the same installation into a different environment but unfortunately facing the same issue. Details are as below:

             

            DB:-   11gR2(11.2.0.2.0)

            OS:-   OEL 6.5

            APEX:- 5.0

            ORDS(formerly known as Apex Listener)- ords.3.0.0.121.10.23

            Tomcat:-  apache-tomcat-7.0.62

            Jdk-    1.7.0_67

             

            This time i have followed the oracle documentation..

            https://docs.oracle.com/cd/E37099_01/doc.20/e25066/install.htm#AELIG7017

             

            Any suggestion would be a great help.

             

            Thanks & Regards,

            Pinto Das

            • 3. Re: ORACLE REST DATA SERVICES 404 NOT FOUND
              Kiran Pawar

              Hi Pinto Das,

              Pinto Das wrote:

               

              Hello Kiran Pawar,

              Thanks for your kind reply and sorry for not following up. For your kind information I have not copy pasted the commands, rather i have also followed the oracle documents. Now i have tried the same installation into a different environment but unfortunately facing the same issue. Details are as below:

               

              DB:-   11gR2(11.2.0.2.0)

              OS:-   OEL 6.5

              APEX:- 5.0

              ORDS(formerly known as Apex Listener)- ords.3.0.0.121.10.23

              Tomcat:-  apache-tomcat-7.0.62

              Jdk-    1.7.0_67

               

              This time i have followed the oracle documentation..

              https://docs.oracle.com/cd/E37099_01/doc.20/e25066/install.htm#AELIG7017

                   Sorry, if i was harsh in my comments above.

                   I would still say that the error indicates there is something wrong with your ORDS 3.0 configuration.

                   Refer a recent similar thread : ORDS 3 404 Error

                   More appropriate forum for ORDS related issues is : ORDS, SODA & JSON in the Database

               

                   As a advance intimation as you are using APEX 5.0 and ORDS as your Web Listener you may run into static files configuration issue if you have not configured RESTful services after APEX installation and while configuring ORDS. Reason is configuring RESTful Services while using ORDS as Web Listener option is mandatory in APEX 5.0.

                   Refer : Re: Static Application and Workspace Files in APEX 5

               

              Regards,

              Kiran

              • 4. Re: ORACLE REST DATA SERVICES 404 NOT FOUND
                OrcL-FaN

                Hello Kiran Pawar ,

                 

                I already went through that thread and tried the given solutions but that doesn't click for me. Below is the output of one log file. Please have a look on that and let me know if you find any issue in that..

                 

                [root@testing logs]# cat localhost.2015-05-21.log

                May 21, 2015 2:52:17 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextInitialized()

                May 21, 2015 2:52:17 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextInitialized()

                May 21, 2015 2:52:17 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCache', 'org.apache.jasper.compiler.TldLocationsCache@30a6aae0')

                May 21, 2015 2:53:58 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextDestroyed()

                May 21, 2015 2:53:58 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextDestroyed()

                May 21, 2015 3:14:23 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Using configuration folder: /opt/ords_config_data/ords

                May 21, 2015 3:14:23 PM org.apache.catalina.core.ApplicationContext log

                INFO: FINEST:

                ApplicationContext [configurationFolder=/opt/ords_config_data/ords, services=Application Scope]

                 

                 

                May 21, 2015 3:14:25 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Oracle REST Data Services initialized

                Oracle REST Data Services version : 3.0.0.121.10.23

                Oracle REST Data Services server info: Apache Tomcat/7.0.62

                 

                 

                May 21, 2015 3:14:26 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextInitialized()

                May 21, 2015 3:14:26 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextInitialized()

                May 21, 2015 3:14:26 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCache', 'org.apache.jasper.compiler.TldLocationsCache@1fb01b88')

                May 21, 2015 3:58:51 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Using configuration folder: /opt/ords_config_data/ords

                May 21, 2015 3:58:51 PM org.apache.catalina.core.ApplicationContext log

                INFO: FINEST:

                ApplicationContext [configurationFolder=/opt/ords_config_data/ords, services=Application Scope]

                 

                 

                May 21, 2015 3:58:52 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Oracle REST Data Services initialized

                Oracle REST Data Services version : 3.0.0.121.10.23

                Oracle REST Data Services server info: Apache Tomcat/7.0.62

                 

                 

                May 21, 2015 3:59:36 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextDestroyed()

                May 21, 2015 3:59:36 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextDestroyed()

                May 21, 2015 3:59:46 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Using configuration folder: /opt/ords_config_data/ords

                May 21, 2015 3:59:46 PM org.apache.catalina.core.ApplicationContext log

                INFO: FINEST:

                ApplicationContext [configurationFolder=/opt/ords_config_data/ords, services=Application Scope]

                 

                 

                May 21, 2015 3:59:47 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Oracle REST Data Services initialized

                Oracle REST Data Services version : 3.0.0.121.10.23

                Oracle REST Data Services server info: Apache Tomcat/7.0.62

                 

                 

                May 21, 2015 3:59:48 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextInitialized()

                May 21, 2015 3:59:48 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextInitialized()

                May 21, 2015 3:59:48 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCache', 'org.apache.jasper.compiler.TldLocationsCache@688de887')

                May 21, 2015 4:03:46 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextDestroyed()

                May 21, 2015 4:03:46 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextDestroyed()

                May 21, 2015 4:03:59 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Using configuration folder: /opt/ords_config_data/ords

                May 21, 2015 4:03:59 PM org.apache.catalina.core.ApplicationContext log

                INFO: FINEST:

                ApplicationContext [configurationFolder=/opt/ords_config_data/ords, services=Application Scope]

                 

                 

                May 21, 2015 4:04:02 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Oracle REST Data Services initialized

                Oracle REST Data Services version : 3.0.0.121.10.23

                Oracle REST Data Services server info: Apache Tomcat/7.0.62

                 

                 

                May 21, 2015 4:04:03 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextInitialized()

                May 21, 2015 4:04:03 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextInitialized()

                May 21, 2015 4:04:03 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCache', 'org.apache.jasper.compiler.TldLocationsCache@44883a19')

                May 21, 2015 4:05:16 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextDestroyed()

                May 21, 2015 4:05:16 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextDestroyed()

                May 21, 2015 4:05:26 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Using configuration folder: /opt/ords_config_data/ords

                May 21, 2015 4:05:26 PM org.apache.catalina.core.ApplicationContext log

                INFO: FINEST:

                ApplicationContext [configurationFolder=/opt/ords_config_data/ords, services=Application Scope]

                 

                 

                May 21, 2015 4:05:33 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Oracle REST Data Services initialized

                Oracle REST Data Services version : 3.0.0.121.10.23

                Oracle REST Data Services server info: Apache Tomcat/7.0.62

                 

                 

                May 21, 2015 4:05:33 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextInitialized()

                May 21, 2015 4:05:33 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextInitialized()

                May 21, 2015 4:05:33 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCache', 'org.apache.jasper.compiler.TldLocationsCache@3c9d2cb1')

                May 21, 2015 4:16:02 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextDestroyed()

                May 21, 2015 4:16:02 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextDestroyed()

                May 21, 2015 4:16:12 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Using configuration folder: /opt/ords_config_data/ords

                May 21, 2015 4:16:12 PM org.apache.catalina.core.ApplicationContext log

                INFO: FINEST:

                ApplicationContext [configurationFolder=/opt/ords_config_data/ords, services=Application Scope]

                 

                 

                May 21, 2015 4:16:13 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Oracle REST Data Services initialized

                Oracle REST Data Services version : 3.0.0.121.10.23

                Oracle REST Data Services server info: Apache Tomcat/7.0.62

                 

                 

                May 21, 2015 4:16:14 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextInitialized()

                May 21, 2015 4:16:14 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextInitialized()

                May 21, 2015 4:16:14 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCache', 'org.apache.jasper.compiler.TldLocationsCache@1ee13f9e')

                May 21, 2015 4:19:23 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextDestroyed()

                May 21, 2015 4:19:23 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextDestroyed()

                May 21, 2015 4:19:33 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Using configuration folder: /opt/ords_config_data/ords

                May 21, 2015 4:19:33 PM org.apache.catalina.core.ApplicationContext log

                INFO: FINEST:

                ApplicationContext [configurationFolder=/opt/ords_config_data/ords, services=Application Scope]

                 

                 

                May 21, 2015 4:19:41 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Oracle REST Data Services initialized

                Oracle REST Data Services version : 3.0.0.121.10.23

                Oracle REST Data Services server info: Apache Tomcat/7.0.62

                 

                 

                May 21, 2015 4:19:42 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextInitialized()

                May 21, 2015 4:19:42 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextInitialized()

                May 21, 2015 4:19:42 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCache', 'org.apache.jasper.compiler.TldLocationsCache@5617ade8')

                May 21, 2015 4:25:46 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Using configuration folder: /opt/ords_config_data/ords

                May 21, 2015 4:25:46 PM org.apache.catalina.core.ApplicationContext log

                INFO: FINEST:

                ApplicationContext [configurationFolder=/opt/ords_config_data/ords, services=Application Scope]

                 

                 

                May 21, 2015 4:25:46 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Oracle REST Data Services initialized

                Oracle REST Data Services version : 3.0.0.121.10.23

                Oracle REST Data Services server info: Apache Tomcat/7.0.62

                 

                 

                May 21, 2015 4:26:01 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Using configuration folder: /opt/ords_config_data/apex

                May 21, 2015 4:26:01 PM org.apache.catalina.core.ApplicationContext log

                INFO: FINEST:

                ApplicationContext [configurationFolder=/opt/ords_config_data/apex, services=Application Scope]

                 

                 

                May 21, 2015 4:26:01 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Oracle REST Data Services initialized

                Oracle REST Data Services version : 3.0.0.121.10.23

                Oracle REST Data Services server info: Apache Tomcat/7.0.62

                 

                 

                May 21, 2015 4:26:04 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextDestroyed()

                May 21, 2015 4:26:04 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextDestroyed()

                May 21, 2015 4:26:13 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Using configuration folder: /opt/ords_config_data/apex

                May 21, 2015 4:26:13 PM org.apache.catalina.core.ApplicationContext log

                INFO: FINEST:

                ApplicationContext [configurationFolder=/opt/ords_config_data/apex, services=Application Scope]

                 

                 

                May 21, 2015 4:26:14 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Oracle REST Data Services initialized

                Oracle REST Data Services version : 3.0.0.121.10.23

                Oracle REST Data Services server info: Apache Tomcat/7.0.62

                 

                 

                May 21, 2015 4:26:14 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextInitialized()

                May 21, 2015 4:26:14 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextInitialized()

                May 21, 2015 4:26:14 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCache', 'org.apache.jasper.compiler.TldLocationsCache@5e220a23')

                May 21, 2015 5:01:58 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextDestroyed()

                May 21, 2015 5:01:58 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextDestroyed()

                May 21, 2015 5:02:07 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Using configuration folder: /opt/ords_config_data/apex

                May 21, 2015 5:02:07 PM org.apache.catalina.core.ApplicationContext log

                INFO: FINEST:

                ApplicationContext [configurationFolder=/opt/ords_config_data/apex, services=Application Scope]

                 

                 

                May 21, 2015 5:02:08 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Oracle REST Data Services initialized

                Oracle REST Data Services version : 3.0.0.121.10.23

                Oracle REST Data Services server info: Apache Tomcat/7.0.62

                 

                 

                May 21, 2015 5:02:08 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextInitialized()

                May 21, 2015 5:02:08 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextInitialized()

                May 21, 2015 5:02:08 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCache', 'org.apache.jasper.compiler.TldLocationsCache@5e5fb7e4')

                May 21, 2015 5:03:35 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Using configuration folder: /opt/ords_config_data/ords

                May 21, 2015 5:03:35 PM org.apache.catalina.core.ApplicationContext log

                INFO: FINEST:

                ApplicationContext [configurationFolder=/opt/ords_config_data/ords, services=Application Scope]

                 

                 

                May 21, 2015 5:03:37 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Oracle REST Data Services initialized

                Oracle REST Data Services version : 3.0.0.121.10.23

                Oracle REST Data Services server info: Apache Tomcat/7.0.62

                 

                 

                May 21, 2015 5:03:38 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextDestroyed()

                May 21, 2015 5:03:38 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextDestroyed()

                May 21, 2015 5:03:45 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Using configuration folder: /opt/ords_config_data/ords

                May 21, 2015 5:03:45 PM org.apache.catalina.core.ApplicationContext log

                INFO: FINEST:

                ApplicationContext [configurationFolder=/opt/ords_config_data/ords, services=Application Scope]

                 

                 

                May 21, 2015 5:03:45 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Oracle REST Data Services initialized

                Oracle REST Data Services version : 3.0.0.121.10.23

                Oracle REST Data Services server info: Apache Tomcat/7.0.62

                 

                 

                May 21, 2015 5:03:46 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextInitialized()

                May 21, 2015 5:03:46 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextInitialized()

                May 21, 2015 5:03:46 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCache', 'org.apache.jasper.compiler.TldLocationsCache@1422c15c')

                May 21, 2015 5:04:20 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextDestroyed()

                May 21, 2015 5:04:20 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextDestroyed()

                May 21, 2015 5:04:30 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Using configuration folder: /opt/ords_config_data/ords

                May 21, 2015 5:04:30 PM org.apache.catalina.core.ApplicationContext log

                INFO: FINEST:

                ApplicationContext [configurationFolder=/opt/ords_config_data/ords, services=Application Scope]

                 

                 

                May 21, 2015 5:04:31 PM org.apache.catalina.core.ApplicationContext log

                INFO: INFO: Oracle REST Data Services initialized

                Oracle REST Data Services version : 3.0.0.121.10.23

                Oracle REST Data Services server info: Apache Tomcat/7.0.62

                 

                 

                May 21, 2015 5:04:31 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: contextInitialized()

                May 21, 2015 5:04:31 PM org.apache.catalina.core.ApplicationContext log

                INFO: SessionListener: contextInitialized()

                May 21, 2015 5:04:31 PM org.apache.catalina.core.ApplicationContext log

                INFO: ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCache', 'org.apache.jasper.compiler.TldLocationsCache@24aab9bd')

                [root@testing logs]#

                 

                 

                Thanks & Regards,

                Pinto Das

                • 5. Re: ORACLE REST DATA SERVICES 404 NOT FOUND
                  Kiran Pawar

                  Hi Pinto Das,

                   

                       Which log file is above mentioned log? ORDS/Tomcat?

                       I would you to configure ORDS logging as mentioned by Patrick Wolf in the following thread:

                       Re: Static Application and Workspace Files in APEX 5

                       or as done by John in the following thread:

                       Re: Re: Theme roller generated CSS not found by ORDS

                       Then always check starting from the tail of the log for errors if any. That will point you to the actual error.

                       Please do not paste the whole lengthy log file, instead you can add it as attachment.

                   

                  Regards,

                  Kiran

                  • 6. Re: ORACLE REST DATA SERVICES 404 NOT FOUND
                    OrcL-FaN

                    Hello Kiran Pawar,

                     

                    That was tomcat log. Location was as below-

                    [root@testing logs]# pwd

                    /opt/apache-tomcat-7.0.62/logs

                    [root@testing logs]# ls -l

                    total 860

                    -rw-r--r-- 1 root root 423696 May 21 17:05 catalina.2015-05-21.log

                    -rw-r--r-- 1 root root 423696 May 21 17:05 catalina.out

                    -rw-r--r-- 1 root root      0 May 21 14:52 host-manager.2015-05-21.log

                    -rw-r--r-- 1 root root  15009 May 21 17:04 localhost.2015-05-21.log

                    -rw-r--r-- 1 root root   3391 May 21 17:06 localhost_access_log.2015-05-21.txt

                    -rw-r--r-- 1 root root      0 May 21 14:52 manager.2015-05-21.log

                    [root@testing logs]#

                     

                    I was trying to install the ords for apex listener perpose only. My apex page itself is not uploading.

                     

                    Thanks & Regards,

                    Pinto Das

                    • 7. Re: ORACLE REST DATA SERVICES 404 NOT FOUND
                      Kiran Pawar

                      Hi Pinto Das,

                       

                           Please see my reply above, enable ORDS logging and check the error messages in your browser.

                       

                      Regards,

                      Kiran

                      • 8. Re: ORACLE REST DATA SERVICES 404 NOT FOUND
                        TexasApexDeveloper

                        Simple answer, Please move this this conversation to the ORDS specific forum.  It is not an APEX specific question..: ORDS, SODA & JSON in the Database

                         

                        Thank you,

                         

                        Tony Miller
                        LuvMuffin Software
                        Ruckersville, VA

                        • 9. Re: ORACLE REST DATA SERVICES 404 NOT FOUND
                          OrcL-FaN

                          Hello TexasApexDeveloper,

                          I have started a discussion over there. Sorry for the inconvenience. 

                           

                          Thanks & Regards,

                          Pinto Das

                          • 10. Re: ORACLE REST DATA SERVICES 404 NOT FOUND
                            OrcL-FaN

                            Hello Kiran Pawar,

                             

                            Though i have enabled the ORDS logging but still i can't see any error message in the browser. Infact i can see only tomcat logs, there is no log file for ords.

                             

                            Thanks & Regards,

                            Pinto Das

                            • 11. Re: Re: ORACLE REST DATA SERVICES 404 NOT FOUND
                              Kiran Pawar

                              Hi Pinto Das,

                              Pinto Das wrote:


                              Though i have enabled the ORDS logging but still i can't see any error message in the browser. Infact i can see only tomcat logs, there is no log file for ords.

                                  You have to enabled the following two debug properties in defaults.xml?

                              <entry key="debug.debugger">true</entry>
                              <entry key="debug.printDebugToScreen">true</entry>
                              
                              

                                  The second entry enables printing debug to screen.

                                  Refer :

                                  

                                   I wanted to post this reply on the forum ORDS, SODA & JSON in the Database where you have opened new thread: ORACLE REST DATA SERVICES 404 NOT FOUND but unable to do so as the thread is locked.

                                  

                              Regards,

                              Kiran

                              • 12. Re: Re: ORACLE REST DATA SERVICES 404 NOT FOUND
                                OrcL-FaN

                                Hello Kiran Pawar,

                                 

                                Thanks for your kind response. Below is the output of browser log message.....

                                 

                                Debug Trace

                                 mapped request using: /* to: PLSQL:apex  Could not find any dispatcher to handle request: --Attributes-- nanoStart = 1432281692125 apex.diagnostic.context = Attempting to process as a Dispatchable Service  ECID-Principal = ECIDPrincipal [ecid=j2rOYDwxj3D_mgmE_60HCQ..] oracle.dbtools.http.ecid = 1jXdVvD8afiKhXWQYKGc0A.. oracle.dbtools.common.di.Services = Request Scope --Attributes-- GET /ords/ HTTP/1.1 Host: 192.168.2.220 host: 192.168.2.220:8080 connection: keep-alive cache-control: max-age=0 accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 user-agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 Safari/537.36 accept-encoding: gzip, deflate, sdch accept-language: en-US,en;q=0.8   org.apache.catalina.connector.CoyoteInputStream@cd0cca3 

                                Thanks & Regards,

                                Pinto Das

                                • 13. Re: Re: Re: ORACLE REST DATA SERVICES 404 NOT FOUND
                                  Kiran Pawar

                                  Hi Pinto Das,

                                  Pinto Das wrote:


                                  Thanks for your kind response. Below is the output of browser log message.....

                                   

                                  Debug Trace

                                   mapped request using: /* to: PLSQL:apex  Could not find any dispatcher to handle request: --Attributes-- nanoStart = 1432281692125 apex.diagnostic.context = Attempting to process as a Dispatchable Service  ECID-Principal = ECIDPrincipal [ecid=j2rOYDwxj3D_mgmE_60HCQ..] oracle.dbtools.http.ecid = 1jXdVvD8afiKhXWQYKGc0A.. oracle.dbtools.common.di.Services = Request Scope --Attributes-- GET /ords/ HTTP/1.1 Host: 192.168.2.220 host: 192.168.2.220:8080 connection: keep-alive cache-control: max-age=0 accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 user-agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 Safari/537.36 accept-encoding: gzip, deflate, sdch accept-language: en-US,en;q=0.8   org.apache.catalina.connector.CoyoteInputStream@cd0cca3 

                                      Unable to find any important clue from the debug trace above. Is this only the debug trace printed?

                                      Also have you renamed ords.war to apex.war?

                                      Have you configured the PL/SQL Gateway when the ords.war installation prompted you to? (Note here PL/SQL Gateway does not refer to EPG, but to configure Oracle APEX with ORDS)

                                      This is how the ORDS setup asks for PL/SQL Gateway configuration:

                                  Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step [1]:1
                                  Enter the PL/SQL Gateway database user name [APEX_PUBLIC_USER]:
                                  Enter the database password for APEX_PUBLIC_USER:
                                  Confirm password:
                                  

                                      If not then you have not configured Oracle APEX with ORDS. Refer : Re: Re: ORDS 3 404 Error See the Colm Divilly's reply.

                                   

                                  Regards,

                                  Kiran

                                  • 14. Re: Re: Re: ORACLE REST DATA SERVICES 404 NOT FOUND
                                    OrcL-FaN

                                    Hello Kiran Pawar,

                                     

                                    Yes i have configured PL/SQL gateway when prompted by ords installation. And if i want to access the url as /ords then i think we don't need to change the ords.war file to apex.war (as per oracle recomendataion).

                                    https://docs.oracle.com/cd/E37099_01/doc.20/e25066/install.htm#AELIG7017

                                    One more error message was there along with debug trace in that browser-

                                     

                                    Stack Trace

                                     oracle.dbtools.http.errors.NotFoundException at oracle.dbtools.http.entrypoint.Dispatcher.choose(Dispatcher.java:87) at oracle.dbtools.http.entrypoint.Dispatcher.dispatch(Dispatcher.java:97) at oracle.dbtools.http.entrypoint.EntryPoint$FilteredServlet.service(EntryPoint.java:117) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.dbtools.http.forwarding.QueryFilteringRewrite.doFilter(QueryFilteringRewrite.java:82) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51) at oracle.dbtools.http.forwarding.ForwardingFilter.doFilter(ForwardingFilter.java:58) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51) at oracle.dbtools.http.cors.CORSPreflightFilter.doFilter(CORSPreflightFilter.java:67) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51) at oracle.dbtools.http.cookies.auth.CookieSessionCSRFFilter.doFilter(CookieSessionCSRFFilter.java:61) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51) at oracle.dbtools.http.auth.AuthenticationFilter.authenticate(AuthenticationFilter.java:95) at oracle.dbtools.http.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:67) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51) at oracle.dbtools.url.mapping.db.PLSQLMapper.doFilter(PLSQLMapper.java:37) at oracle.dbtools.url.mapping.URLMapping.doFilter(URLMapping.java:78) at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappingFilter.java:63) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51) at oracle.dbtools.http.locale.LocaleFilter.doFilter(LocaleFilter.java:60) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51) at oracle.dbtools.http.cors.CORSResponseFilter.doFilter(CORSResponseFilter.java:71) at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponseFilter.java:45) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51) at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:71) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51) at oracle.dbtools.http.ecid.ECIDFilter.doFilter(ECIDFilter.java:35) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51) at oracle.dbtools.http.filters.Filters.filter(Filters.java:46) at oracle.dbtools.http.entrypoint.EntryPoint.service(EntryPoint.java:74) at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointServlet.java:46) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at oracle.dbtools.rt.web.HttpEndpointBase.dispatchableServices(HttpEndpointBase.java:166) at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:88) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:744)

                                    Thanks & Regards,

                                    Pinto Das