select WORKSPACE,APEX_USER,PAGE_NAME, trunc(VIEW_DATE) “Date”, VIEW_DATE from APEX_040100.APEX_WORKSPACE_ACTIVITY_LOG Where workspace in (‘DOYEN’) AND trunc(view_date) = trunc(sysdate-1) –and TRUNC(view_date) BETWEEN :From_date AND :TO_DATE and page_name not in (‘Page 1′,’zero’,’Oracle Application Express’,’Login’,’Application Builder’)…
Read MoreDownload the Apex 3.1 and move to /home/oracle dir Now unzip the file . login to database and execute the following commands. $sqlplus / as sysdba sql> show parameter…
Read MoreSoftware Requirement: 1.JDK 1.6 or Higher (Download it from http://www.oracle.com/technetwork/java/javase/downloads /jdk7-downloads-1880260.html ) 2.apex_listener.1.1.4.195.00.12.zip (Download it from http://www.oracle.com/technetwork/developer-tools/apex-listener/downloads/index.html) 3.ogs-3.1.2.2-web-unix-ml.sh (Glassfish) (Download it from http://www.oracle.com/technetwork/java/javaee/downloads/java-ee-sdk-6u3-jdk-6u26-downloads-439816.html) Installation StepsInstall JDK RPM on Server: …
Read More1) Check java version after completion of glassfish installation . /java -version 2) Go to location /oracle/glassfishv3/jdk/bin and Run ./java -jar /oracle/apex/apex.war, (where /oracle/apex/ is the location of apex listener…
Read More1. Download the Glassfish http://www.oracle.com/technetwork/java/javaee/downloads/java-ee-sdk-6u3-jdk-6u26-downloads-439816.html Example File name : java_ee_sdk-6u1-jdk-solaris-sparc.sh 2. Download the Apex listener : apex_listener.1.1.2 http://www.oracle.com/technetwork/developer-tools/apex-listener/downloads/index.html 3) Reset the password for APEX_040000 and apex_public_user i. Unlock the Apex…
Read More