iSQL*Plus Problem - ORA-12162: TNS:net service name is incorrectly specified

From: Lee <leereilly_at_gmail.com>
Date: 31 Aug 2005 15:34:25 -0700
Message-ID: <1125527665.207158.106440@o13g2000cwo.googlegroups.com>

I seem to be able to connect locally using `sqlplus lee/$password_at_lee3` using SQL*Plus, but I get the following error when I use iSQL*Plus:

   ORA-12162: TNS:net service name is incorrectly specified

I've seen plenty of similar posts on Google, but none of them have shed any light on the matter. My TNSNAME and LISTENER files are shown below... can anyone tell me where the problem lies?

• BEGIN TNSNAMES.ORA ------------------- LEE3 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = metal)(PORT = 1521)) (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = lee3)
  ) )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

--- END TNSNAMES.ORA -------------------


--- BEGIN LISTENER.ORA -------------------

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /metal0/app/oracle/product/10.2.0/Db_1)
(PROGRAM = extproc)

    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = metal)(PORT = 1521))
    )
  )

• END LISTENER.ORA -------------------

Received on Wed Aug 31 2005 - 17:34:25 CDT