Re: Maintenance mode
- From: "Jurijs Velikanovs" <j.velikanovs@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Wed, 1 Aug 2007 12:28:08 +0300
Hi,
Thank you for good posting.
I am not familiar with all details of FNDLOAD executable.
Just wonder if it have possibility to load data using PL/SQL API calls or it
loading data directly to the tables only.
The reason for this curiosity is as follows:
- In normal circumstances there is no triggers on Apps tables
- If FNDLOAD loads data into to tables directly there is no chance to RAISE
any Events as events appears only if API is called
- If FNDLOAD can load data using API calls then there is possibility that it
raises events and as result of it subscriptions might be executed.
In Maintenance mode BES is off and no Events are processed.
Jurijs
On 8/1/07, Satheesh Kathamuthu <satheesh.ceg@xxxxxxxxx> wrote:
>
> Hi,
>
> Basically patching is done for bug fixing and some to introduce new
> functionalities. When a new functionality is introduced lots of seed data is
> uploaded to Application instance. Some of these seeded data include Roles,
> Responsibilities, Requests, Request Groups, Help files etc. So these seeded
> data are loaded into the Application instance through this FNDLOAD
> executable. It reads the .ldt files that comes along with a patch and
> uploads that to the instance. Again this is basically my understanding of
> the process. Please corect me if i'am wrong. FNDLOAD executable is also
> widely used while migration of these data that are set in one instance to
> another instance. User created Roles, Responsibilities, Requests, Request
> Groups can also be migrated using this utility. FNDLOAD utility uses the
> .ldt and .lct files. For further information about FNDLOAD refer
> http://oracle.anilpassi.com/oracle-fndload-script-examples.html .
>
>
> On 7/31/07, k srinivas <k.sridba@xxxxxxxxx> wrote:
> >
> >
> > Hi Satheesh,
> >
> > What does FNDLOAD exactly does...wht happens in the background.
> >
> > Thanks
> > Sreenivash.
> >
> > On 7/31/07, Satheesh Kathamuthu <satheesh.ceg@xxxxxxxxx > wrote:
> > >
> > > Hi,
> > >
> > > When you put the instance on Maintenance Mode it will turn of some of
> > > the Business Even Systems (BES). This will increase the performance
> > > greatly
> > > during the patching process since lots of FNDLOAD happens during the
> > > patching. So even if you shut down the apps tier services, the database
> > > that
> > > is running these BESs is not shut down. This maintenance mode option is
> > > introduced only to reduce the patching time.
> > >
> > > -Satheesh.
> > >
> > >
> > >
> > > On 7/31/07, Irfan Momin <irfanwiz@xxxxxxxxx > wrote:
> > > >
> > > > Hello Kishore,
> > > >
> > > > Its nice of you to point out that, but I am still not convinced with
> > > > the reply. As you just mentioned, it will help with Apache which can
> > > > be an
> > > > optional feature. My question then why does ADPATCH check whether the
> > > > system is in Maintenance Mode.
> > > >
> > > > Regards,
> > > > Irfan Momin
> > > > Oracle Applications DBA
> > > >
> > > >
> > > > ----- Original Message ----
> > > > From: Kishore Adikar < kishore.adikar@xxxxxxxxxxxxxxxxxx>
> > > > To: ora-apps-dba@xxxxxxxxxxxxx
> > > > Sent: Tuesday, July 31, 2007 11:47:30 AM
> > > > Subject: RE: Maintenance mode
> > > >
> > > > Sreenivash,
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > You can start apache in restricted mode ( adaprstctl.sh) while
> > > > applying a patch.
> > > >
> > > >
> > > >
> > > > Once Maintenance mode is enabled, anybody who access the site will
> > > > get a message that "The system is currently undergoing a scheduled
> > > > maintenance. ". There are some more features too.
> > > >
> > > >
> > > >
> > > > For more information refer the below metalink note
> > > >
> > > >
> > > >
> > > > *Maintenance Mode - A New Feature in 11.5.10* Doc ID: *Note:
> > > > 291901.1*
> > > >
> > > > * *
> > > >
> > > > *Regards,*
> > > >
> > > > *Kishore*
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > ------------------------------
> > > >
> > > >
> > > >
> > > > -----Original Message-----
> > > > *From:* ora-apps-dba-bounce@xxxxxxxxxxxxx [mailto:
> > > > ora-apps-dba-bounce@xxxxxxxxxxxxx] * On Behalf Of *k srinivas
> > > > *Sent:* Tuesday, July 31, 2007 11:09 AM
> > > > *To:* ora-apps-dba@xxxxxxxxxxxxx
> > > > * Subject:* Maintenance mode
> > > >
> > > >
> > > >
> > > > Hi DBAs,
> > > >
> > > >
> > > >
> > > > When applying a patch..we shut down the application services...then
> > > > what is the use of enabling Maintenance mode....
> > > >
> > > >
> > > >
> > > > Thanks
> > > >
> > > > Sreenivash
> > > >
> > > >
> > > >
> > > > ------------------------------
> > > > Be a better Globetrotter. Get better travel answers
> > > > <http://us.rd.yahoo.com/evt=48254/*http://answers.yahoo.com/dir/_ylc=X3oDMTI5MGx2aThyBF9TAzIxMTU1MDAzNTIEX3MDMzk2NTQ1MTAzBHNlYwNCQUJwaWxsYXJfTklfMzYwBHNsawNQcm9kdWN0X3F1ZXN0aW9uX3BhZ2U-?link=list&sid=396545469>from
> > > > someone who knows.
> > > > Yahoo! Answers - Check it out.
> > > >
> > >
> > >
> >
>
--
Yury
+371 29268222 (+2 GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
Other related posts:
