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
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.
