Re: Session migrated to another instance
- From: Hemant K Chitale <hemantkchitale@xxxxxxxxx>
- To: jonathan@xxxxxxxxxxxxxxxxxx
- Date: Wed, 19 Jun 2013 22:48:06 +0800
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@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on
> behalf of Mark W. Farnham [mwf@xxxxxxxx]
> 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@xxxxxxxxxxxxxxxxxx]
> Sent: Monday, June 17, 2013 9:53 AM
> To: oratune@xxxxxxxxx; mwf@xxxxxxxx; yparesh@xxxxxxxxx; rjamya@xxxxxxxxx
> 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--
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Hemant K Chitale
http://hemantoracledba.blogspot.com
http://hemantscribbles.blogspot.com
http://web.singnet.com.sg/~hkchital
--
//www.freelists.org/webpage/oracle-l
Other related posts:
