Skip to main content

How to install Oracle Application Express 4.2

Installing Oracle Application Express (APEX) 4.2 follow below step.

 1. Download Oracle Apex4.2.zip
    from  http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

 2. Unzip downloaded zip file:
   

    UNIX and Linux: $ unzip apex_4.2.zip

    Windows: Double click the file apex_4.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. Full development environment. Run apexins.sql passing the following four arguments in the order shown:

    @apexins.sql 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 or tablespace group.

        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.sql SYSAUX SYSAUX TEMP /i/

    For Runtime environment, @apxrtins.sql SYSAUX SYSAUX TEMP /i/

 6. To change the password for the ADMIN account:
   

    a. Change your working directory to the apex directory where you unzipped the installation software.

    b. 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

         Run apxchpwd.sql. For example:

        @apxchpwd.sql

        When prompted, enter a password for the ADMIN account.

More details ...
http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/otn_install.htm

Comments

Popular posts from this blog

ORA-01033 Oracle initialization or shutdown in progress

ORA-01033 Oracle initialization or shutdown in progress When you connect oracle 12c plug gable database, Thus time you have get oracle initialization or shutdown in progress error. This error occurred because pluggable database are not initialized. To fix this error connect as sysdba and run  ALTER PLUGGABLE DATABASE ALL OPEN    command. ALTER PLUGGABLE DATABASE ALL OPEN Thanks.

Checking operating system version: must be 5.0, 5.1 or 5.2 Actual 6.1 Failed

This error occurred when we are installing old oracle software in latest OS (Operating System).   Basically Its’s occurring on windows platform.

AFTER LOGON Trigger not perfectly working

AFTER LOGON not perfectly working.  I have tried it on single instance oracle 12c database it's perfectly work but it's not perfectly working on multi instance Oracle 12c database. I have submitted this matter in oracle forum but not found any perfect answer. Do you know why  it's not working ???