Oracle APEX Installation and Unistallation

Here provide a step by step guideline for Oracle APEX Installation ...

This installation guideline created by MR. Noor Alam. I will give a thanks to Mr.Noor Alam for Oracel APEX Installation guideline.

Installation:

1. Create a table Space (Exam: apexts) to your database from TOAD. (Size 2 GB and Auto Increment 10 MB)
2. Copy Apex folder in hard disk drive where will install (Example: Location: D:/apex)
3. Open Command Prompt.
4. Insert the apex folder(Example-  d:  --press enter, cd apex    --press enter)
5. sqlplus   /nolog  --press enter (To connect SQL)
6. conn sys@xe (DB name) as sysdba  --press enter (To connect SYS user as a DBA)
7. Press enter when passward require/enter sys user’s password.
8. @apexins.sql   apexts  apexts  temp /i/  --press enter. (It’s main command for apex installation.)

It takes 30-40 minutes and will be disconnect. Need to connect again.

1. Open Command Prompt.
2. Go to the apex folder(Example-  d:  --press enter, cd apex    --press enter sqlplus  /nolog  --press enter
3. conn sys@xe as sysdba  --press enter
4. Press enter when passward require/enter sys user’s password.@apxldimg.sql       --Press Enter. It’s for loading image. 
5. Enter value for 1: D: (where apex folder copied) --Press Enter
6. @apxconf.sql  --press enter
7. To set apex Admin Password & default Port Number (8080) as following…
8. Password for Admin user in apex: Set a Complex Password (Exam: Noor$4) –Press Enter                listennr:       --Press Enter
9. Unlock some users which are related to apex (anonymous, apex_030200, apex_040100, apex_public_user).

**Connect without DB name

---conn sys/ as sysdba

Reset Password in Apex Developer Users:  

1.  If one forget Admin user password of Internal Workspace, do the following to reset password
2. Open Command Prompt.
3. Insert the apex folder(Example-  d:  --press enter,cd apex    --press enter)
4. sqlplus   /nolog  --press enter (To connect SQL)
5. conn sys@xe (DB name) as sysdba  --press enter (To connect SYS user as a DBA)
6. Press enter when password require/enter sys user’s password.
7. @ apxchpwd.sql  --press enter (To reset password for Admin user of Internal Workspace)
8. Enter password for Admin User of Internal Workspace  --Press Enter

After login Internal Workspace by Admin user one can change password of all workspace users. After login a specific workspace by that’s workspace admin user one can change the admin user and other users of that workspace but can’t change password of others workspace users. 

Un installation: 

1. Open Command Prompt.
2. Go to the apex folder where it installed (Example-  d:  --press enter, cd apex    --press enter)
3. >sqlplus   /nolog  --press enter
4. conn sys@xe (DB name) as sysdba  --press enter
5. @apxremov.sql   --press enter (This command will uninstall apex) 
6. Remove the folder from the drive after completed the process. 
   

Browse Apex from Your PC:

1. Open a browser (firefox/Explorer etc)
2. Write the URL: http://pc_name/IP:port_number/apex (Exam:http://noor-pc:8080/apex)

cheers !!!