473,216 Members | 1,507 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,216 software developers and data experts.

can't connect to Oracle

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
4 5164
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
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
>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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: David | last post by:
Hello all, I have been trying to use the OCI driver to connect to Oracle 9i, but have been getting the following error: java.sql.SQLException: Closed Connection at...
1
by: CM | last post by:
Hi, when i want connect me in my BD with a JSP (with this simple code), this exception is throw. Thank's for ur help Mathieu CODE of my JSP ---------------------
2
by: baumann.Pan | last post by:
hi all, I am programming on linux, my program want to connect a oracle database server to do some SQL statement/procedure. But I don't know how to connect to oracle database on linux OS. anyone...
5
by: jrefactors | last post by:
My machine is Windows XP with Oracle 9.2 Home; IIS and Oracle are in the same box. I have tried both Oracle OLEDB Provider and Microsoft ODBC For Oracle, but both not working. For Microsoft...
5
by: Kona | last post by:
Hello, Is it right to tell that DB2 Connect has the same function that Oracle Net ? If I have an ODBC application is it also right to tell that I have 2 possibilities on my client workstation to...
1
by: Yanick Quirion | last post by:
Hi all, I'm trying to find a simple code to connect to an Oracle Database (9i) with C under linux. I have a script that read a form from the web and I want to access my Oracle database with...
8
by: danbredy | last post by:
Hi, I'm attempting to connect to an Oracle database using SQL Server 2005 Express (OS is Windows XP Professional) and having absolutely no luck. Here is the information SQL Plus gives me about...
0
by: Francois Stander | last post by:
Hi, I am struggeling to connect to an Oracle db 10.2 through vb.net. Oracle client is installed on my maschine, Oracle.DataAccess in referenced in my app. this is how my code looks like: Dim...
3
by: Alv | last post by:
I need a solution how to connect 2 oracle databases using DBLink. Oracle is installed for Linux. It is working properly when I connect from the Oracle for Windows to Oracle for Linux, but there is a...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.