My Oracle Support Banner

DBCS OCI-C 404 Error trying to access APEX on PDB1 (Doc ID 2512651.1)

Last updated on FEBRUARY 18, 2021

Applies to:

Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

ERROR 404 Error when accessing APEX

Unable to access APEX  the accounts:
- ORDS_PUBLIC_USER',
- 'APEX_LISTENER',
- 'APEX_PUBLIC_USER',
- 'APEX_REST_PUBLIC_U
were expired and unexpired them but the 404 error continues.

Tried Re-starting ORDS and it fails

$ /etc/init.d/ords restart

it fails with error:
ERROR: Oracle REST Data Services process ended unexpectedly
ERROR: There was an error starting ORDS. Please check the log under "/u01/app/oracle/product/ords/log/ords.log"              -- But the log has nothing

=============================================================================================
Ran the following steps:

a. cd /var/opt/oracle/ocde/assistants/ords
b. Run the following: ./ords –ords_action=verify
c. This will create a log in /var/opt/oracle/log/ords/ords.log

Ords log shows:

====================================
INFO: "ORDS RPM" verification exited with code: 1
<date/time> - ERROR: An error occurred during "ORDS RPM" verification
 at ./ords line 8549
main::verify_rpm('dbtools_ords_standalone-18.1.0.11.22.15-1.el6.x86_64', 'ORDS RPM', 1, 0, 1) called at ./ords line 8576
main::verify_ords() called at ./ords line 8670
main::verify() called at ./ords line 502
<date/time> - INFO: Starting ORDS RPM verification...
<date/time> - INFO: Verifying "dbtools_ords_standalone-18.1.0.11.22.15-1.el6" installation...
ERROR: ORDS standalone configuration file "/u01/app/oracle/product/ords/conf/ords/standalone/standalone.properties" does not exist or is not readable by the oracle user
error: %verify(dbtools_ords_standalone-10:18.1.0.11.22.15-1.el6.x86_64) scriptlet failed, exit status 1
<date/time> - INFO: "ORDS RPM" verification exited with code: 1
<date/time> - ERROR: "ORDS RPM" files were either missing or modified

====================================
<date/time> - INFO: "DBaaS Landing Page RPM" verification exited with code: 1
<date/time> - ERROR: An error occurred during "DBaaS Landing Page RPM" verification
 at ./ords line 8549
=============================================================================

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.