As I started writing down the steps for my recent post Downtime and Apache Restricted Mode in Release 12, Steven and I exchanged some conversations which made me realize that there would be questions about the availability of the same feature Release 11i. And, it turns out to be fairly accurate realization. So, this one is for those enthusiastic pals of mine on this community. I will try to do this differently, hence making it relatively shorter in content.
Note: Navigation in 11i for the downtime page creation is slightly different than Release 12.
Is this feature available in 11i?
Yes. Check out the documentation in the References section.Is the procedure to configure the same?
Yes. As you might have understood already, there are two pieces in this puzzle.- Creation of downtime
- Managing Apache in Restricted Mode
- Step '1' is pretty much the same in 11i and Release 12. Hence, I am not recreating the screen shots for you here. Check out the steps in the table below.
- Step '2' is automated in Release using the perl script where as in Release 11i, the administrator has to go through some manual steps and run Autoconfig.
What are the exact steps in Release 11i?.
Thanks to our OAM team, these are well documented. And, they work like charm. Below are the sequence of steps for my DBA friends.Note: Navigation in 11i for the downtime page creation is slightly different than Release 12.
| S.No |
Task |
How to? |
| 1. |
Schedule System Downtime and warn your end users of an impending downtime | Use OAM to schedule downtime:
|
| 2. |
Complete the required one-time setups to monitor patch in progress |
|
| 3. |
Shutdown all Applications services | Use the standard ad script from $COMMON_TOP/admin/scripts/<context_name> directory:
|
| 4. |
Enable maintenance mode for your Applications system |
Run adadmin, and:
|
| 5. |
Start OAM in restricted mode to monitor patching in progress |
From the $COMMON_TOP/admin/scripts/<context_name> directory, run:
|
| 6. |
Begin applying patch |
Run adpatch (hotpatch=n) |
| 7. |
Monitor patching in progress |
|
| 8. |
Confirm the end of scheduled downtime upon patch completion |
From within OAM in restricted mode:
|
| 9. |
Bring your Applications System to normal mode. |
Run adadmin, and:
|
| 10. |
Shutdown Apache in restricted mode and Restart all services |
From the $COMMON_TOP/admin/scripts/<context_name> directory, run:
|
References
- About Oracle Applications Manager Mini-pack 11i.OAM.H
- Chapter 6, Section 'Managing Downtime in Restricted Mode' of Oracle Applications System Administrator's Guide - Maintenance - Release 11i (Part No B13924-04)
Comments (3)
Prasad,
I am a big fan of the ability to advertise an impending downtime ntavely through the application, however, there is an existing bug that needs to be addressed to make this functionality worthwhile. The date format generated by the downtime functionality is hardcoded for DD-MM-YYYY. There is no way to change this (currently) through the application. What should be done, is for this functionality to check the ICX date format, and use that. We had SR Number 6711531.993 opened for this, and was told bug 6776657 was filed as an enhancement. Since I can not customize this to FIX the date format, this functionality is not useful in its present state. This seems like too easy of a fix to let sit. Anything you can do to expedite this bug for resolution would be apreciated.
Regards,
Hal Moretto
Sr. Manager, DBA & Application Administration
Posted by Hal Moretto | March 31, 2008 11:55 AM
Posted on March 31, 2008 11:55
Hi Prasad,
I have one requirement. If it is not relevant to this topic, I am sorry.
I want to login to applications with sysadmin user at the same time, no other user should not be able to login. is it possible in 11.5.10.2 version? I mean only sysadmin user should be able to login? This is for our testing purpose, when ever we do restore or recovery scenarios, we dont want our users to login to system, until unless we thoroughly test the system. So, we want to restrict all other users to login and only sysadmin user should be able to login for some time before giving the system to users.
is it possible?
Posted by Rao | December 31, 2008 8:32 PM
Posted on December 31, 2008 20:32
Is this possible in 11.5.9 as well?
If not, is there another way to send a similar kind of "downtime message" to all users (even though there is no restricted mode for Apache in 11.5.9)?
We'd just like to inform all users that Forms will be down at a given time.
Posted by Frank Olsen | November 6, 2009 8:35 AM
Posted on November 6, 2009 08:35