-----Original Message----- From: Scott T. Hildreth [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 3:43 PM To: Reidy, Ron Cc: [email protected] Subject: RE: Oracle connect hangs forever
On Tue, 2006-04-25 at 15:19 -0600, Reidy, Ron wrote: > Get a 10046 trace of the process. This will tell you exactly what the > DB is waiting for. What makes it worse or harder to track down is it seems to be momentary problem. While this process hangs, others are connecting no problem. It's almost as the Listener drops a packet or something to that effect and the DBI connect is still waiting for it to return. This is a high traffic DB so it may be easier to work around, unless the problem worsens. Trace files would be huge. [rr] Do other processes experience this issue? I suggest this course of action because it only happens at a certain period of the day/night, and because you do not seem sure where the issue is. If the program cannot contact the DB (i.e. the dedicated server process is not created), then a trace file will show this (actually, it will show nothing). You could then move on to setting listener trace parameters. Of course, this runs the risk of creating many large files and slowing down your listener connections, but, at least you will be closer to discovering the problem. This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
