local 8i db on nt - tnsnames error

From: Peter Hewson <phew_at_ozemail.com.au>
Date: Sun, 19 Dec 1999 00:43:48 +0800
Message-ID: <385BB9C4.622BC0D0_at_ozemail.com.au>

Hi,

[Quoted] [Quoted] 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 =
[Quoted] (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 - 17:43:48 CET