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,

[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

Original text of this message