Skip to main content

Posts

Showing posts from 2010

Configure Oracle APEX 3.2.1 using Embedded PL/SQL Gateway (Unsupported Feature)

Just want to share for those who don't want to setup APEX using Apache HTTP Server with mod_plsql (which will be deprecated according to latest SOD Oracle), instead using pre installed Embedded PL/SQL Gateway on top of XML DB Server feature of Oracle Database, but doesn't have the luxury of newest version of Oracle Database (as latest is 11g). Installation step should be followed normally as documented in installation guide. After APEX component installation complete (no error occured during installation) using SQL/Plus Command: SQL> @apexins SYSAUX SYSAUX TEMP /i/ *) SYSAUX should be replace by another target tablespace created earlier (recommended) For normal installation it should move to point 3.3.5 Configure the Embedded PL/SQL Gateway but after several times installation experience this always causing error 404 Unauthorized . I began to examine the instalation script, and found out that there's missing step in creation/configure of DAD (Database Access Descriptor