Environment: In our case, Apex: 19.2.0.00.18 Tomcat: apache-tomcat-9.0.36 ORDS: 19.1 Error: Developer reported Dashboard images and themes are not loading for one of the Application developed using Oracle Apex. When…
Read MoreHow to access HTTPS/SSL URL via utl_http using the orapki wallet command Goal: Our goal is to call/access the HTTPS/SSL url from within PL/SQL The instruction provided here should also work for accessing…
Read MoreInstall and Configure Oracle APEX with ORDS and Apache Tomcat Introduction: In this post, we will discuss about the step by step procedure to install Oracle Application express 19.2 with…
Read MoreError: ORA-28040: No matching authentication protocol Cause: 1. This problem was encountered on database instance version 12.2 and above and clients with version 9g/10g/11g. Example: In my case the development…
Read MoreQuery to identify applications/workspace information of your Oracle apex Application COLUMN workspace FORMAT A20 COLUMN workspace_id FORMAT 99999999999999999999 COLUMN application_id FORMAT A14 COLUMN application_name FORMAT A20 — List applications. SELECT…
Read MoreThe default log files and logging levels are defined in logging.properties file under the below location /home/oracle/tomcat_09_Aug_2020/apache-tomcat-9.0.36/conf. The list is arranged in order by level of detail from the least…
Read MoreImpact: Unknown underscore parameters without proper advice from metalink, would impact the database. Solution: We need to ensure that we have proper advises from Oracle Support on those underscore parameters…
Read MoreIntroduction Need for want of lock statistics in a oracle table in some cases, for example 1. Don’t want a table to be analyzed by schedule statistics job but want…
Read MoreError: FRM-30087: Unable to create form file $ORACLE_HOME/forms/WOENTRY.fmx Cause: Non-oracle user cannot write in the “output” directory or the mentioned fmx exists but user cannot overwrite it. Workaround: 1. By…
Read MoreError: error while loading shared libraries: libXm.so.3: cannot open shared object file: No such file or directory Solution: 1. As a workaround, make sure the following 64 bits openmotif packages…
Read More