ORA-12224 TNS:no listener

[Ellen K.]

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
programmaticall y. 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. :)

[Teresa Redmond]

On Wed, 12 May 2004 01:08:44 -0700, in comp.databases. oracle, Ellen K.
<72************ ************@co mpuserve.com> scribbled:

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

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
<XK**********@s pammotel.co> wrote:

On Wed, 12 May 2004 01:08:44 -0700, in comp.databases. oracle, Ellen K.
<72*********** *************@c ompuserve.com> scribbled:

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

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
<XK**********@s pammotel.co> wrote:

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]

On Fri, 14 May 2004 00:00:10 -0700, in comp.databases. oracle, Ellen K.
<72************ ************@co mpuserve.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.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.]

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
<XK**********@s pammotel.com> wrote:

On Fri, 14 May 2004 00:00:10 -0700, in comp.databases. oracle, Ellen K.
<72*********** *************@c ompuserve.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.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]

On Fri, 14 May 2004 10:53:25 -0700, in comp.databases. oracle, Ellen K.
<72************ ************@co mpuserve.com> scribbled:

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