Help needed ORA_12514: TNS: listner could not resolve SERVICE

From: Bill Kurani <antrixinc_at_yahoo.com>
Date: 13 Jun 2002 15:46:38 -0700
Message-ID: <99cfe557.0206131446.7af78b29@posting.google.com>

I just installed on windows 2000 orcale 9i. I have spent couple of days solving the problem via online manuals and groups. Any help will be appreciated.

I created the database called ehwdb. My services are up and running.

If I start sqlplus I get popup window with User Name, Password and Host String. I am providing system, manager, mango.

I get Error
ORA_12514: TNS: listner could not resolve SERVICE_NAME given in the connect descriptor.

Here is the listener.ora
LISTENER.ORA Network Configuration File: C:\software\oracle\ora90\network\admin\listener.ora # Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = mango)(PORT = 1521))
      )

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\software\oracle\ora90)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = ehwdb)
(ORACLE_HOME = C:\software\oracle\ora90)
(SID_NAME = ehwdb)

    )
  )

thanks - bill Received on Thu Jun 13 2002 - 17:46:38 CDT

Help needed ORA_12514: TNS: listner could not resolve SERVICE_NAME