3 Replies Latest reply on Mar 12, 2020 12:26 PM by EJ-Egyed

    Newbie questions regarding ORDS

    TheLonelyDBA
    TheLonelyDBA Mar 11, 2020 6:59 AM

      Hi,

       

      I have installed APEX 19.2 (works) and now ORDS 19.4, I followed this document (Oracle 19c as db, running in a weblogic cluster, three nodes):

       

      https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/19.4/aelig/installing-REST-data-services.html#GUID-… https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/19.4/aelig/installing-REST-data-services.html#GUID-18C6F9AC-F6DF-45D9-9AE4-6668DF563466

       

      Installation went fine and I have installed the application in WLS, but when trying to access statis images I get:

       

      404 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

       

      How to take this further?

       

      1. How do I enable tracing and restart the APEX listener?

      2. Do I need to do more things than what was included in the document?

      3. The document refres to the images as "java -jar ords.war static <apex directory>/images"

      I used /shared/apex_images/images

      There are images both in /shared/apex_images/ and /shared/apex_images/images.

      How to tell which one to use?

       

      Regards

      TheLonelyDBA

      • 173 Views
      • Tags:
        • 1. Re: Newbie questions regarding ORDS
          Peter de Vaal
          Peter de Vaal Mar 11, 2020 1:05 PM (in response to TheLonelyDBA)

          The apex images are in the images directory of the apex installation. You can copy these to /shared/apex_images if you like.

          The configuration of the images directory just links the URL /i/ to that directory, so if you request http://<your server>:<weblogic port>/i/<some image name.jpg> you would get the image in the browser. It will not go through ORDS because the URL does not contain /ords/.

           

          What happens if you start apex (http://<server>:<port>/ords/apex) ? Do you get the apex login page without the images?

          • 2. Re: Newbie questions regarding ORDS
            TheLonelyDBA
            TheLonelyDBA Mar 12, 2020 8:17 AM (in response to Peter de Vaal)

            Hi,

             

            I get nothing when going towards (url not found)

             

            (http://<server>:<port>/ords/apex)

             

            but (http://<server>:<port>/ords/)  works fine and I get the images.

             

            I can access the images using /i/. I have an consultant the will test this, I will proberbly comeback with more questions...

             

            Regards

            TheLonelyDBA

             

             

            • 3. Re: Newbie questions regarding ORDS
              EJ-Egyed
              EJ-Egyed Mar 12, 2020 12:26 PM (in response to TheLonelyDBA)

              Perhaps the image prefix of your APEX installation is not /i/

               

              You can check it with this code:

               

              begin
  dbms_output.put_line(APEX_APPLICATION_GLOBAL.g_image_prefix);
end;

               

              You can either change your image prefix to /i/ if it is not /i/ using the script utilities/reset_image_prefix.sql within the APEX installation directory or you can change the directory structure on your web server to match the image prefix.