Skip to Main Content
  • Questions
  • After Installation/Upgradation ORDS 22.2 unable to run apex


Question and Answer

Connor McDonald

Thanks for the question, Daxesh.

Asked: June 30, 2022 - 6:14 pm UTC

Last updated: November 28, 2023 - 2:27 am UTC

Version: 22.1.1

Viewed 10K+ times! This question is

You Asked

1) Platform and Oracle version i tried.
OS platform Windows 10 & windows 11
Oracle version : Oracle 18CXE , Oracle 21c XE, Oracle 12c (on Oracle Linux 7)
ORDS 22.2

2) I tried it on oracle 18cXE and ords 21.4 to upgrade ords 22.2 but after installation and configuration I got message and i am unable to run apex message is :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

3) than i tried on Oracle 12c on linux and tried it but same message i got.

4) when i tried on standalone mode than it working nicely but when i deploy on web server i got said message and unable to run it.

5) Finally i had done fresh installation of Oracle Database 21CXE, Apex 22.1, Tomcat 9 and Ords 22.2 but same message i got. i can't find where i have done mistake or what is the procedure. i refered google, side document and many more even i refered,and%20update%20the%20password%20field

but i am unable to solve my problem.

6) action i have done is recorded and can refer using

can you guide me please?

and Connor said...

OK, the installation process is totally different for 22 so I suggest you read the docs carefully. In particular

You don't do anything with ords.war anymore.

- You do NOT launch it with "java -jar ords.war"
- You do NOT rename it to get a different database path

For standalone, you launch it with:

ords --config /my/path/to/config/dir serve

And for Tomcat, you need to let Tomcat know where the config file is, so you'd do something like:

export JAVA_OPTS="-Dconfig.url=/my/path/to/config/dir"

before starting your webserver.

Attempting the v21 style of usage will not work (as you've discovered)

Some nice walkthroughs here:


  (6 ratings)

Is this answer out of date? If it is, please let us know via a Comment


it working but sql-developer not working

DAXESH LAIWALA, July 07, 2022 - 10:12 am UTC

Thanks for reply its working but sql developer not working it giving error
An error occured
Please clear your browser's temporary files and try again.

i tried clear browser cache even i try other than chrome browser but sql developer not working after login.
Connor McDonald
July 08, 2022 - 12:24 am UTC

not sure how this relates to ORDS

Where to specify APEX_PUBLIC_USER if at all?

Rene, August 11, 2022 - 6:59 am UTC

I'm still a bit confused by this new ORDS 22.2. Is there a need to specify passwords for APEX_PUBLIC_USER, APEX_LISTENER and APEX_REST_PUBLIC_USER?
If so, where in the process does this take place?

Connor McDonald
August 12, 2022 - 2:16 am UTC

You'll see a couple of parameters in the installation

--gateway-mode proxied
--gateway-user APEX_PUBLIC_USER

This lets us *proxy* from the ords user to the apex user when needed

ORDS installation from our own script.

Rene, August 24, 2022 - 10:43 am UTC

We run a script that installs Apex and our application schemas. Is there a way I can add the installation of the required ORDS objects to be able to run our Apex application. Meaning the things that get installed when I run:
ords.exe install ....

As fas as I can tell that is currently ORDS_METADATA schema and ORDS_PUBLIC_USER schema.

Also, what is the minimum required install for ORDS just to be able to run our APEX application?

Chris Saxon
August 24, 2022 - 1:19 pm UTC

You can run ORDS stand-alone.

Have you checked the links Connor provided in the original answer? What exactly are you struggling with?

Rene, August 25, 2022 - 5:40 am UTC

I'm looking for an alternative way to create the database objects that are created by running "ords.exe install ...". I don't want another point in the installation process that requires installing things in the database. .
Connor McDonald
August 26, 2022 - 5:34 am UTC

I don't want another point in the installation process that requires installing things in the database. .

Not sure what you mean by that? If you want ORDS, you to install ORDS.

ORDS can be installed non-interactively via single command line, eg

ords --config /u01/mydir install --log-folder /ords/logs --admin-user SYS --db-hostname myhost --db-port 8080 --db-servicename mypdb --feature-rest-enabled-sql true  --gateway-mode proxied --gateway-user APEX_PUBLIC_USER --proxy-user --password-stdin <<EOF

cant run APEX Application after upgrade from 19.x to 22.1

Althaf, October 20, 2023 - 6:06 am UTC


I have upgraded oracle apex19 to apex22.1 in onpremis 12c database. after upgradation i have create a application inside the new APEX but after that i cant run that. its shows a plane webpage contain "Forbidden
The requested operation is not allowed" as 403 Forbidden
Connor McDonald
October 22, 2023 - 11:27 pm UTC

403 Forbidden sounds more like an ORDS issue.

Try this

$JAVA_HOME/bin/java -jar ords.war validate

(depends on your version of ORDS)

Error in PLSQL code raised during plug-in processing. Contact your application administrator.

Althaf, November 09, 2023 - 11:44 am UTC

When opening the SQL Commands or SQL Scripts in a workspace, shows "Error in PLSQL code raised during plug-in processing. Contact your application administrator".

Connor McDonald
November 28, 2023 - 2:27 am UTC

Check MOS note 2881783.1

If that is not the exact cause, it will guide you through dealing with ords_admin.add_plsql_gateway_procedure

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library