Re: Is it legal to run multiple autoconfig session at the same time in multinode installation.

  • From: "Tipton, Josh" <Josh.Tipton@xxxxxxxxxxxxxx>
  • To: ora-apps-dba@xxxxxxxxxxxxx
  • Date: Sat, 4 Aug 2007 08:28:41 -0500

I believe only adpatch creates the temp tables. 

----- Original Message -----
From: ora-apps-dba-bounce@xxxxxxxxxxxxx <ora-apps-dba-bounce@xxxxxxxxxxxxx>
To: ora-apps-dba@xxxxxxxxxxxxx <ora-apps-dba@xxxxxxxxxxxxx>
Sent: Sat Aug 04 07:03:48 2007
Subject: RE: Is it legal to run multiple autoconfig session at the same time in 
multinode installation.

Thank you Yury for the clarification, I guess I may try to run multi autoconfig 
sessions and incase I faced any issues I will get back to you.

I need to ask you though dose autoconfig creates temporary  table while running 
(if yes that might cuz an issues) incase it create a tmp table then its drop it 
while the other autoconfig session is running.

Fadi


-----Original Message-----
From: ora-apps-dba-bounce@xxxxxxxxxxxxx 
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Jurijs Velikanovs
Sent: Saturday, August 04, 2007 2:53 PM
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: Re: Is it legal to run multiple autoconfig session at the same time in 
multinode installation.

Hi Fadi,

You made a good point regarding DB activities what autogonfig utility makes.
From the other side we well know that Oracle RDBMS handle locking
without any problems.
Some autoconfig session might wait for others for some insignificant
portion of time.
But it will not lead to any inconsistency or problems from my point of view.
Deadlock are not possible as actions executed by autoconfig at the
same order all the time . That means that multiple autoconfig session
can't raise a deadlock situation.

In theory DB activities do not lead to any problem from my point of view.

Jurijs

On 8/4/07, Fadi Hasweh <fhasweh@xxxxxxxxxx> wrote:
>
>
>
>
> I guess it might gave you an error sometimes as you know autoconfig works on
> some tables and it might lock the table while working on it therefore you
> may face a lock situation, my advice is not to run them at the same time
>
>
>
> Fadi
>
>
>
>
>
>  ________________________________
>
>
> From: ora-apps-dba-bounce@xxxxxxxxxxxxx
> [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of
> Tipton, Josh
>  Sent: Friday, August 03, 2007 6:04 PM
>  To: ora-apps-dba@xxxxxxxxxxxxx
>  Subject: Re: Is it legal to run multiple autoconfig session at the same
> time in multinode installation.
>
>
>
>
> I have run it before on my web and app nodes at the same time without issue.
>
>  ----- Original Message -----
>  From: ora-apps-dba-bounce@xxxxxxxxxxxxx
> <ora-apps-dba-bounce@xxxxxxxxxxxxx>
>  To: ora-apps-dba@xxxxxxxxxxxxx <ora-apps-dba@xxxxxxxxxxxxx>
>  Sent: Fri Aug 03 09:58:45 2007
>  Subject: Re: Is it legal to run multiple autoconfig session at the same
> time in multinode installation.
>
>  >> If you're talking purely legal
>  I didn't mean from licences point of view.
>  By legal i thought about supportability or possability to do it
>  without significant problems.
>
>  >> I would think this is a bad idea if you have a shared application
> filesystem
>  Why you say so? In Shared FS to my knowlage most of configuration
>  files located in separate directories for each of application servers.
>  For example $COMMON_TOP/admin/scripts/<context name>/*.sh.
>  If most of configuration is separated even if shared fs is used I
>  don't see significant problem even in Shared FS.
>
>  Jurijs
>
>  On 8/3/07, Zydek, Steven <steven.zydek@xxxxxxxxxxxxx> wrote:
>  > I would think this is a bad idea if you have a shared application
> filesystem (i.e., the application stack is shared across all your nodes via
> NFS, CIFS, etc.), but if each server has its own filesystem (i.e., app
> install), it's probably fine. Does this make sense? If you're talking purely
> legal (i.e., are you licensed to run multiple instances), I don't think this
> is an issue, but could be wrong.
>  >
>  > +steve
>  >
>  > -----Original Message-----
>  > From: ora-apps-dba-bounce@xxxxxxxxxxxxx
> [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of
> Jurijs Velikanovs
>  > Sent: Friday, August 03, 2007 4:50 AM
>  > To: ora-apps-dba@xxxxxxxxxxxxx
>  > Subject: Is it legal to run multiple autoconfig session at the same time
> in multinode installation.
>  >
>  > Hello everybody !
>  >
>  > Currently I working on Multinode Apps cfg move from Solaris to Linux.
>  > There a lot of autocongig runs involved.
>  > I wonder is it allowed to run autoconfig from diferrent servers at the
>  > same time within the same Apps environment.
>  > What do you think?
>  >
>  > --
>  > Yury
>  > +371 29268222 (+2 GMT)
>  > ============================================
>  > http://otn.oracle.com/ocm/jvelikanovs.html
>  >
>  >
>  >
>
>
>  --
>  Yury
>  +371 29268222 (+2 GMT)
>  ============================================
>  http://otn.oracle.com/ocm/jvelikanovs.html
>
> ******************************************************************************
>  This email contains confidential and proprietary information and is not to
> be used
>  or disclosed to anyone other than the named recipient of this email,
>  and is to be used only for the intended purpose of this communication.
> ******************************************************************************
>
>  ________________________________
>  "This email is intended for the above named addressee (s) only and may
> contain confidential and/or privilege information and should not be used by
> anyone who is not the original intended recipient(s). Any review, print,
> copy, reliance or distribution by others or forwarding without express
> permission is strictly prohibited If you have received this email in error,
> kindly notify the sender immediately by reply email and delete this email
> and any attachments from your mailbox or any other storage mechanism. Thank
> you.
>
>  Email transmission cannot be guaranteed to be secured or error free, as
> information could be intercepted, corrupted, lost, destroyed, received late
> or incomplete, or could contain viruses. The sender therefore does not
> accept liability for any error or omission in the contents of this message,
> which arises as a result of email transmission. Opinions, conclusions and
> other information in this message that do not relate to the official
> business of Umniah Mobile Company and is not its responsibility shall be
> understood as neither given nor endorsed by the organization."
>


--
Yury
+371 29268222 (+2 GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html


"This email is intended for the above named addressee (s) only and may contain 
confidential and/or privilege information and should not be used by anyone who 
is not the original intended recipient(s). Any review, print, copy, reliance or 
distribution by others or forwarding without express permission is strictly 
prohibited  If you have received this email in error, kindly notify the sender 
immediately by reply email and delete this email and any attachments from your 
mailbox or any other storage mechanism. Thank you.

Email transmission cannot be guaranteed to be secured or error free, as 
information could be intercepted, corrupted, lost, destroyed, received late or 
incomplete, or could contain viruses. The sender therefore does not accept 
liability for any error or omission in the contents of this message, which 
arises as a result of email transmission. Opinions, conclusions and other 
information in this message that do not relate to the official business of 
Umniah Mobile Company and is not its responsibility shall be understood as 
neither given nor endorsed by the organization."



******************************************************************************
This email contains confidential and proprietary information and is not to be 
used 
or disclosed to anyone other than the named recipient of this email, 
and is to be used only for the intended purpose of this communication.
******************************************************************************

Other related posts: