Post-installation Task for Oracle Application Express 3.0

27 Nov

Oracle Application Express Post-installation task:

Restart Processes(ex. listener, etc.. )
Choose the HTTP Server
Configuring the Embedded PL/SQL Gateway
run apex_epg_config.sql passing the file system path to the base directory where Application Express was unzipped.
if apex_3.0.zip was unzip in C:\oracle\product\10.2.0\db_1\
ex. @apex_epg_config C:\\oracle\\product\\10.2.0\\db_1;
Unlock the ANONYMOUS account
ALTER USER ANONYMOUS ACCOUNT UNLOCK;
Verify Oracle XML DB HTTP Server Port
ex. SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
Enable Oracle XML DB HTTP Port
ex. EXEC DBMS_XDB.SETHTTPPORT(8080);
Disable Oracle XML DB HTTP Server
ex. EXEC DBMS_XDB.SETHTTPPORT(0);

Posted on Tuesday, November 27th, 2007 at 3:10 pm under database, technology .

Categories