By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,583 Members | 1,051 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,583 IT Pros & Developers. It's quick & easy.

can't connect to Oracle

P: n/a
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. :)
Jul 20 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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)

Jul 20 '05 #2

P: n/a
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.


Jul 20 '05 #3

P: n/a
>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. :)

Jul 20 '05 #4

P: n/a
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. :)


Jul 20 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.