Home > oracle-install > Steps to Configure oracle apex in 11g

Steps to Configure oracle apex in 11g

Here are the steps to configure oracle apex in 11gR2.

APEX application can access either the embedded PL/SQL gateway or Oracle HTTP server.By using the embedded PL/SQL gateway, it will run using the Oracle XML DB HTTP server


To Configure the embedded PL/SQL gateway go to the $ORACLE_HOME/apex directory

*dbsl0001*<oracle:ora11gR2>:/u01/app/oracle/product/>echo $ORACLE_HOME

now connect to the database using sqlplus from the database machine.

*dbsl0001*<oracle:ora11gr21>:/u01/app/oracle/product/>./sqlplus / as sysdba

SQL*Plus: Release Production on Sat Jun 4 21:24:53 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> @apxconf


Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.
Default values are in brackets [ ].
Press Enter to accept the default value.

Enter a password for the ADMIN user              []
Enter a port for the XDB HTTP listener [      8080]
…changing HTTP Port

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Session altered.

…changing password for ADMIN

PL/SQL procedure successfully completed.

Commit complete.

SQL> alter user anonymous account unlock;

User altered.

Enable Oracle XML DB HTTP server:

SQL> exec dbms_xdb.sethttpport(8080);

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

now we can access oracle apex by using following link.


workspace : internal

User : admin

password : you entered when you configured apex.

Categories: oracle-install
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: