Re: sqlplus takes 10 to 15 seconds to connect - Can anyone help

"res0kdc5" <ppoorna_at_verizon.net> wrote in news:x%Lz7.375$Qa.89686_at_paloalto-snr1.gtei.net:

> Platform: Sun Solaris
> Database Version: 8.1.7.2
> When I issue the following command to connect to the database using
> "sqlplus", it takes about 10 to 15 seconds to display the SQL> prompt.
>
> $ sqlplus /
>
> It does not matter if I use a different userid. This is not true for
> other 8.1.7.2 databases. It only takes 2 to 3 seconds on other
> databases for sqlplus to connect to the databases. I have verified that
> Oracle tracing is not set, and auditing is also not enabled. There are
> not ".dat" files in $ORACLE_HOME/otrace/admin directory. Even though I
> do not use sqlnet, I have also tried trimming the listener log. I am
> not able to figure out what might be causing the lengthy delay. Any
> help/suggestions is much appreciated. Thanks.
>
>
>

Alternatively you could try adding a similar entry to the one below into your listener.ora file.

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