Re: Slow connection

Giganews Newsgroups
Subject: Re: Slow connection
Posted by:  Ana C. Dent (anacede…@hotmail.com)
Date: Fri, 30 Jan 2004

Matt wrote:
> Hi,
>
> When I connect to the database with "sqlplus system/manager", the
> connection is normal.
> When I connect to the database with "sqlplus system/manager@sid", the
> connection is not normal.
> The time is between 0 and 100000 msec. There is not a big activity on
> the database server.
>
> This test is doing locally on the database server.
>
> Have you got an idea ?
>
> The database is Oracle 7.3.4 on a Alpha 800 server (Tru64 v4.0)
>
> Thanks for your help,
> Matthias

In your listener.ora file,
have your entry look similar to the following:

(SID_LIST =
    (SID_DESC =
      (SID_NAME = MWH)
      (ORACLE_HOME=/u01/app/oracle/product/7.3.4)
                (ENVS='EPC_DISABLED=TRUE')
    )

Replies

None

In response to

Slow connection posted by m.m…@voila.fr on 30 Jan 2004