Step 1: Create tablespace
create tablespace apex datafile '/u01/app/oracle/oradata/PTUD/datafile/apex.dbf' size 100M autoextend on next 10M; |
Step 2: Download Oracle Apex 5.0.3.00.03 from Oracle or My Google Drive
or
Step 3: extract file apex_5.0.3_en.zip to directory: /u01/setup
[oracle@VTGDB.COM ~]$cd /u01/setup
[oracle@VTGDB.COM setup]$unzip apex_5.0.3_en.zip
[oracle@VTGDB.COM setup]$ ls
apex apex_5.0.3_en.zip
Step 4: Go to the apex directory ( /u01/setup/apex), connect sys as sysdba then run sql scripts:
[oracle@VTGDB.COM ~]$cd /u01/setup/apex
SQL > @apexins.sql apex apex temp /i/ |
Step 5: Run script apex_epg_config.sql /u01/setup
[oracle@VTGDB.COM ~]$cd /u01/setup/apex [oracle@VTGDB.COM apex]$sqlplus / as sysdba SQL > @apex_epg_config.sql /u01/setup |
Step 6: Unlock user account oracle
[oracle@VTGDB.COM apex]$sqlplus / as sysdba SQL > alter user APEX_PUBLIC_USER account unlock; SQL > alter user APEX_050000 account unlock; SQL > alter user ANONYMOUS account unlock; |
Step 7: Verifying Oracle XML DB HTTP Port and set it to 8080
[oracle@VTGDB.COM apex]$sqlplus / as sysdba SQL> SELECT DBMS_XDB.gethttpport FROM DUAL; GETHTTPPORT ----------- 0 SQL> EXEC DBMS_XDB.sethttpport(8080); PL/SQL procedure successfully completed. |
Step 8: Configure Apex application
[oracle@VTGDB.COM apex]$ sqlplus / as sysdba SQL> @apxconf.sql PORT ---------- 8080 Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user. Default values are in brackets [ ]. Press Enter to accept the default value. ================================================================================ This script can be used to change the password of an Application Express instance administrator. If the user does not yet exist, a user record will be created. ================================================================================ Enter the administrator's username [ADMIN] User "ADMIN" exists. Enter ADMIN's email [ADMIN] Enter ADMIN's password [] Changed password of instance administrator ADMIN. Enter a port for the XDB HTTP listener [ 8080] ...changing HTTP Port SQL> |
Step 9: Access your Apex application web:
http://YOUR_HOST:8080/apex
workspace: internal
username: ADMIN ( uppercase)
pass: YOUR_PASS
After you login successfully, you have your interface following:
0 komentar:
Post a Comment