DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=XRYmV6PBfRJ3DZc5KzAi5kIZA8cf+olIjv7YW8tNCAnXg9t5CR3qEwrYYlfNUIfEKhpO0BDG5qWSbVa+9Bl+5Y9UekHvQDARCKvX7nrDdYGXR1NGE47S1s0pFfESUAulGt9ZUAFfAD1/GLhv9gKthj3NzvUUr3mlcCedfKDrD5s=
Message-ID: <4ef2fbf50709071426p35d0ff22ycbc272104680a7ed@mail.gmail.com>
Date: Fri, 7 Sep 2007 23:26:31 +0200
From: "Alberto Dell'Era" <alberto.dellera@gmail.com>
To: genegurevich@discover.com
Subject: Re: ora-1012
Cc: oracle-l <oracle-l@freelists.org>
In-Reply-To: <OF9C8CFB38.F29F3FAF-ON8625734F.006F8861-8625734F.006FC6D7@discover.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Disposition: inline
References: <OF34F1FCAE.E2CBFEF9-ON8625734D.00528B9C-8625734D.00529F9F@discover.com>
	 <OF9C8CFB38.F29F3FAF-ON8625734F.006F8861-8625734F.006FC6D7@discover.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: alberto.dellera@gmail.com

From:

http://www.freelists.org/archives/oracle-l/11-2004/msg00238.html

"If the target INACTIVE connection is killed, then at source, any
further queries to the DBLINK connection may throw
ORA-02068 : following severe error from testlink04 ORA-01012: not logged on
at the first invocation of any SQL at target through the same session
at source. Subsequent calls will automatically trigger a new
connection at target."

So basically, I get from this description that if the remote session
is killed, the local session fails to notice it (that is consistent with
what happens with sqlplus) until you try to use it again.

In fact if memory serves right, this happened to me when a stupid firewall
started dropping db-link connections (TCP sockets) since no
activity was seen for X minutes. But it might be anything that
"kills" the connection.

HTH
Alberto

On 9/7/07, genegurevich@discover.com <genegurevich@discover.com> wrote:
> My appication team is running a batch process against a database (db1)
> which accesses tables in another database
> on the same server (db2) via a db link. Starting today their process
> suddenly fails with ora-1012 pointing to the db2.
> I looked at the alert log and udump directory on db2 and found no errors
> there. I searched metalink and google
> and also did not find much info pertaining to my situation (oracle 9208 on
> AIX 5.3). Does anyone have any advice
> on that. This is a big production issue right now

-- 
Alberto Dell'Era
"the more you know, the faster you go"
--
http://www.freelists.org/webpage/oracle-l