Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Very slow initial connection on Oracle 8i

Re: Very slow initial connection on Oracle 8i

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Thu, 05 Dec 2002 14:34:35 GMT
Message-ID: <%tJH9.245972$WL3.83417@rwcrnsc54>


Just for grins replace the host with the ip address in the tnsnames file. See if that makes it faster. Maybe it is a name resolution problem. Jim
"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
Received on Thu Dec 05 2002 - 08:34:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US