|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 184.108.40.206 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 220.127.116.11 session's trace file, but it isn't in
10.2.0.2 trace file.