Re: TOAD hangs with ORACLE8i PE on WIN98

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Fri, 30 Nov 2001 16:01:27 GMT
Message-ID: <r3ON7.29$5H3.12402_at_news1.news.adelphia.net>


I know win98SE can run Oracle 8i PE, I am doing it.

Does the copy of TOAD you have work with any other instance of Oracle?

My only problems were the listener (once I started it everything worked fine). I took all the defaults when I installed Oracle PE and TOAD needed nothing but to unzip the files.

Did you configure the tnsnames.ora?

"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 Fri Nov 30 2001 - 17:01:27 CET

Original text of this message