Apex 4.1 Installation

Oracle Apex 4.1 Installation with 11gR2

STEP 1:

Install Oracle 11g R2 database:

After successfully installation of Oracle database 11g R2, Apex installed and configured

automatically and that version is 3.0.

Fig: showing the apex folder that created automatically when Oracle 11g R2 installed

successfully .

If version 3.0 is enough to meet the Application development demand then need not to install apex 4.1, but here I assume Apex 4.1 is a must to meet current demand.

So, I am going to install Apex 4.0 in the below steps.

STEP 2:

Apex 4.0 Installation:

Now download Apex 4.1 from

http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

After downloading unzip and keep in the directory as: C:\apex_4.1_en\apex

Now you have to open the command prompt and login as SYS with SYSDBA privilege

As shown in the fig :

Now You need to create a Tablespace as :

SQL > CREATE TABLESPACE APEX_SPACE datafile

    ‘C:\app\noida\oradata\orcl\APEX_SPACE.DBF'

    SIZE 5000M

    EXTENT MANAGEMENT LOCAL

    SEGMENT SPACE MANAGEMENT AUTO;

After successfully created the tablespace now quit from “SQL>” typing Quit as shown in Fig

Now get into the directory on command prompt  C:\apex_4.1_en\apex

So, it will look like :

C:\apex_4.1_en\apex >

Now, login as

C:\apex_4.1_en\apex > sqlplus sys/oracle@orcl as sysdba

Sql >

In below fig , shown the content of apex folder and apexins.sql script need to execute to start

installation of apex 4.1

So , the content within C:\apex_4.1_en\apex is :

To execute apexins.sql script type the below command and mention in which TABLESPACE will be default for apex installation files.

SQL > @apexins APEX_SPACE APEX_SPACE TEMP /i/

Now press enter and the installation will be started.

It will take 30 to 40 minutes to complete the installation.

STEP 3:

LOAD THE NECESSARY IMAGES

After completing the installation then you have to load the necessary images to the database.

And these images located in the following directory:

C:\apex_4.1_en\apex\images

And login again SYS with SYSDBA privilege :

C:\apex_4.1_en\apex > sqlplus sys/oracle@orcl as sysdba

Now you have to execute the apxldimg.sql script to load the images.

SQL > @apxldimg.sql

Now you will be asked to enter the value for 1 :

Simple type below :

C:/apex_4.1_en   ( PLEASE NOTE THAT I HAVE USED ‘/’ INSTEAD OF ‘\’)

And press Enter and the image loading will be started.

Now, again login again SYS with SYSDBA privilege :

C:\apex_4.1_en\apex > sqlplus sys/oracle@orcl as sysdba

Now you have to execute the apxconf.sql script and type the below command

SQL > @apxconf.sql

And press enter…you will be asked to assign a password for admin : type your desired password

And press enter.

Then you will be asked to enter password for XDB HTTP port : type your desired port . here you

can keep 8080 or can change like 7778

And then press enter and your installation in this stage is done.

STEP 4:

UNLOCK SCHEMAS

But you need to unlock few of the schema that is related to Apex application. Now unlock the

schema as :

SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;

SQL > ALTER USER XDB ACCOUNT UNLOCK;

SQL > ALTER USER APEX_040100 ACCOUNT UNLOCK;

SQL> ALTER USER FLOWS_FILES ACCOUNT UNLOCK;

SQL> ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;

“APEX_040100” is an schema which is installed as a result of apex 4.1 installation.

STEP 5:

ENABLE HTTP PORT

Now ,  execute below procedure to enable HTTP port .

sql> EXEC DBMS_XDB.SETHTTPPORT(8080);

PL/SQL procedure successfully completed.

sql> COMMIT;

Commit complete.

Now is the time to open the apex application

Open a brower window and type the url as

http:// < computername>:<Port>/apex

Example: If computer name is DBA-SAGAR and port is 7778 then URL will be like

http://DBA-SAGAR:7778/apex

Provide the required details :

Workspace : internal

Username : admin

Password : oracle

(this is the password which I have given in step 3 after running SQL > @apxconf.sql)

Then you will be prompted to change the password. After changing password return to login

wizard and type your password again and now you are inside the apex home homepage.