Re: Help needed ORA_12514: TNS: listner could not resolve SERVICE_NAME

antrixinc_at_yahoo.com (Bill Kurani) wrote in message news:<99cfe557.0206131446.7af78b29_at_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

Hi Bill

make sure that your tnsname is configured correctly. It means that the tnsname contains some lines like this

ehwdb =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = <ip of host>)(PORT = 1521))     )
    (CONNECT_DATA =
      (SID = ehwdb)
    )
  )

with the tnsnames file oracle resolve the service-name an connects you to a specific database

Make sure that you have access to the Host that runs the oracle servers (simply use ping)

regards
thomas Received on Fri Jun 14 2002 - 02:30:15 CDT