No great genius has ever existed without some touch of madness.

Monday, 21 May 2012

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

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.



22 comments:

  1. Excellent!!!

    Thank You

    ReplyDelete
  2. hi sagar,
    my database oracle 10g and apex 4.1. i follow ur step but
    when i browse then http 404 not found.Pls help me

    ReplyDelete
  3. Check your default port and then reconsider step5

    ReplyDelete
  4. You can also use below commands for the same :

    sql> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

    sql> !lsnrctl status | grep

    ReplyDelete
  5. thnks for ur reply.
    first time when i browse then xdb username/password window
    then i give xdb username-xdb,password-admin password
    then error show http 404 not found.

    default port 8080 show.
    i follow all step.

    ReplyDelete
  6. xdb,anonymous,apex_public_user account unlock

    ReplyDelete
  7. thanks a lot... very helpful and to-the-point

    ReplyDelete
  8. Excellent document

    Thank You

    ReplyDelete
    Replies
    1. Sagar,

      please let me know how to install apex4.2 with 11g http server.

      Thanks in advance.

      Delete
    2. Follow the same steps except step 4,there u will have to unlock another user account.

      Delete
  9. Thank you for your excellent document.

    I followed your every step and all steps worked fine except step 4's "ALTER USER APEX_040100 ACCOUNT UNLOCK;" this command. I installed oracle 11g and apex 4.2.1 and . After completing every step whenever i browse with http://127.0.0.1:8080/apex/ i got a blank white page with browser title "Application Express Login". What is the problem with this? Please help me regarding this issue.

    ReplyDelete
  10. Ur user will not be APEX_040100,as u installed apex 4.2.1 so u may have to unlock the account of user APEX_04020....,to make it easier check users into dba_users and if u installed it properly, u will get an user in the above format only.

    ReplyDelete
  11. After install apex 4.2.1 installation is completed successfully.But not able to open url page of apex link.
    please kindly help in this issue..

    ReplyDelete
  12. Excellent. Step by Step document Worked like charm !

    ReplyDelete
  13. if I want to install for the first time, what al ports I need to keep open on my server so that i can use apex? I can understand about 8080 default port, but do we need some more?

    ReplyDelete
  14. please i follow your instruction but the apxconf.sql didn't work i couldn't enter password and when i press enter give me this message please help "oracle official site blocked in our country so any solution dosen't envolve ask them" and thank you sooooooooo much

    ReplyDelete
  15. Sagar,

    posted installation steps are really very good.

    thnks very much

    ReplyDelete
  16. thank u soo much sagar verma.....
    Fantastic Explanation......
    u know any website which have tutorials about Apex ??????

    ReplyDelete
  17. Thanks a bunch for your instructions. I was able to get the web page working after reading these instructions. So many instructions are written, but only a few are useful.

    ReplyDelete
  18. omg, u really save my day, no save my life, after I upgrade the APEX my APEX login page become blank, it was written in guide that I should type this @apxldimg.sql APEX_HOME but after seeing ur post it didn't
    when I just try @apxldimg.sql, it worked like magic <3

    Regards,
    Fahri Alfan.

    ReplyDelete