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.
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?
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?
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. .
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
sysdbapassword
ordspassword
EOF
cant run APEX Application after upgrade from 19.x to 22.1
Althaf, October 20, 2023 - 6:06 am UTC
Hi,
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
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".
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