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

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.

Oracle forms 11g default configuration file formsweb.cfg

#formsweb.cfg defines parameter values used by the FormsServlet # formsweb.cfg defines parameter values used by the FormsServlet (frmservlet) # This section defines the Default settings. Any of them may be overridden in the # following Named Configuration sections. If they are not overridden, then the # values here will be used. # The default settings comprise two types of parameters: System parameters, # which cannot be overridden in the URL, and User Parameters, which can. # Parameters which are not marked as System parameters are User parameters. # SYSTEM PARAMETERS

Windows 8 boot loader corrupted

Problem:     Installed Windows 7 and Windows 8 in EFI mode on a hard disk some days past. Today, the boot loader is absent or corrupted. At present have the Windows 8 installer on a flash drive and tried using the Automatic Repair option to repair the boot loader but it didn't do anything. The Startup Repair option is also absent in the Windows 8 installer. How I can repair or recreate the EFI boot loader from the Command Prompt? BCDEDIT   returns the following message: The requested system device cannot be found. Solution: Firstly, boot from a UEFI Windows 8 recovery disk (CD/DVD/USB) - I found that the automated recovery process didn't find the correct Windows partition, nor when I managed to add it to BCD settings would it make it reliably boot-able e.g. using BCDEDIT I got it to find and launch the Windows partition but it refused to cold boot or would not "keep" the settings after a 2nd reboot or power off. Go into the Advanced option