Mostly Making oracle easy, mostly:
Search for:

Ask A Question

Nearly 7,000,000 Oracle professionals use SQL Developer on a regular basis. Have a question about Oracle SQL Developer? Searched this blog and couldn’t find the answer? Ask away!

If your question is about Oracle Database, SQL, PL/SQL, etc – go Ask Tom!

Feel free to ask anything you want, but I’ll feel free to send you to Support or our Forums if it goes sideways.

Note: This page has turned out way more successful(?) than I would have ever imagined. Please keep these things in mind when asking questions.

  1. I am NOT support. Don’t expect me to log bugs for you, or give you official timelines on bug fixes, enhancements, or product releases.
  2. I AM NOT SUPPORT. Don’t open an SR with My Oracle Support AND leave a question here. Pick one and go with it, and when in doubt, go to My Oracle Support.
  3. I try to answer questions as quickly as possible. If you don’t get an answer, ask me for an update. I may have just forgotten or overlooked your request.

Go!

8,146 Comments

  1. Jack Wells Reply

    Hi Jeff,

    TL;DR
    I’m trying to run a new “Customer Managed” ORDS installation on an OL8 Compute VM in OCI that hosts my vanity domain and works with APEX included in the free ADP-S database offering, but am getting a 404 when trying to login to APEX for the first time. I think it is caused by misconfigured APEX Static Images (“/i”) settings, so how to I confirm my configuration is correct for either the CDN approach, or the locally copied images approach for serving up these APEX Static images?

    Background:
    I am installing the latest version of ORDS, v25.4.0.r3641739, and am running it in standalone mode (i.e. “ords serve”). Pretty much I’m following the steps in Timo Herwix’s excellent article verbatim, here:
    https://tm-apex.hashnode.dev/how-to-set-up-custom-urls-for-oracle-autonomous-database-with-customer-managed-ords-243-and-lets-encrypt

    The installation went smoothly and I was able to get to the ORDS landing page successfully the first time I tried, on my vanity domain, and in https mode on port 443. Running the SQL Developer “Go” button from their works fine as well.

    However, when I try the APEX “Go” button I land on this error page:

    Not Found
    HTTP Status Code: 404
    Request ID: YY6KDtuzv2i2586dhYkg8A
    Request Timestamp: 2026-02-24T05:05:39.469567189Z

    The URL on this error page is:

    https://www.myvanitysite.com/ords/_sso/redirect?action=login& r=https%3A%2F%2Fwww.myvanitysite.com%2Fords%2Fapex_authentication.callback%3Fp_session_id%3D309241774087621%26
    p_app_id%3D4050%26
    p_ajax_identifier%3DQ…48g%26
    p_page_id%3D3

    My research so far makes me think I don’t have the APEX IMAGE_PREFIX settings configured correctly, but I’ve tried both the “CDN” and the “Copy Images” approaches documented here and not having any luck:
    https://docs.oracle.com/en/database/oracle/apex/24.2/htmig/configuring-ords.html#GUID-D688F4D6-FCAB-4C4D-BA6D-9A3506B3E05F

    I prefer the CDN approach so before I keep poking at it, can you confirm that a “Customer Managed” ORDS installation for ADB (“ords install adb …”) for the purpose of using the managed installation of APEX in ADB does indeed work with the Static Resources CDN? If so, what should be the value for the standalone.static.path setting in my ORDS installation? How does the value in that parameter tie to the value of the ‘IMAGE_PREFIX’ parameter in the APEX_INSTANCE_PARAMETERS table in the ADB database?

    I guess in short, what are the exact steps to make a “Customer Managed” ORDS installation for APEX on ADB use:
    1) the Static Resource CDN
    -or-
    2) the Images copied locally to the ORDS server

    Thanks!
    Jack

  2. Eirik B Reply

    I’m not able to find this answer anywhere. In SQLcl there is a command called INFO (INFORMATION)
    I’m trying this command on an object in a different schema which I have access to. But the info command tells med the object does not exist.
    One would think the DDL command uses the same privileges as that command works fine on any object.
    But INFO just gives be the error the object does not exist
    DDL differentuser.tabobject OK
    INFO differentuser.tabobject Doest not work.

    The object is present in all_objects

    Just can’t figure out why….

    • thatjeffsmith Post Author

      I’m guessing this is for a specific object, not for ‘all’ objects outside your schema.

      In SQL Developer, run the command as a script, and observe the Log, Statements panel. You’ll see all the SQL we run, including that to resolve the object name.

      Here’s the first thing we run –


      begin
      dbms_utility.name_resolve(
      name => :name,
      context => :ctx,
      schema => :schema,
      part1 => :part1,
      part2 => :part2,
      dblink => :dblink,
      part1_type => :part1_type,
      object_number => :num
      );
      end;

    • Eirik B

      Thanks, realized why.

      My schema MAIN, has a table (SPECS) with the same name as the next schema (SPECS)

      DDL function handles this fine, but the INFO function does not because dbms_utility.name_resolve gets it wrong

      And no, I did not design this database. But I have to work in it.

    • thatjeffsmith Post Author

      if the NAME_RESOLVE function is failing, that sounds like a database bug. What version of the db are you connected to?

Write A Comment