ORA-12224 TNS:no listener

**Teresa Redmond** · Jun 27 '08, 06:21 PM

Re: ORA-12224 TNS:no listener

On Wed, 12 May 2004 01:08:44 -0700, in comp.databases. oracle, Ellen K.
<72322.enno.ess peeayem.1016@co mpuserve.comscr ibbled:

>Hi all,
>
>I'm a developer. While at my current job I've been working with
>mostly SQL Server, now I need to connect to our Oracle Financials
>running on HP-UX. The Oracle DBA set me up as a user and installed
>the Oracle client on my box and I have the tnsnames file, but I still
>can't establish a connection to the database from my development
>environment. .. I'm getting an error message "ORA-12224 TNS:no
>listener".
>
>At a previous company I also had Visual Studio and was able to connect
>to the Oracle databases from it... I want to do the same thing here,
>plus I need to set the Oracle database up as a "linked server" with my
>SQL Servers so I can make distributed transactions. (No heart
>attacks please, I'm going to create a couple of tables on the Oracle
>side and the Oracle DBA will put triggers on them so that whenever I
>insert to them he grabs the data and feeds it to the canned processes
>in OF.)
>
>The Oracle DBA gave me a little utility with a window where I can type
>freehand SQL and get results but not nicely, so I know the connection
>isn't impossible, but I need to be able to address the Oracle database
>programmatical ly. I thought the problem might be related to the fact
>that I don't see the unix box in Network, although I can ping it
>either by name or IP address... the Oracle guy said for me to see it
>in Network he'd have to install something I forget the name of.
>(Something like NFS???) Someone suggested I put an entry in the hosts
>file, which I did, to no avail... although I think it's in the wrong
>place, it's in WINNT\System32\ Drivers\etc. The Oracle guy says he
>thinks the problem is that the MS OLE DB Provider for Oracle doesn't
>know to look in the tnsnames file, but I find that difficult to
>believe. He said maybe somewhere I need to enter a "path" to it...
>(I vaguely remember something about setting paths back in the DOS
>days...)
>
>So anyway, can any of you tell me what to do?
>
>Thanks very much in advance. :)

When connecting to Oracle in Visual Studio, I have to set up a DSN in
Admin Tools | ODBC Data Sources. That may be what you mean in your
last paragraph, that you have set it up there. What language are you
using "programmatical ly"?

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

**Ellen K.** · Jun 27 '08, 06:21 PM

Re: ORA-12224 TNS:no listener

I can certainly try that, but the process of setting up an OLE DB
connection is really quite similar to setting up an ODBC one... if I
use ODBC I'm inserting an extra layer. At the company where I used
Oracle before I was able to define an OLE DB connection. Still, it
can't hurt to try, thanks. :)

On Wed, 12 May 2004 14:51:04 GMT, Teresa Redmond
<XKEAAGIPVIEZ@s pammotel.cowrot e:

>On Wed, 12 May 2004 01:08:44 -0700, in comp.databases. oracle, Ellen K.
><72322.enno.es speeayem.1016@c ompuserve.comsc ribbled:
>

>>Hi all,
>>
>>I'm a developer. While at my current job I've been working with
>>mostly SQL Server, now I need to connect to our Oracle Financials
>>running on HP-UX. The Oracle DBA set me up as a user and installed
>>the Oracle client on my box and I have the tnsnames file, but I still
>>can't establish a connection to the database from my development
>>environment.. . I'm getting an error message "ORA-12224 TNS:no
>>listener".
>>
>>At a previous company I also had Visual Studio and was able to connect
>>to the Oracle databases from it... I want to do the same thing here,
>>plus I need to set the Oracle database up as a "linked server" with my
>>SQL Servers so I can make distributed transactions. (No heart
>>attacks please, I'm going to create a couple of tables on the Oracle
>>side and the Oracle DBA will put triggers on them so that whenever I
>>insert to them he grabs the data and feeds it to the canned processes
>>in OF.)
>>
>>The Oracle DBA gave me a little utility with a window where I can type
>>freehand SQL and get results but not nicely, so I know the connection
>>isn't impossible, but I need to be able to address the Oracle database
>>programmatica lly. I thought the problem might be related to the fact
>>that I don't see the unix box in Network, although I can ping it
>>either by name or IP address... the Oracle guy said for me to see it
>>in Network he'd have to install something I forget the name of.
>>(Something like NFS???) Someone suggested I put an entry in the hosts
>>file, which I did, to no avail... although I think it's in the wrong
>>place, it's in WINNT\System32\ Drivers\etc. The Oracle guy says he
>>thinks the problem is that the MS OLE DB Provider for Oracle doesn't
>>know to look in the tnsnames file, but I find that difficult to
>>believe. He said maybe somewhere I need to enter a "path" to it...
>>(I vaguely remember something about setting paths back in the DOS
>>days...)
>>
>>So anyway, can any of you tell me what to do?
>>
>>Thanks very much in advance. :)

>
>When connecting to Oracle in Visual Studio, I have to set up a DSN in
>Admin Tools | ODBC Data Sources. That may be what you mean in your
>last paragraph, that you have set it up there. What language are you
>using "programmatical ly"?

**Ellen K.** · Jun 27 '08, 06:22 PM

Re: ORA-12224 TNS:no listener

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.

On Wed, 12 May 2004 14:51:04 GMT, Teresa Redmond
<XKEAAGIPVIEZ@s pammotel.cowrot e:

>When connecting to Oracle in Visual Studio, I have to set up a DSN in
>Admin Tools | ODBC Data Sources. That may be what you mean in your
>last paragraph, that you have set it up there. What language are you
>using "programmatical ly"?

**Teresa Redmond** · Jun 27 '08, 06:22 PM

Re: ORA-12224 TNS:no listener

On Fri, 14 May 2004 00:00:10 -0700, in comp.databases. oracle, Ellen K.
<72322.enno.ess peeayem.1016@co mpuserve.comscr ibbled:

>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.conn ectionstring property to set up the connection to
Oracle, and it uses the DSN that I set up in ODBC:

Set cn = New ADODB.Connectio n
cn.CursorLocati on = adUseClient
cn.ConnectionSt ring = "Provider=MSDAO RA.1;" & _
"Password=****; User Id=username;Dat a Source=SourceNa me"
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

**Ellen K.** · Jun 27 '08, 06:22 PM

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@s pammotel.comwro te:

>On Fri, 14 May 2004 00:00:10 -0700, in comp.databases. oracle, Ellen K.
><72322.enno.es speeayem.1016@c ompuserve.comsc ribbled:
>

>>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.con nectionstring property to set up the connection to
>Oracle, and it uses the DSN that I set up in ODBC:
>
Set cn = New ADODB.Connectio n
cn.CursorLocati on = adUseClient
cn.ConnectionSt ring = "Provider=MSDAO RA.1;" & _
"Password=****; User Id=username;Dat a Source=SourceNa me"
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** · Jun 27 '08, 06:22 PM

Re: ORA-12224 TNS:no listener

On Fri, 14 May 2004 10:53:25 -0700, in comp.databases. oracle, Ellen K.
<72322.enno.ess peeayem.1016@co mpuserve.comscr ibbled:

>Thanks for all the info. :)

No problem. I know how frustrating it is to figure out why you're
getting a TNS error! And me with several TNSNAMES files for several
processes running on several computers/servers...

>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.

I seriously recommend using SQL*Net to configure your TNSNAMES, or
whatever the name of your TNSNAMES configuring tool is (that's the
name of what I have). Whenever I've gone in and tried to do anything
with TNSNAMES freehand I tend to get into more trouble, unless I'm
doing something innocuous (for me, anyway) like changing the IP
address of the connection. I got into trouble once because I was
using computer names instead of IP addresses, and when we move to a
new location that was fine, but then the helpdesk people went around
changing everyone's machine names to reflect the location. Boom. No
connection to Oracle. So, now it's all IP based, and I've had to yell
a few times in the past over someone somewhere changing IPs without
telling anyone, but that's "not done" anymore. ;-)

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

ORA-12224 TNS:no listener

ORA-12224 TNS:no listener

Comment

Comment

Comment

Comment

Comment

Comment