This discussion is archived
4 Replies Latest reply: Mar 28, 2013 1:16 AM by john2013 RSS

Down Time for  Installing APEX 4.2.1 and oracle HTTP server?

john2013 Newbie
Currently Being Moderated
Hi, all:

I plan to install APEX 4.2.1 and oracle HTTP server on 10.2.0.4 database.

Is there any down time required during installation?
I mean during installation, do I need to block users from accessing the database?
Can they do their normal data entry / inquiry?


thanks,
John
ps. There will be server backup before installation.
  • 1. Re: Down Time for  Installing APEX 4.2.1 and oracle HTTP server?
    jariola Guru
    Currently Being Moderated
    Hi,

    You need block access to APEX during upgrade.
    Please see details from Application Express Installation Guide
    http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/toc.htm

    Regards,
    Jari
    -----
    My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
    Twitter: http://www.twitter.com/jariolai
  • 2. Re: Down Time for  Installing APEX 4.2.1 and oracle HTTP server?
    john2013 Newbie
    Currently Being Moderated
    thanks jarola for the reply.

    I am trying to do a new installation of apex on another database server,
    which does not have apex yet. it's not an upgrade.

    do I need to block database access by other apps?

    thanks,
    john
  • 3. Re: Down Time for  Installing APEX 4.2.1 and oracle HTTP server?
    jariola Guru
    Currently Being Moderated
    Hi,

    Documentation says
    >
    3.1 Recommended Pre-installation Tasks

    Before installing Oracle Application Express, Oracle recommends that you complete the following steps:

    Review and satisfy all Oracle Application Express installation requirements. See "Oracle Application Express Installation Requirements".

    Shut down with normal or immediate priority the Oracle Database instances where you plan to install Oracle Application Express. On Oracle Real Application Clusters (Oracle RAC) systems, shut down all instances on each node.

    An alternative to shutting down the database is to prevent all users from accessing Oracle Application Express when upgrading your installation from a previous release of Oracle Application Express. Oracle only recommends this option in high availability production environments where planned outages are not available. For all other scenarios, the database should be shut down.

    To disable access to Oracle Application Express when the existing installation is using the Application Express Listener, shut down the appropriate application server where the Application Express listener is deployed.

    To disable user access to Oracle Application Express when the existing installation is using the Oracle HTTP Server with mod_plsql, you should either shut down the Web server or disable the Application Express Database Access Descriptor of the Web server.

    For an existing installation using the embedded PL/SQL gateway, you should disable the Oracle XML DB Protocol Server by setting the HTTP port to 0. This can be accomplished by starting SQL*Plus, connecting as SYS to the database where Oracle Application Express is installed, and running:

    EXEC DBMS_XDB.SETHTTPPORT(0);

    Once you have prevented access from Oracle Application Express users, you should log into SQL*Plus as SYS, connecting to the database where Oracle Application Express is installed, and query V$SESSION to ensure there are no long running sessions which would interfere with the upgrade process.

    Back up the Oracle Database installation.

    Oracle recommends that you create a backup of the current Oracle Database installation before you install Oracle Application Express. You can use Oracle Database Recovery Manager, which is included in the Oracle Database installation, to perform the backup.

    See Also:
    Oracle Database Backup and Recovery User's Guide

    Start the Oracle Database instance that contains the target database.

    After backing up the system, you must start the Oracle instance that contains the target Oracle database. Do not start other processes such as a Web Listener. However, if you are performing a remote installation, make sure the database listener for the remote database has started.
    >


    Regards,
    Jari
    -----
    My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
    Twitter: http://www.twitter.com/jariolai
  • 4. Re: Down Time for  Installing APEX 4.2.1 and oracle HTTP server?
    john2013 Newbie
    Currently Being Moderated
    thanks jari,
    thought i can eliminate the downtime. should have read the doc first.

    Edited by: john2013 on Mar 28, 2013 1:16 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points