gkaindia.com

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

Down Time for  Installing APEX 4.2.1 and oracle HTTP server?

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.
Advertisement
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 the other 5 answers
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
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
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
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
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
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
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
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
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
Hello, today I tried to install the http-server for our 10gR2-database. We are using windows x64. But I cant find OHS for this release. How can I install apex then? Regards, Markhave you tried the installation, or did you just ask in advance? in the
Hi, Can someone please let me know if it's possible to use an Apple Mac Mini as a dedicated Oracle Apex Server? I'm just looking for the simplest way to install Apex on a Mac Mini I would ideally like to use OSX operating system but failing that I wo
Hi all, I have Oracle Apps 11.5.9 installed on my machine and linked it with Apex 2.2.1 version. But when i tried to open it using IE i am getting this error: Forbidden You don't have permission to access /pls/apex/apex on this server Oracle HTTP Ser
Hi, Until now I've developed some applications on a laptop. I want to bring them to my company - in this stage as a "pilot" with a limited number of employees having access. What do I need: a database, apex installed and - now is coming what I w
hi,all I want to install apex 4.0 in my PC,and I have installed the oracle XEUniv,does any installing documents that can help me solve this problem?or what commands should I type in the terminal.... ps:how to select a more preferred language,run some
Hello... i installed apex in oracle enterprise 9.2.0.1 and when the process is about to finish throw me this message... Thank you for installing Oracle Application Express. Oracle Application Express is installed in the FLOWS_030000 schema. The struc
Hi, I need to know: Can install APEX in OAS Forms & Reports?, thanks a lot....Hi, 1. OAS Forms and Repors Services run on Oracle HTTP Server (OHS). You can use OHS to connect to Apex 2. Apex is not installed in the OS, its installed inthe Oracle Data
Hi, Is it possible to install APEX 3.1.2 or 3.2 without the Text Option? The doc says yes, but the apex help can´t be used. The last time i tried it on a customer side, i got an installation error (but i can´t remember the text of the error) After in
Hi, I have Redhat Linux Server 4 and Oracle database 11g installed. I want to install APEX 4.1 in that which is the best way to install it. Iam confuse by oracle provied installtion guide, I am not getting which way to install i.e. which scnerio to u
hi..all any experienced installing apex 4.2 to fresh install XE 11g? because i always unsuccessfull with this code: -- Now beginning upgrade. This will take several minutes.------- -- Ensuring template names are unique ------- -- Migrating metadata t