Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Oracle / Oracle Server / August 2005

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
A Rangers Fan - 31 Aug 2005 23:36 GMT
I seem to be able to connect locally using `sqlplus lee/$password@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 -------------------
A Rangers Fan - 31 Aug 2005 23:42 GMT
Nevermind, isqlplusctl stop/start did the trick.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.