How to Configure APEX & the Embedded PL/SQL Gateway (EPG) in an 11G DB

Applies to:

Oracle Application Express (formerly HTML DB) - Version: 3.0.1 to 3.2
Information in this document applies to any platform.
APEX 3.0.1

Goal

How to Configure APEX & the Embedded PL/SQL Gateway (EPG) in an 11G DB

Solution

The 11g DB (11.1.X) comes with APEX 3.0.1 installed and requires just a few post-install 
configuration steps: 


Accomplish  the following steps to configure the embedded PL/SQL gateway, specify APEX password, and unlock  the ANONYMOUS account. 

1. Change your working directory to $ORACLE_HOME/apex. 
2. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. 
For example: 

ORACLE_HOME/bin/sqlplus /nolog 
CONNECT SYS as SYSDBA 
Enter the SYS password

3. Run apxconf.sql ->  

4. When prompted, enter a password for the Oracle Application Express Admin account. 
Make note of the password you enter, since you will use this password to log in to Oracle 
Application Express Administration Services. 

5. When prompted, enter the port for the Oracle XML DB HTTP server. The default port number is 8080. 

Note: 
Port numbers less than 1024 are reserved for use by privileged processes on many operating systems. 
To enable the XML DB HTTP listener on a port less than 1024, such as 80, review the following 
documentation: 
· Refer to chapter "Using Protocols to Access the Repository" in Oracle XML DB Developer's 
Guide for more information on using HTTP(S) and Oracle XML DB Protocol Server. 
· Refer to chapter "Protocol Address Configuration" in Oracle Database Net Services Reference 
for more information on protocol addressing. 

6. Enter the following statement to unlock the ANONYMOUS account->

 

ALTER USER ANONYMOUS ACCOUNT UNLOCK;

At this time you should be able to log into apex as the admin user from a browser using -> http://machine.domain:port/apex 

The machine is the DB host and the port is the one chosen in step 5.

 
 

If for some reason you can't log in, verify the EPG is up by running the following in your browser ->

http://machine.domain:port

If it's up, you should be prompted for a username and password for XDB.

 

Workspace – internal
Username – Admin
Password – passwd

 

If the EPG is not up, accomplish the following to start it:

1. Log in as SYS as SYSDBA
2.. Run the following statement: 

EXEC DBMS_XDB.SETHTTPPORT(port);

 Where port is the PLSQL Gatway port.

3. COMMIT;

For example: 

EXEC DBMS_XDB.SETHTTPPORT(8080); 
COMMIT;