Re: Very slow initial connection on Oracle 8i

Do you have sqlnet.authentication_services =(NTS) in sqlnet.ora on your client? If so try removing it - this will stop connect / as sysdba.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Harry" <a_at_abc.com> wrote in message
news:a6fuuu4jk1sjj4h3jma32edjcejuk4670s_at_4ax.com...


> Using Oracle 8i enterprise on win 2000 (sp3)


>

> Installed the standard configuration & whenever I make a connection it

> takes about 10 secs. It's running on a P1900 with 1gb Ram so no reason

> there for slowness.

>

> Once I'm connected the queries work pretty much instantanously but to

> connect using SQLPLUS, Toad, ODBC, OLEDB all take about 10 secs. I

> connect using OLEDB from Visual Basic development environment & after

> the 1st connection (still in the dev env), subsequent connections are

> instant.

>

> Where/what/how should I start - I'm totally baffled! - read somewhere

> that these symtoms could be DNS related but what/how do I tell & how

> to fix them?

>

> I've included my TNSNAME.ORA  & LISTENER.ORA files in the vain hope it

> might be something simple in these - the name of my database (only use

> the one) is dev

>

>

> My TNSNAME.ORA file

> --------------------------------------------------------------------------

 ----------------------------------------


> # TNSNAMES.ORA Network Configuration File:


> i:\oracle\ora81\network\admin\tnsnames.ora

> # Generated by Oracle configuration tools.

>

> DEV =

>   (DESCRIPTION =

>     (ADDRESS_LIST =

>       (ADDRESS = (PROTOCOL = TCP)(HOST = p1900)(PORT = 1521))

>     )

>     (CONNECT_DATA =

>       (SERVICE_NAME = dev)

>     )

>   )

>

> INST1_HTTP =

>   (DESCRIPTION =

>     (ADDRESS_LIST =

>       (ADDRESS = (PROTOCOL = TCP)(HOST = p1900)(PORT = 1521))

>     )

>     (CONNECT_DATA =

>       (SERVER = SHARED)

>       (SERVICE_NAME = dev)

>       (PRESENTATION = http://admin)

>     )

>   )

>

> EXTPROC_CONNECTION_DATA =

>   (DESCRIPTION =

>     (ADDRESS_LIST =

>       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

>     )

>     (CONNECT_DATA =

>       (SID = PLSExtProc)

>       (PRESENTATION = RO)

>     )

>   )

> --------------------------------------------------------------------------

 ----------------------------------------


>

>

> My LISTENER.ORA file

> --------------------------------------------------------------------------

 ----------------------------------------


> # LISTENER.ORA Network Configuration File:


> i:\oracle\ora81\network\admin\listener.ora

> # Generated by Oracle configuration tools.

>

> LISTENER =

>   (DESCRIPTION_LIST =

>     (DESCRIPTION =

>       (ADDRESS_LIST =

>         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

>       )

>       (ADDRESS_LIST =

>         (ADDRESS = (PROTOCOL = TCP)(HOST = p1900)(PORT = 1521))

>       )

>     )

>     (DESCRIPTION =

>       (PROTOCOL_STACK =

>         (PRESENTATION = GIOP)

>         (SESSION = RAW)

>       )

>       (ADDRESS = (PROTOCOL = TCP)(HOST = p1900)(PORT = 2481))

>     )

>   )

>

> SID_LIST_LISTENER =

>   (SID_LIST =

>     (SID_DESC =

>       (SID_NAME = PLSExtProc)

>       (ORACLE_HOME = i:\oracle\ora81)

>       (PROGRAM = extproc)

>     )

>     (SID_DESC =

>       (GLOBAL_DBNAME = dev)

>       (ORACLE_HOME = i:\oracle\ora81)

>       (SID_NAME = dev)

>     )

>   )

> --------------------------------------------------------------------------

 ----------------------------------------


>

>

> Many thanks

>

> harry