Re: long logon times through sqlnet

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 <oracledbaquestions@xxxxxxxxx>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?
>



-- 
Cheers,
-- Mark Brinsmead
  Senior DBA,
  The Pythian Group
  http://www.pythian.com/blogs

Other related posts: