Very slow initial connection on Oracle 8i
Date: Thu, 05 Dec 2002 11:56:16 GMT
Message-ID: <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.
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 - 12:56:16 CET