local 8i db on nt - tnsnames error

From: Peter Hewson <phew_at_ozemail.com.au>
Date: Sun, 19 Dec 1999 00:45:02 +0800
Message-ID: <385BBA0E.AFEB88EC@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 - 10:45:02 CST