connection time issues

Giganews Newsgroups
Subject: connection time issues
Posted by:  Ben (balv…@comcast.net)
Date: Wed, 25 Jul 2007

I have two databases on the same unix box. AIX5L

logging into instance #1 10.2.0.2 EntEd using 10.2.0.1 sqlplus windows
cilent takes > 10 seconds.

logging into instance #2 9.2.0.5 EntEd using 10.2.0.1 sqlplus windows
client takes < 1 sec from same client machine.

Where do I begin? I have an SR opened with Oracle but they are taking
forever. I've generated sqlnet.ora trace files for both and a listener
trace file for both logons. I don't know much about reading the trace
files though. I did notice that a sql statement that I ran as a test
is displayed in the 9.2.0.5 session's trace file, but it isn't in
10.2.0.2 trace file.

Replies