2 Replies Latest reply on May 31, 2016 6:26 AM by PJ62

    ORACLE REST DATA SERVICES 404 Not Found

    PJ62

      ORACLE REST DATA SERVICES 404 Not Found

       

      Not the only person to have had issues with this I see but not had any success from previous posts.

       

      To help isolate the problem I have kept it very simple:-

       

      1. Create new DBAAS server instance (now comes with Apex 5.0 and ORDS 3.0 but without Glassfish installed even though ORDS standalone mode is only recommended for development? so I need to install glassfish).

      2. Open up http, https and httpadmin ports to public (80, 443, 4848) - yes, understand this is not secure, just trying to debug this issue and remove possible causes

      3. Verify ORDS is all working correctly on ports 80 and 443 on http(s)://<ipaddress>/apex . Am able to log into Apex Admin Console etc. Assumption: ORDS -> DB is all configured correctly and working (as you would expect with a pre-configured DBAAS service)

      4. Remove ORDS standalone startup from init.d and reboot the server - nice and clean - no standalone ORDS running

      5. Now download and install Glassfish web profile, any version will do. Same problem on every version I tried from 3.1.2.2 (following links ORDS 3 Installation guide) to 4.1.1 latest build

      6. Change http-listener-1 from port 8080 (default) to port 80 and http-listener-2 from port 8181 to port 443

      7. Following ORDS 3.0 Installation, Configuration and Development Guide:-

      7.1 Create i.war for static images linked to apex images directory

      7.2 Deploy ords.war as application ords context root /ords

      7.3 Deploy i.war as application i context root <null>

      8. Check i.war is locating images correctly in browser with http://<ipaddress>/i/apex_version.txt - successfully resolves and returns "Application Express Version: 5.0"

      9. Try to access Apex - http://<ipaddress>/ords

      ORACLE REST DATA SERVICES 404 Not Found

      10. Have also tried:-

      http://<ipaddress>/ords/ - same result

      https://<ipaddress>/ords - same result

      https://<ipaddress>/ords/ - same result

      changing application context to /apex and http://<ipaddress>/apex - same result

      restarting everything and repeating all above - same result

      Also tried setting debug config options as suggested in install doco:-

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

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

      checked glassfish server.log – no errors

       

      Debug Trace:-

      Could not find any dispatcher to handle request:

      --Attributes--

      • org.glassfish.web.RequestFacadeHelper = org.apache.catalina.core.RequestFacadeHelper@6e6a43a4
      1. apex.diagnostic.context = ...

      ECID-Principal = ECIDPrincipal [ecid=2YRpgOuSXge1XaLHV2CI8Q..]

      • oracle.dbtools.http.ecid = c5kD76OEp7eFG3OWpgdDdQ..
      • oracle.dbtools.common.di.Services = Request Scope

      --Attributes--

      GET /ords/ HTTP/1.1

      Host: xxx.xxxxxx.com

      host: xxx.xxxxxx.com

      connection: keep-alive

      cache-control: max-age=0

      accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8

      upgrade-insecure-requests: 1

      user-agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.102 Safari/537.36

      accept-encoding: gzip, deflate, sdch

      accept-language: en-GB,en-US;q=0.8,en;q=0.6

      cookie: PSOL_WS_CODE=BUN; ORA_WWV_REMEMBER_UN=ADMIN:INTERNAL; _ga=GA1.2.1684365726.1451626261; treeForm_tree-hi=

       

       

      • org.apache.catalina.connector.CoyoteInputStream@27efc9e

       

      What have I missed or done wrong ? ????

       

      Any help appreciated.

       

       


       

        • 1. Re: ORACLE REST DATA SERVICES 404 Not Found
          Kiran Pawar

          Hi PJ62,

          PJ62 wrote:

           

          ORACLE REST DATA SERVICES 404 Not Found

          Not the only person to have had issues with this I see but not had any success from previous posts.

          To help isolate the problem I have kept it very simple:-

          1. Create new DBAAS server instance (now comes with Apex 5.0 and ORDS 3.0 but without Glassfish installed even though ORDS standalone mode is only recommended for development? so I need to install glassfish).

          ...

          8. Check i.war is locating images correctly in browser with http://<ipaddress>/i/apex_version.txt - successfully resolves and returns "Application Express Version: 5.0"

          9. Try to access Apex - http://<ipaddress>/ords

          ORACLE REST DATA SERVICES 404 Not Found

          10. Have also tried:-

          http://<ipaddress>/ords/ - same result

          https://<ipaddress>/ords - same result

          https://<ipaddress>/ords/ - same result

          changing application context to /apex and http://<ipaddress>/apex - same result

          restarting everything and repeating all above - same result

          Also tried setting debug config options as suggested in install doco:-

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

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

          checked glassfish server.log – no errors

           

          Debug Trace:-

          Could not find any dispatcher to handle request:

          --Attributes--

          • org.glassfish.web.RequestFacadeHelper = org.apache.catalina.core.RequestFacadeHelper@6e6a43a4
          1. apex.diagnostic.context = ...

          ECID-Principal = ECIDPrincipal [ecid=2YRpgOuSXge1XaLHV2CI8Q..]

          • oracle.dbtools.http.ecid = c5kD76OEp7eFG3OWpgdDdQ..
          • oracle.dbtools.common.di.Services = Request Scope

          --Attributes--

          GET /ords/ HTTP/1.1

          Host: xxx.xxxxxx.com

          host: xxx.xxxxxx.com

          connection: keep-alive

          cache-control: max-age=0

          accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8

          upgrade-insecure-requests: 1

          user-agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.102 Safari/537.36

          accept-encoding: gzip, deflate, sdch

          accept-language: en-GB,en-US;q=0.8,en;q=0.6

          cookie: PSOL_WS_CODE=BUN; ORA_WWV_REMEMBER_UN=ADMIN:INTERNAL; _ga=GA1.2.1684365726.1451626261; treeForm_tree-hi=

          • org.apache.catalina.connector.CoyoteInputStream@27efc9e

           

          What have I missed or done wrong ? ????

          Any help appreciated.

              Two possibilities for getting 404:

          • PL/SQL Gateway for ORDS 3.0 not configured: While configuring ORDS 3.0 have you skipped "PL/SQL Gateway" configuration? ( This step refers to configuring Oracle APEX with ORDS (configuring APEX_PUBLIC_USER) which is required for functioning of Oracle APEX with ORDS) ?

              Else you will run in following error :

           

          • RESTful Services for APEX 5.0 and ORDS 3.0 not configured:
            • Have you Configured RESTful Services while installing Oracle APEX?

              Refer : https://docs.oracle.com/cd/E59726_01/install.50/e39144/listener.htm#HTMIG29335

              Refer : https://docs.oracle.com/cd/E56351_01/doc.30/e56293/install.htm#AELIG7217


              The Configuring Static File Support in the Application Express Installation Guide(using ORDS) says:    The configuration of RESTful Services is required when upgrading to Oracle Application Express release 5.0 and RESTful Services were not configured in a previous release.

             Refer the following threads with same/similar issue :

           

          Regards,

          Kiran

          • 2. Re: ORACLE REST DATA SERVICES 404 Not Found
            PJ62

            Hi Kiran,

             

            Thanks for your suggestions. I did not do the initial install or config of ORDS as pre-installed on DBAAS.  As noted in my description though I did confirm that ORDS was working correctly (with Apex 5) in standalone mode before attempting to deploy it to Glassfish so was assuming that the type of problems that you have raised above were not an issue.

             

            However as I couldn't get it to work and had tried everything else I re-installed and re-configured ORDS and now working OK.  Something in the original install/config of ORDS must have been incompatible with deployment via Glassfish?

             

            All working now.

             

            Regds,

            Phil.