Home > Default > Down Time for  Installing APEX 4.2.1 and oracle HTTP server?

Down Time for  Installing APEX 4.2.1 and oracle HTTP server?

November 30Hits:3
Advertisement
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.

Answers

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

Read other 5 answers

Tags:

Related Articles

  • Down Time for  Installing APEX 4.2.1 and oracle HTTP server?November 30

    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 en

  • Install and configure report service on Oracle Application Server 10gOctober 11

    i want to know how to install and configure report service on Oracle Application Server 10g Release 3 (10.1.3.1.0) Thanksthe case is that we developed an ADF Application, so we want to deploy it on the latest version of Oracle Application server. our

  • I don't know how I can install APEX 3.1.2 in Oracle Database 10g(10.2.1)November 30

    Hello. I have a hard time the install of the APEX 3.1.2. My server is WindowsXP and Oracle Database is 10g. How can I install APEX? I have seen many many many manual involved in install APEX but I can't understood that. Please teach me how the instal

  • How to install ADF Runtime libraries to an Oracle Application Server 10g?October 11

    Scenario: - JDev 10.1.3 (production) installed on my Win XP station. - OC4J 10.1.3 Standalone installed on my Win XP station. - OAS 10.1.3 (not OC4J Standalone) installed on a Linux SuSe server. - I have admin credentials for the OAS but don't for th

  • Install APEX to work on existing Oracle 10g R1 databaseNovember 30

    I want to use APEX on an existing Oracle 10g R1 database. If I install it normally with the program downloaded from your site, it installs its own database that you use. How can I set / install it to use the existing database instead of its own datab

  • To install Oracle HTTP Server onlyNovember 30

    Hi, I already installed Apex (3.0) in an Oracle database a while ago. I have used our Oracle iAS 10.1.2 as the application server. Now, I would like to install the Oracle HTTP Server in the database server and use it to run Apex. With the 10g compani

  • Install Oracle HTTP Server to Oracle Database XENovember 30

    Successfully managed to install Oracle Database XE to Windows 2000 (after temporarily dropping TNSNAMES and TNS_ADMIN variables). I want to learn how to use Application Express (formerly HTML DB) and it would be a pain/take ages to get the enterprise

  • Installing the Oracle Application server 10 g release 3November 30

    Hi all, I installed the basic installation of the oracle application server 10g release 3.After installation i was able to get the Aggrespy page listing the performance metric tables.The problem is that the page is not getting displayed in xml format

  • How to install APEX in a server database, instead XE database?October 11

    Hi, sorry but I'm new with APEX. Till today I've just used it to simple applications inside a XE database, but now I've to use it in a production database. Should I use the enterprise database, which is an Oracle 11G, or should I install it inside th

  • Installing Apex 3.0 on Oracle 10g (10.2.0) DatabaseOctober 11

    Hi All, I have installed Oracle 10g(version 10.2.0) Database. Now I am trying to configure Application Express Apex 3.0 to it. I and following the Installation Guide provided to install Apex 3.0 on Oracle 10g. But i am facing the following issues, i

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.634 s.