Oracle Apex installation on Windows

Before apex installation you should have oracle installed in your machine.(10g above)

download the Apex and unzip it in drive C:\. Then you will get a folder called apex. (C:\apex)

now set path to the apex folder

Then type below

set ORACLE_HOME=c:\oraclexe\app\oracle\product\10.2.0\server
set ORACLE_SID=XE
set PATH=%ORACLE_HOME%\bin;%PATH%


now loging to sqlplus as sysdba
>sqlplus / as sysdba

now type below sql commands

SQL>@apexins SYSAUX SYSAUX TEMP /i/


after installation log into sqlplus as sysdba
issue below

SQL>@apxldimg c:\ in my case it was C:\ not C:\apex XXXX


exit and relogin as sysdba and issue below to change password

SQL>@apxxepwd.sql


username ADMIN
password XXXXXX


######This is the end of installation #######

run below to access application from client machine

login as sysdba

sql> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);