Tuesday, August 11, 2015

Step By Step How To Integrate Oracle APEX 5 with Apache Tomcat 7 + APEX Listener 2.0.10

Here are the step by step how to integrate Oracle APEX 5 with Apache Tomcat 7 + APEX Listener 2.0.10 :

1. run command prompt (cmd) then connect to oracle database as sysdba

create tablespace apex
 datafile 'E:\oraclexe\oradata\apex.dbf' --> set as your wish
 size 512m
 autoextend on
 next 64m maxsize 10G
 extent management local;

2. download Oracle Application Express from www.oracle.com then extract file apex_5.0.1_en.zip to e:\oraclexe directory

3. go to apex directory (cd e:\oraclexe\apex) , connect as sysdba

4. @apexins.sql apex apex temp /i/

5. connect as sysdba

6. @apex_epg_config.sql e:\oraclexe
@apex_rest_config.sql --> set password for APEX_LISTENER and APEX_REST_PUBLIC_USER

7. open http://localhost:8081/apex/

8. go to e:\oraclexe\apex\
login as sysdba:
alter user APEX_PUBLIC_USER account unlock;
alter user APEX_PUBLIC_USER identified by Database#1; -->your password min 8 chars
start apxconf.sql
enter admin_name, email and password
XDB HTTP listener [8080] : --> 0

9. download file ords.2.0.10.zip (APEX Listener) , extract to folder e:\oraclexe\apex_listener
rename file ords.war to apex.war

10. Install APEX Listener: (cd e:\oraclexe\apex_listener)
java -jar apex.war
ex :
location for configuration data = e:\oraclexe\apex_listener
hostname: localhost
DB port: 1521
database SID [1] : (ketik 2)
SID[xe]: XE
password [APEX_PUBLIC_USER]: Database#1
3 to skip this step [1]: 3
standalone mode or 2 to exit [1]: 2

11. download apache tomcat 7
install apache tomcat7 to e:\app\tomcat7 folder

12. edit E:\app\tomcat7\conf\server.xml
add to line 126 (under <Host name="localhost"  appBase="webapps" unpackWARs="true" autoDeploy="true">):
<Context docBase="e:\oraclexe\apex/images" path="/i" />

13. copy file e:\oraclexe\apex_listener\apex.war to E:\app\tomcat7\webapps

14. restart apache tomcat

15. browse http://localhost:8080/apex/
Read More

Thursday, April 16, 2015

Step by Step How To Reset Admin Password of INTERNAL Workspace on Oracle APEX

1 comment
Main workspace on Oracle APEX is INTERNAL. It will require username and password to login. The username is ADMIN and the password is the words defined at installation process. In case we forget the password we can restore it by execute apxchpwd script located on specific apex folder. Here is the step by step tutorial how to reset admin password of INTERNAL workspace:

1. Identify the location of apex directory (e.g. c:\oraclexe\apex)
2. Open command prompt (cmd)
3. goto alex directory (cd c:\oraclexe\apex)
4. login to database as sysdba
5. execute "@apxchpwd.sql"
6. type new password (contains 8 characters, at least 1 number and 1 special character)
7. From your web browser, open APEX login page, login to INTERNAL workspace with ADMIN user and your new password
8. Follow the instruction to change password
9. You're Done!

detail explanation can be found here
Read More