The 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 MoreBelow script is for finding the Apex page hits ********************************************************************************************************** /home/oracle/backup/scripts/pagehits.sh . /home/oracle/db.env export SC_LOG=/Backup/pagehits/fms_`date +%d_%b_%H_%M_%Y`.log sqlplus -s <<EOF >>/usr/tmp/tmp1.log connect /as sysdba spool \$SC_LOG select flow_id,step_id,count(*) from FLOWS_030100.WWV_FLOW_ACTIVITY_LOG where…
Read MoreInstallation and Configuration of Oracle Application Express with Oracle REST Data Services and Apache Tomcat Installed Softwares (requirement may vary) Oracle Application Express 5.1.4 Apache Tomcat 7.0.96 Oracle Rest Data Service ORDS…
Read MorePosted by : Saravanan Introduction This Post demonstrates about error ORA-01741 : illegal zero-length identifier Scenario While adding multiple schemas to a single workspace, we get the following error in…
Read MorePosted by Venkateshwaran Govindaraj Introduction: Here we will discuss the error which i Faced in Oracle Apex. ERROR: I USED CORRECT USERNAME AND PASSWORD BUT STILL I FACED LOGIN ERROR SOLUTION:…
Read MorePosted by Sathiyaseelan Mariappan Hi .. Lets find out the solution for below issue. Issue: Fresh apex install failed with the below error. ORA-38824: A CREATE OR REPLACE command may…
Read MoreAPEX INSTALLATION WITH HTTP(OHS) SERVER Description: 1.We have to install first apex in our database after we have to install http(OHS) server: Apex Installation Unzip Apex files in specific PATH.…
Read MoreI’ve faced issue while working with Amazon EC2, I’m starting to appreciate how useful theGlassFish asadmin tool is with a remote system. Here are some steps to get GlassFish set up for…
Read MoreScenario: ======== While adding multiple schemas to a single workspace, we get the following error in Apex version 4.1 which is identified as a Bug in the version and it…
Read MoreIn 11g database the password for the APEX_PUBLIC_USER expires after 180 days. First check if the details of the profile assigned to the APEX_PUBLIC_USER select username,account_status,profile from dba_users where username=’APEX_PUBLIC_USER’…
Read More