long logon times through sqlnet
- From: Dba DBA <oracledbaquestions@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 30 Mar 2009 11:38:22 -0400
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?