How to install oracle apex?

We are Providing Each and Every Point Step by Step on How to Install oracle Apex. 

To install Oracle Application Express:
1. For installations where the event are going to be in English only, download the file apex_5.1_en.zip from the Oracle Application Express download page. If the event will include languages aside from English, download apex_5.1.zip from the Oracle Application Express download page. See:http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

2. Note that the particular file name may differ if a newer release has shipped since this document was published.

3. Unzip downloaded zip file:
• unzip apex_5.1_en.zip as follows, preserving directory names:
• UNIX and Linux: $ unzip apex_5.1_en.zip
• Windows: click on the file apex_5.1_en.zip in Windows Explorer
• If it has multiple language, unzip apex_5.1.zip as follows, preserving directory names:
• UNIX and Linux: $ unzip apex_5.1.zip
• click the file apex_5.1.zip in Windows Explorer

4. Note: you ought to keep the directory tree where you unzip the files short and not under directories that contain spaces. for instance , within Windows unzip to C:\TEMP.

5. Change your working directory to apex.

6. Start the SQL Plus and combine with the database where Oracle Application is installed as SYS specifying the SYSDBA role. For example:
• On Windows: SYSTEM_DRIVE:\ sqlplus /nolog
• SQL> CONNECT SYS as SYSDBA
• Enter password: SYS_password

7. • On UNIX and Linux: $ sqlplus /nolog
• SQL> CONNECT SYS as SYSDBA
• Enter password: SYS_password

8. Disable any existing password complexity rules for the default profile. You can also check the “Configuring Password Protection” clearly in the Oracle Database Security Guide.

9. Select the acceptable installation option.Full development environment provides complete access to the App Builder environment to develop applications. A Runtime environment enables users to run applications that can’t be modified. Available installation options include:
• Full development environment. Run apexins.sql within the order shown: @apexins.sql
• Where:
• Oracle Application Express application is named astablespace_apex is the name for the user.
• tablespace_files is that the name for the Oracle Application Express files user.
• tablespace_temp is that the name of the temporary tablespace or tablespace group.
• For installations using EPG, /i/ is that the required value for the pictures argument. To support future Oracle Application Express upgrades, define the reflection directory as /i/.
• Example: @apexins.sql SYSAUX SYSAUX TEMP /i/
• Note: If you receive the subsequent error, exit SQL*Plus and alter your working directory to where you unzipped the installation file, for instance C:\TEMP in Windows, before starting SQL*Plus: SP2-0310: unable to open file “apexins.sql”
• Runtime environment. You are Suppoed to run in the Given Order [ apxrtins.sql ] by passing the subsequent arguments : @apxrtins.sql tablespace_apex tablespace_files tablespace_temp images
• Where:
• Tablespace is named as [ tablespace_apex ] for user.
• tablespace_files is name for files user.
• tablespace_temp is that the name of the temporary tablespace or tablespace group.
• To support future Oracle Application Express upgrades, define the reflection directory as /i/.
• Example: @apxrtins.sql SYSAUX SYSAUX TEMP /i/

10. When Oracle Application installs, it creates three accounts:
• APEX_050100 – It owns the Oracle Application Express schema and metadata.
• FLOWS_FILES – It Owns the Oracle Application Express uploaded files.
• APEX_PUBLIC_USER – The minimally privileged account is employed for Oracle Application Express configuration with Oracle REST Data Services or Oracle HTTP Server and mod_plsql.

Leave a Comment