can't connect to Oracle

[Ellen K.]

Hi all,

Being that so far I didn't get an answer to my below problem on the
Oracle newsgroup, I figured it couldn't hurt to try here.

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
programmatically. 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. :)

[Daniel Morgan]

Ellen K. wrote:

Hi all,

Being that so far I didn't get an answer to my below problem on the
Oracle newsgroup, I figured it couldn't hurt to try here.

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
programmatically. 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. :)

Why would you think anyone could answer your question anywhere?

What version of Oracle?
What hardware platform and operating is it running on?
What operating system are you running?
Can you ping the Oracle server?
An ORA-12224 could have been investigated at www.google.com with ease

And you would have found that the problem is that you have not properly
configured the environment variables oracle_home, oracle_sid and/or the
files sqlnet.ora and tnsnames.ora

Did you read the installation and configuration documentation or did you
just stick the CD into the drive? My guess is that you can't even ping
the server.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

[Ellen K.]

Oracle 8.0something, it is on HP-UX (mentioned in my original post),
client is W2K (Windows something was obvious from the fact that I
mentioned wanting to access Oracle from Visual Studio), yes I can ping
the Oracle server either by name or IP address (also mentioned in my
original post). What I found on google didn't help.

Configuring the environment etc ain't my responsibility, we have an
Oracle DBA... also mentioned in my original post.

And I never touched the CD, the Oracle DBA did it.

So anyway, not only your guess, but most of your allegations, are
wrong.

The Oracle DBA made some modifications to the tnsnames file and did
some other stuff and now 12224 went away and we have 12514 claiming it
can't find RDBMS80.

This is beyond ridiculous, I can set up a user on any of my SQL Server
boxes in less than a minute, including defining all their permissions.

On Thu, 13 May 2004 20:01:32 -0700, Daniel Morgan
<da******@x.washington.edu> wrote:

Why would you think anyone could answer your question anywhere?

What version of Oracle?
What hardware platform and operating is it running on?
What operating system are you running?
Can you ping the Oracle server?
An ORA-12224 could have been investigated at www.google.com with ease

And you would have found that the problem is that you have not properly
configured the environment variables oracle_home, oracle_sid and/or the
files sqlnet.ora and tnsnames.ora

Did you read the installation and configuration documentation or did you
just stick the CD into the drive? My guess is that you can't even ping
the server.

[Onlynews]

>The Oracle DBA gave me a little utility with a window where I can type

freehand SQL and get results but not nicely
So it's working fine, right? The Oracle tools are talking to the Oracle
database.
I still can't establish a
connection to the database from my development environment
Try asking in a development newsgroup - your oracle is running fine, it;s
your development tool that is not happy.
This is beyond ridiculous, I can set up a user on any of my SQL Server
boxes in less than a minute, including defining all their permissions.
Yes, I have heard the MS-ACCESS is even simpler! Try getting your finance
department to switch to that and your life will be much easier.

Certainly much easier than reading book, or researching the problem with
your development environment.

JON

P.S. It's probably in your connect string, most likely not matching up
exactly with what is defined in the tnsnames file. Add a 2nd entry tnsnames
that is a clone of the first, but with the domain name after it, i.e. just
dbname, not dbname.server.facility.org. Who knows what weird string your
development environment is appending to the connect string.
"Ellen K." <72************************@compuserve.com> wrote in message
news:ad********************************@4ax.com... Hi all,

Being that so far I didn't get an answer to my below problem on the
Oracle newsgroup, I figured it couldn't hurt to try here.

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
programmatically. 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. :)

[Ellen K.]

Considering that I had zero problems connecting to MULTIPLE Oracle
databases from VisualStudio at my previous job, I think it's safe to
say the problem is not with VisualStudio.

The Oracle DBA modified the tnsnames file and the result was that the
listener is now found, but not RDBMS80. I will pass on your
suggestion about the additional entry.

On Fri, 14 May 2004 18:39:23 GMT, "Onlynews"
<jo********@email.uophx.edu> wrote:

The Oracle DBA gave me a little utility with a window where I can type
freehand SQL and get results but not nicely

So it's working fine, right? The Oracle tools are talking to the Oracle
database.

I still can't establish a
connection to the database from my development environment

Try asking in a development newsgroup - your oracle is running fine, it;s
your development tool that is not happy.

This is beyond ridiculous, I can set up a user on any of my SQL Server
boxes in less than a minute, including defining all their permissions.

Yes, I have heard the MS-ACCESS is even simpler! Try getting your finance
department to switch to that and your life will be much easier.

Certainly much easier than reading book, or researching the problem with
your development environment.

JON

P.S. It's probably in your connect string, most likely not matching up
exactly with what is defined in the tnsnames file. Add a 2nd entry tnsnames
that is a clone of the first, but with the domain name after it, i.e. just
dbname, not dbname.server.facility.org. Who knows what weird string your
development environment is appending to the connect string.
"Ellen K." <72************************@compuserve.com> wrote in message
news:ad********************************@4ax.com.. .

Hi all,

Being that so far I didn't get an answer to my below problem on the
Oracle newsgroup, I figured it couldn't hurt to try here.

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
programmatically. 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. :)