Re: long logon times through sqlnet

From: Mark Brinsmead <>
Date: Mon, 30 Mar 2009 20:08:38 -0600
Message-ID: <>

30 seconds? Sounds a lot like a DNS timeout.

From the database server, are you able to reverse-lookup the IP of the server you are logging in from?

Of course, this is only a guess -- there are many other possible causes.

On Mon, Mar 30, 2009 at 9:38 AM, Dba DBA <>wrote:

> Oracle 10.1.latest patch
> OS: Tru 64
> oracle does not have 10.2 for tru 64.
> This just started to happen. We have not changed anything. If we login from
> the command line on the server and bypass sqlnet logon time is normal. If we
> go through the listener logon time is 30 seconds. We are not out of memory
> or at any resource limits. We have a ticket with Oracle but they are
> pointing all over the place.
> for some reason they have not asked for a sqlnet trace. I just got one and
> I don't see anything in it so I am sending it to support. I ran an AWR
> report and do not see any waits outside the norm. This tells me that the
> issue is happening before you get to the database. so it is a listener
> issue.
> is there any other type of trace I should run? OS level? Or log file to
> look at to help diagnose this?

-- Mark Brinsmead
  Senior DBA,
  The Pythian Group

Received on Mon Mar 30 2009 - 21:08:38 CDT

Original text of this message