Re: ORA-12224 TNS:no listener

On Fri, 14 May 2004 00:00:10 -0700, in comp.databases.oracle, Ellen K. <72322.enno.esspeeayem.1016_at_compuserve.com> scribbled:

>Just for the record, although I didn't expect it to work, I tried
>setting up a DNS. It didn't work.
>
>We now have a new error (I think this is progress), 12514, it can't
>find RDBMS80.

This is the error message on OTN:

TNS-12514 TNS:listener could not resolve SERVICE_NAME given in connect descriptor

Cause: The SERVICE_NAME in the CONNECT_DATA was not found in the listener's tables.

Action: Check to make sure that the SERVICE_NAME specified is correct.

You might want to check your TNSNAMES.ora file to make sure the information for RDBMS80 is correct: or if it is missing. That would be my first shot after seeing this message.

Also, I find this link to be invaluable:

<http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76999/toc.htm>

It's the error message TOC for Oracle 8i, which I am running. Any time I get an error, that's where I go first. I had to go two links in to find your error above, but I find this site to be very easy to use. Sometimes the message is not necessarily the issue, but it can point you in the right direction.

Also, here's what I do in my VB code to connect. I use the connection.connectionstring property to set up the connection to Oracle, and it uses the DSN that I set up in ODBC:

  Set cn = New ADODB.Connection
  cn.CursorLocation = adUseClient
  cn.ConnectionString = "Provider=MSDAORA.1;" & _

      "Password=****;User Id=username;Data Source=SourceName"   cn.Open

The DSN I set up is MS ODBC for Oracle, the name is SourceName just like in my string above, and the server information I use is the IP address of the machine I'm accessing.

I don't know if this will help, it may be stuff you've already done, but it just may give you an idea of where I'm coming from in my thoughts and maybe help you.

-- 
Teresa Redmond
Programmer/Analyst III
Anteon Corporation
tredmond at anteon dot com