Steps to install Apex 4 on linux

Oracle Application Express (Oracle APEX) is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure. Oracle APEX is a fully supported, no cost option of the Oracle database.

Browser Requirement:
To view or develop Oracle Application Express applications, Web browsers must
support Java Script and the HTML 4.0 and CSS 1.0 standards. The following browsers meet this requirement:
1)Microsoft Internet Explorer 6.0 or later version
2)Firefox 1.0 or later

HTTP Server Requirements:
In order to run, Oracle Application Express must have access to one of the following:
1)Embedded PL/SQL gateway
2)Oracle HTTP Server and mod_plsql
Oracle XML DB HTTP Server with the embedded PL/SQL gateway installs with
Oracle Database 11g. It provides the database with a Web server and also the necessary infrastructure to create dynamic applications.

Oracle Application Express requires the shared_pool_size of the target database to be at least 100 MB.

Disk Space Requirement:
Oracle Application Express disk space requirements are as follows:
1)Free space for Oracle Application Express software files on the file system: 450 MB
2)Free space in Oracle Application Express tablespace: 100MB
3)Free space in SYSTEM tablespace: 85 MB
Free space in Oracle Application Express tablespace for each additional language
(other than English) installed: 30MB

Although you can install APEX into an existing tablespace, I recommend creating a new tablespace.
This will hold all the APEX objects and also any files uploaded to the database.
To create a new tablespace called APEX run the following:

CREATE TABLESPACE APEX DATAFILE "<filename and path>"

SIZE 200M

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

Installing the Oracle Application Express Software:
To install Oracle Application Express release 4.0.1:
1.Download the file apex_4.0.1.zip from the Oracle Application Express download
page. See:
http://www.oracle.com/technology/products/database/application_
express/download.html
2.Unzip apex_4.0.1.zip as follows, preserving directory names:
$ Unzip apex_4.0.1.zip
3. Change your working directory to apex.
$ cd apex
4. Start SQL*Plus and connect the database where Oracle Application Express is
installed as SYS. For example:

$ sqlplus sys/SYS_password as sysdba
Run apexins.sql passing the following five arguments in the order shown:

@apexins password tablespace_apex tablespace_files tablespace_temp images

eg: SQL>@apexins foo APEX APEX TEMP /i/

Configure Embedded PL/SQL Gateway:
To configure the embedded PL/SQL gateway:
1. Change your working directory to the directory where you
unzipped the Application Express software.
2. Start SQL*Plus and connect the database where Oracle Application Express is
installed as SYS. For example:
$ sqlplus sys/password as sysdba
$ @apex_epg_config
eg:After unzipped you have directiory structure like: /home/apex
@apex_epg_config /home
The next step is to upload the images.
Run apxldimg.sql passing the file system path to the base directory where the Oracle Application Express software was unzipped as shown in the following example:
SQL>@apxldimg.sql /home

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_040000 ACCOUNT UNLOCK;
SQL > ALTER USER FLOWS_FILES ACCOUNT UNLOCK;
SQL > ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;

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.

You can verify the port no by using th following command:

SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

You can start XML DB as follows:
Start SQL*Plus and connect the database where Oracle Application Express is
installed as SYS. For example:
$ sqlplus sys/SYS_password as sysdba

Enter a statement similar to the following:

EXEC DBMS_XDB.SETHTTPPORT(port);

eg:SQL>EXEC DBMS_XDB.SETHTTPPORT(8080);

Open a browser and type the address
eg:http://localhost:8080

You will need to log in using the workspace "internal", username "admin" and the password you specified during installation.

In case you are not able to see images and logo follow this work around:
Execute reset_image_prefix script located in utilities directory.

Change your working directory to <base directory>/apex/utilities

$ sqlplus conn sys/password as sysdba

SQL>@reset_image_prefix.sql /i/

Oracle 11g Release 2 installation on linux screenshots

Provide email id if you wish to receive support from Oracle.

Select the operation you want to perform.

Enter the details below with admin password.

Oracle 11g Installation Screenshot

1. Select installation method

Following two installation methods are available:

• Basic Installation – Choose this to perform the full Oracle Database 11g installation with standard configuration options. You can use only filesystem for storage in this option.
• Advanced Installation – This gives your full control over the installation, including the ability to choose Automatic Storage Management. Select this option as shown below.

Fig - Select Installation Method

2. Specify Inventory directory and credentials

Enter the following information:

• Enter the inventory directory: /u01/app/oraInventory
• Specify operating system group name: oinstall

Fig - Specify Inventory directory and credentials

3. Select Installation Type

Following three installation types are available:

• Enterprise Edition – Select this option.
• Standard Edition
• Custom

Fig - Select Installation Type

4. Specify Install Location

Enter the following information:

• Oracle Base: /u01/app/oracle
• Name: Oracle_Home
• Path: /u01/app/oarcle/product/11.1.0

Fig - Select Install Location

5. Product-Specific Prerequisite Checks

In this screen, the Installer verifies that your environment meets all of the minimum requirements for installing and configuring the products that you have chosen to install. You must manually verify and confirm the items that are flagged with warnings and items that require manual checks.

6. Select Configuration Option

Following three configuration options are available:

• Create a Database – Select this option.
• Configure Automatic Storage Management (ASM)
• Install Software Only

Fig - Select Configuration Option

7. Select a Database Configuration

Following three database configuration options are available.

• General Purpose/Transaction Processing – Select this option.
• Data Warehouse
• Advanced

Fig - Select Database Configuration

8. Specify Database Configuration

Enter the following information:

• Global Database Name: devdb.example.com . An Oracle database is uniquely identified by a Global Database Name, typically of the form “name.domain”
• SID: devdb

9. Specify Database Configuration Details

There are four different tabs in this screen as shown below:

• Memory Tab
  
  
  • Select the check-box to Enable Automatic Memory Management
  • Drag the bar to allocate the memory. This will automatically allocate memory size for SGA and PGA depending on the total database memory allocated.
• Character Sets Tab. Following three character set options are given in this tab.
  
  
  • Use the default
  • Use Unicode (AL32UTF8)
  • Choose from the list of character sets. Select Database Character Set as Unicode standard UTF-8AL32UTF8 – Select this option.
• Security Tab – Just leave the defaults in this tab.
• Sample Schema Tab – Just leave the defaults in this tab.

Fig - Select Database Config Details with Memory Tab

10. Select Database Management Option

Following two management options are available:

• Use Grid Control for Database Management
  
  
  • Management Service: Choose an agent.
• Use Database Control for Database Management- Select this option.
  
  
  • Select the check-box to Enable Email Notifications
  • Outgoing mail (SMTP) Server:
  • Email Address:

Fig - Select Database Management Option

11. Specify Database Storage Option

Following two storage options are available:

• File System – Select this option.
  
  
  • Specify Database File location: /u01/app/oracle/oradata/
• Automatic Storage Management. ASM simplifies database storage administration and optimizes database layout for I/O performance.

12. Specify Backup and Recovery Option

Enable automated backup as shown below. If you’ve configured ASM, you can choose to store the automated backups on ASM. If not, select File System option.

Fig - Specify Backup and Recovery Options

13. Specify database schema password

Enter the password for sys, system, sysman, dbsnmp schemas. You have the option of either using the same passwords or different password for all the accounts in this screen.

14. Privileged Operating System Groups

Enter the following information in this screen:

• Database Administrator (OSDBA) Group: dba
• Database Operator (OSOPER) Group: dba
• ASM administrator (OSASM) Group: dba

15. Oracle Configuration Manager Registration

You can associate your configration information with your metalink account as shown below.

Fig - Oracle Configuration Manager Registration

16. Final Summary Screen

This will display a summary of all the installation option you’ve selected so far. Click on Install to complete the installation.

Fig - Installation Summary Screen