Re: Session migrated to another instance

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Wed, 19 Jun 2013 22:48:06 +0800
Message-ID: <CAMNBsZu3QWiV2gJGNS0jKuCj7LCQjVciLjdRW7WSHe+8harjZQ_at_mail.gmail.com>

Hmm.. Yes, TAF without an instance restart but with the DBA (or on automated script on the server) killing the session. But if the session is killed why would it reconnect ?
Hemant K Chitale

On Tue, Jun 18, 2013 at 12:03 AM, Jonathan Lewis < jonathan_at_jlcomp.demon.co.uk> wrote:

>
>
> Mind you, the original post does actually say:
> "No explicit commands issued from the client."
>
> But anyone who watches House knows the House rule.
>
> Removing tongue from cheek, and given there were 42 minutes between the
> calls, what would happen if a DBA had had time to kill the session from the
> server side - is there a possible TAF configuration that would result in it
> re-connecting ?
>
> Regards
> Jonathan Lewis
>
>
> ________________________________________
> From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on
> behalf of Mark W. Farnham [mwf_at_rsiz.com]
> Sent: 17 June 2013 16:53
> To: 'ORACLE-L'
> Subject: RE: Session migrated to another instance
>
> That would certainly do it. I took Hemant's Original Post as a transcript.
>
> I *thought* we were discussing server side TAF and reasons a relocation
> might take place the instance running without interruption where the
> session
> was located before the relocation.
>
> I'm not sure what actions a dba might undertake on a session to force it to
> relocate, and I'm also not sure what network events might cause it to
> relocate.
>
> IF that is not a transcript, JL's question fits Occam's razor.
>
> -----Original Message-----
> From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk]
> Sent: Monday, June 17, 2013 9:53 AM
> To: oratune_at_yahoo.com; mwf_at_rsiz.com; yparesh_at_gmail.com; rjamya_at_gmail.com
> Cc: 'Hemant K Chitale'; 'ORACLE-L'
> Subject: RE: Session migrated to another instance
>
>
>
> Or running a script which has a hidden connect in it ?
>
> Regards
> Jonathan Lewis--
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 

Hemant K Chitale
http://hemantoracledba.blogspot.com
http://hemantscribbles.blogspot.com
http://web.singnet.com.sg/~hkchital


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 19 2013 - 16:48:06 CEST