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

Step1)

To Configure the embedded PL/SQL gateway go to the

$ORACLE_HOME/apex directory

>echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0.2/db_1

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

./sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 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 11.2.0.2.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> @apxconf

PORT
———-
8080

Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.
Default values are in brackets [ oracle11]. Apex_11G
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.

http://78.2.1.36:8080/apex

workspace : internal

User : admin

password : you entered when you configured apex.

About these ads