TOAD hangs with ORACLE8i PE on WIN98
From: Reinhard <Reinhard.Wahl_at_gmx.de>
Date: Mon, 26 Nov 2001 10:37:09 GMT
Message-ID: <3c021b33.10004305_at_News.CIS.DFN.DE>
[Quoted] Hi there,
Remove _nospam from address to reply Received on Mon Nov 26 2001 - 11:37:09 CET
Date: Mon, 26 Nov 2001 10:37:09 GMT
Message-ID: <3c021b33.10004305_at_News.CIS.DFN.DE>
[Quoted] Hi there,
[Quoted] [Quoted] I have a ORACLE 8i server- and a 8.0.6 client-installation (from
designer 6i install) on Windows98 SP2.
SQLPLUS 8.1.6 and SQLPLUS 8.0.6 are able to connect without (only
8.1.6) or with connectstring (with thanks to Sybrand):
with SQLPLUS 8.1.6
SQL> connect scott/tiger
Connected
SQL> connect scott/tiger_at_dbfirst81
Connected
with SQLPLUS 8.0.6
SQL> connect scott/tiger_at_dbfirst80 Connected
To distinguish in TOAD I named them different.
But when I try to connect with TOAD it always hangs.
There is no TNS_ADMIN-entry in my registry! I tried to use TOAD_HOME, but the same procedure as everytime!
What do I do wrong?
Can anyone explain?
Reinhard
- my listener.ora for ORACLE8i-Server:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC =
(GLOBAL_DBNAME = DBFIRST)
(ORACLE_HOME = c:\Oracle\Ora817)
(SID_NAME = DBFIRST)
(SERVICE_NAME = DBFIRST)
) ) - my tnsnames.ora for ORACLE8i-Client:
DBFIRST81 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = extproc0))
) (CONNECT_DATA =
(service_name = dbfirst)
) ) - my tnsnames.ora for ORACLE80-Client:
DBFIRST80 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = extproc0))
) (CONNECT_DATA =
(service_name = DBFIRST)
(GLOBAL_NAME = DBFIRST)
) ) - both sqlnet.ora:
NAMES.DIRECTORY_PATH=(TNSNAMES,ONAMES)
Remove _nospam from address to reply Received on Mon Nov 26 2001 - 11:37:09 CET