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

Labels:

Comments

Post a Comment

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.
Post a Comment
Read more

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 ???
Post a Comment
Read more

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
Post a Comment
Read more