Re: ORA-12224 TNS:no listener

Thanks for all the info. :)

Somewhere I have a copy of the Oracle documentation on CD (left over from my previous job), but anyway the Oracle DBA promised me a new one... Really this problem is his responsibility but I'm not one to let grass grow under my feet so I've been trying to find out whatever I can that might help. He did make some modifications to the tnsnames file, which is how we got from the original error to this one.

On Fri, 14 May 2004 15:09:48 GMT, Teresa Redmond <XKEAAGIPVIEZ_at_spammotel.com> wrote:

>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.
Received on Fri May 14 2004 - 19:53:25 CEST