Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id A8DFB19611F2 for ; Wed, 19 Jun 2013 17:52:54 +0200 (CEST) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTP for ; Wed, 19 Jun 2013 17:52:54 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9573723002; Wed, 19 Jun 2013 11:38:34 -0400 (EDT) Authentication-Results: turing.freelists.org; dkim=fail (verification failed; insecure key) header.i=@gmail.com; dkim-adsp=none (insecure policy) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id h-4a-4d0eYis; Wed, 19 Jun 2013 11:38:34 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 579BA22FE9; Wed, 19 Jun 2013 11:37:53 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 19 Jun 2013 11:37:12 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1A0D322F9E for ; Wed, 19 Jun 2013 11:37:12 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id HsKVhprMk0jg for ; Wed, 19 Jun 2013 11:37:12 -0400 (EDT) Received: from mail-lb0-f179.google.com (mail-lb0-f179.google.com [209.85.217.179]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6C13C22F4A for ; Wed, 19 Jun 2013 11:37:10 -0400 (EDT) Received: by mail-lb0-f179.google.com with SMTP id w20so4896258lbh.10 for ; Wed, 19 Jun 2013 08:51:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:cc:content-type; bh=9WqqOEljP+N3sz7nU3zT3fHKHgsN+Shia1mGr551ozk=; b=n0C5YTIGO1BT3ZlfE9UQ//aw1cCw1H+FB2XfXClPW9LpGH2hGOJgWUAyLAiIwxozQx C26/s0zICSPn/ASuYGsyfbWFIQMsL6spVPbf1BfImoH2NfU28nD6gy7pv4CcsA1jftZn JgibHsmKUE1kZdY8t/6plCW+s2DMFePHDtOo+w4Rk6IV2A/iJMW71i2ajYh1vuuoPEat AE8BhdOFWjypLtNpXSw3kydP51kYV5PHc8rCMXPUrm4tWg6SgUC4OxojE4x6HNjMjLbj fIY+mVbQPMJ8Jkr20M4xs+g8Q258g5QbY/IBSuBHr7jWl5BHtKgkBmugN1dyzAX3UwXJ 9QxA== MIME-Version: 1.0 X-Received: by 10.112.144.97 with SMTP id sl1mr2748037lbb.56.1371657088437; Wed, 19 Jun 2013 08:51:28 -0700 (PDT) Received: by 10.114.62.73 with HTTP; Wed, 19 Jun 2013 08:51:28 -0700 (PDT) In-Reply-To: References: <-4405569764250998062@unknownmsgid> <010101ce6b5e$d99ebd80$8cdc3880$@rsiz.com> <1371476333.29851.YahooMailNeo@web121604.mail.ne1.yahoo.com> <019f01ce6b72$de4e4bc0$9aeae340$@rsiz.com> Date: Wed, 19 Jun 2013 11:51:28 -0400 X-Google-Sender-Auth: NA3TtZ6pOfi58rJ9bUFHuCZxFlo Message-ID: Subject: Re: Session migrated to another instance From: Andy Klock To: Hemant K Chitale Cc: ORACLE-L Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 49393 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: andy@oracledepot.com Precedence: normal Reply-To: andy@oracledepot.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l Just going back to the beginning of the thread, you mentioned that your client side tns has nothing but the SCAN defined. Is it possible that your session is not dedicated but rather using a shared server connection? Andy On Wed, Jun 19, 2013 at 10:48 AM, Hemant K Chitale wrote: > 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 > > -- http://www.freelists.org/webpage/oracle-l