16 February 2010

Download and Install Oracle Application Express



To install Oracle Application Express:
1. Download the file apex_3.2.zip from the Oracle Application Express download
page. See:
http://www.oracle.com/technology/products/database/application_
express/download.html
Note that the actual file name may differ if a more recent release has shipped since
this document was published.
2. Unzip apex_3.2.zip as follows, preserving directory names:
UNIX and Linux: Unzip apex_3.2.zip
Windows: Double click the file apex_3.2.zip in Windows Explorer
3. Change your working directory to apex.
4. Start SQL*Plus and connect to the database where Oracle Application Express 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
On UNIX and Linux:
$ sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password
5. Disable any existing password complexity rules for the default profile. See
"Configuring Password Protection" in Oracle Database Security Guide.
6. Select the appropriate installation option.
Full development environment provides complete access to the Application
Builder environment to develop applications. A Runtime environment enables
users to run applications that cannot be modified. To learn more, see "About the
Oracle Application Express Runtime Environment" on page 1-2.
Available installation options include:
Full development environment. Run apexins.sql passing the following
four arguments in the order shown:
@apexins tablespace_apex tablespace_files tablespace_temp images
Where:
See Also: "About the Oracle Application Express Runtime
Environment" on page 1-2
Downloading from OTN and Configuring the Embedded PL/SQL Gateway
3-4 Oracle Application Express Installation Guide
tablespace_apex is the name of the tablespace for the Oracle
Application Express application user.
tablespace_files is the name of the tablespace for the Oracle
Application Express files user.
tablespace_temp is the name of the temporary tablespace.
images is the virtual directory for Oracle Application Express images. To
support future Oracle Application Express upgrades, define the virtual
image directory as /i/.
Example:
@apexins SYSAUX SYSAUX TEMP /i/
Runtime environment. Run apxrtins.sql passing the following arguments
in the order shown:
@apxrtins tablespace_apex tablespace_files tablespace_temp images
Where:
tablespace_apex is the name of the tablespace for the Oracle
Application Express application user.
tablespace_files is the name of the tablespace for the Oracle
Application Express files user.
tablespace_temp is the name of the temporary tablespace.
images is the virtual directory for Oracle Application Express images. To
support future Oracle Application Express upgrades, define the virtual
image directory as /i/.
Example:
@apxrtins SYSAUX SYSAUX TEMP /i/
When Oracle Application Express installs it creates three new database accounts:
APEX_030200 - The account that owns the Oracle Application Express schema
and metadata.
FLOWS_FILES - The account that owns the Oracle Application Express uploaded
files.
APEX_PUBLIC_USER - The minimally privileged account used for Oracle
Application Express configuration with Oracle HTTP Server and mod_plsql.
If you are upgrading from a previous release, FLOWS_FILES, already exists and
APEX_PUBLIC_USER is created if it does not already exist.
See Also: Oracle Database PL/SQL Language Reference for more
information about SQL*Plus
Tip: Oracle Application Express must be installed from a writable
directory on the file system. See "Reviewing a Log of an Installation
Session" on page A-1.
Downloading from OTN and Configuring the Embedded PL/SQL Gateway
Downloading from Oracle Technology Network 3-5


Change the Password for the ADMIN Account


In a new installation of Oracle Application Express, or if you are converting a runtime
environment to a development environment, you must change the password of the
internal ADMIN account. In an upgrade scenario, the password will be preserved and
carried over from the prior release.
To change the password for the ADMIN account:
1. Change your working directory to the apex directory where you unzipped the
installation software.
2. Start SQL*Plus and connect to the database where Oracle Application Express 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
On UNIX and Linux:
$ sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password
3. Run apxchpwd.sql. For example:
@apxchpwd
When prompted enter a password for the ADMIN account.



Restart Processes

After you install Oracle Application Express, you must restart the processes that you
stopped before you began the installation, such as listener and other processes.
Share:

2 comments:

  1. Best Software Downloads and Reviews. the most comprehensive source for free-to-
    trysoftware downloads on the WebBEST 4
    DOWNLOADS

    ReplyDelete
  2. Nice. You have shared all the installation steps briefly. Just by following all these steps one can easily install Oracle application express. This post is a great help to everyone. Thanks for posting.
    sap erp 6.0

    ReplyDelete