Before installing, check this requirement documentation according to your environment.
Note that, if your Apex version is lower than 3.1, make shared_pool_size 100M
Steps in installing Oracle Application Express 3.2:
- Download apex zip file
- Unzip
- Copy extracted directory “apex” to $ORACLE_HOME\
ex. $ORACLE_HOME or C:\\oracle\\product\\10.2.0\\db_1\\ - Change working directory to apex (on cmd)
ex. cd C:\\oracle\\product\\10.2.0\\db_1\\apex - start sqlplus and connect as SYS
ex. sqlplus sys/ as sysdba - run apexins.sql with the following arguments
- tablespace_apex – tablespace to be used by Application Express (ex. SYSAUX)
- tablespace_files – file tablespace to be used by Application Express (ex. SYSAUX)
- tablespace_temp – temporary table space to be used by Application Express (ex. TEMP)
- images – the images folder for Application Express (ex./i/)
ex. @apexins SYSAUX SYSAUX TEMP /i/ - Load Images & JS: @apexldimg c:\oracle <apex location>
- To Change Admin PWD: @apxchpwd
- Shutdown immediate & Startup force
- Enjoy your Application Express 3.2!
If you have any troubles, get the documentation; Oracle Application Express Installation Guide
Good luck.
