Install or upgrade Oracle APEX 5.0.3 for ORACLE DATABASE 12C on Linux

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

http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

or

https://drive.google.com/open?id=0B7a3DEnQ0-uzMVFwVnRFZkRfYlk

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 [oracle@VTGDB.COM ~]$sqlplus / as sysdba 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:

Share this

Vtgdb