Message-Id: <10627.117682@fatcity.com> From: Satar Naghshineh Date: Fri, 22 Sep 2000 09:51:03 -0700 Subject: RE: Getting connected quite long.... This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C024B5.4B1CB310 Content-Type: text/plain Couple of things off the top of my head: 1. Check the size of your listener.log file. Resize it to 0 by issuing the following command at the Unix prompt: # >listener.log 2. You're running some type NIS, DNS, etc that is unable to connect to the database initially and must manually locate the server. Hey, I know I don't make sense, I haven't had my coffee yet. ;) Satar > -----Original Message----- > From: Syaugi H.S [SMTP:Syaugi@psn.co.id] > Sent: Friday, September 22, 2000 12:40 PM > To: Multiple recipients of list ORACLE-L > Subject: Getting connected quite long.... > > Dear Gurus, > > Need your advice about what to check, for getting connected to db from > SQLPLUS or Developer take so quite long time. > When type in user/pass@service [enter] .... waiting for about 2 - 3 > minutes to get connected to db. or sqlplus prompt. > Even this done from server console itself. > > We're using : > * Oracle 8i db on HP Unix, 750 M SGA, > * port 1521 & 1526 both opened > > Thank you for help and advice. > > Syh. > ------_=_NextPart_001_01C024B5.4B1CB310 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: Getting connected quite long....

Couple of things off = the top of my head:
1. Check the size = of your listener.log file.  Resize it to 0 by issuing the = following command at the Unix prompt:
# = >listener.log

2. You're running = some type NIS, DNS, etc that is unable to connect to the database = initially and must manually locate the server. Hey, I know I don't make = sense, I haven't had my coffee yet. ;)

Satar