SV: local 8i db on nt - tnsnames error

This is probably a problem connected with Net8. Is the service Oracle8iTNSListener (or something like that) started? Which version of SqlPlus are you using? Version 8.1.5 should work if the listener starts OK. In lack of more information: You could try to add a line to the registry: HKEY_LOCAL_MACHINE/Software/Oracle: TNS_ADMIN = C:\ORACLE8i\NETWORK\ADMIN or use TNS_ADMIN = C:\ORANT\NETWORK\ADMIN if you have older oracle software installed, copy your tnsnames.ora to this location and make sure C:\ORANT\BIN is located first (before C:\ORACLE8i\BIN) in the environment PATH. Peter Hewson <phew_at_ozemail.com.au> skrev i meldingsnyheter:385BB9C4.622BC0D0_at_ozemail.com.au...
> Hi,
>
> I am trying to connect to a local 8i database on my nt machine.
> From sqlplus, if I don't enter the host string it is OK.
> But if I enter devl, it has a TNS failure. Toad needs a host string,
> so it does'nt work.
>
> Here is my tnsnames.ora entry
> -----
> devl =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = IPC)
> (Host = piii-500)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = devl)
> )
> )
> -----
>
>
> Here is my listener.ora entry
> ------
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(HOST = piii-500)(PORT = 1521))
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = ExtProc)
> (ORACLE_HOME = d:\ORANT8i)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = devl)
> (ORACLE_HOME = d:\ORANT8i)
> (SID_NAME = devl)
> )
> )
> -------
>
> Any advice anyone?
>
> Thanks, Peter
>
>
Received on Sat Dec 18 1999 - 22:18:37 CET