Re: TOAD hangs with ORACLE8i PE on WIN98

On Mon, 26 Nov 2001 10:37:09 GMT, Reinhard.Wahl_at_gmx.de (Reinhard) wrote:

>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

Some remarks:
- I don't think lnsrctl will buy a sid_list_listener with *both* sid_name and service_name defined. According to Oracle (just went to NF8i) you don't need to configure service_name = in listener.ora at all
- at the same time I also believe the client will screw up due to the duplicate definition. It will definitely not do this

tnsnames.ora               listener.ora
service_name =           sid_name =

and probably also not

sid_name =                service_name =

I would start with removing service_name = from listener.ora. The database will register itself with the listener.

I also note TOAD has checkboxes in the login window as to which version of sqlnet you want to support.

TOAD _will_ pickup a TNS_ADMIN in the registry

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Nov 26 2001 - 17:38:03 CET