404 not found error, the request could not be mapped to any database while running newly developed application in Apex.

Issue : While running the newly developed application in Apex, I encountered a 404 Not Found error. The request could not be mapped to any database.

Reason : In catalina.out we could notice the following error, it indicated that ords is corrupted.

WARNING: ORA-04063: view “ORDS_METADATA.UNIFIED_POOL_CONFIG” has errors

java.sql.SQLException: ORA-04063: view “ORDS_METADATA.UNIFIED_POOL_CONFIG” has errors

Solution : Re-configure the ords.

Source the environment file and then down the tomcat

Go the ords location to uninstall ords

Command : /u01/apexdbnew/jdk-17.0.1/bin/java -jar apex.war uninstall

Then remove the ords directory completely.

Then download the ords software and unzip it in ords directory.

After unzipping the ords software create conf directory under ords directory

Then go to the params directory and add the required entries in the ords_params.properties file.

Copy the ords.war file in other name and then move the ords.war file to apex.war file.

Then configure ords in the newly created conf directory

Then install the ords using the below command :

/u01/apexdbnew/jdk-17.0.1/bin/java -jar apex.war configdir /u01/apexdbnew/ords/conf

Then from ords directory go to conf/apex/conf and then add the highlighted three entries in the apex.xml file.

Then in the $CATALINA_HOME/webapps location move the existing apex.war file to some other name.

And then copy the apex.war file from the newly installed ords configuration to $CATALINA_HOME/webapps after sourcing the tomcat env .

Connect to the database to unlock the following accounts

alter user APEX_LISTENER identified by Doyen#321 account unlock;

alter user APEX_PUBLIC_USER identified by Doyen#321 account unlock;

alter user APEX_REST_PUBLIC_USER identified by Doyen#321 account unlock;

Then start the tomcat

Now the application is working fine in the apex workspace.