Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> connection time issues

connection time issues

From: Ben <balvey_at_comcast.net>
Date: Wed, 25 Jul 2007 12:16:59 -0700
Message-ID: <1185391019.158025.282240@r34g2000hsd.googlegroups.com>


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. Received on Wed Jul 25 2007 - 14:16:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US