RE: Getting connected quite long....

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Fri, 22 Sep 2000 09:51:03 -0700
Message-Id: <10627.117682@fatcity.com>

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_at_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_at_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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Getting connected quite long....</TITLE>
</HEAD>
<BODY>

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

<UL>
-----Original Message-----
 From:   Syaugi H.S [SMTP:Syaugi_at_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_at_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. =
Received on Fri Sep 22 2000 - 11:51:03 CDT