Re: TOAD hangs with ORACLE8i PE on WIN98

[Quoted] You might want to consider CAST Application Mining Suite for Oracle? www.castsoftware.com

"Reinhard" <Reinhard.Wahl_at_gmx.de> wrote in message news:3c021b33.10004305_at_News.CIS.DFN.DE...
> Hi there,
>
> 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 Tue Nov 27 2001 - 18:34:22 CET