473,695 Members | 1,723 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Oracle 7.3 v 9.2 client connection problems

Tig
Hi all.
I have a need to connect to an Oracle 7.3.3.5 database. I have a user
who successfully connects to it with her Oracle 7.3 client. I have an
Oracle 9.2 client installed on my machine.

I had her send me her tnsnames.ora from her PC. The entry I wanted was
as follows (some letters replaced with xxx for security reasons):

xxxora2_prod2 =
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=tcp)( PORT=1521)(HOST =xxxora2.xxx.xx x.com.au)
)
(CONNECT_DATA=
(SID=prod2)
)
)

She has an ODBC connection using her Ora 73 client drivers which works
fine.

I then add the same entry to my
C:\oracle\ora92 \network\ADMIN\ *tnsnames.ora file.

Now if I ping this hostname, it works fine.

If I tnsping this hostname it also works fine - see below:

Used HOSTNAME adapter to resolve the alias
Attempting to contact
(DESCRIPTION=(C ONNECT_DATA=(SI *D=*)(SERVICE_N AME=xxxora2.xxx .*xxx.com.au))( ADDRESS=(PROTOC OL*=TCP)(HOST=x xxora2.xxx.xxx. com*.au)(PORT=1 521)))

OK (70 msec)

If I try and tnsping the tnsname, however, I get an error:

TNS-03505: Failed to resolve name

And if I then try and create an ODBC connection using my client I get a
short wait and then an "Unable to connect" "SQLState=08004 " "ORA-12154:
TNS:could not resolve service name" error.

The existing entries in my (9.2 client) tnsnames.ora don't have a SID,
they have a SERVICE_NAME. So I change mine from SID to SERVICE_NAME.
My file now looks like this:

xxxora2_prod2 =
(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxora2.xxx.xxx .com.au)(PORT
= 1526))
)
(CONNECT_DATA=
(SERVICE_NAME = prod2)
(INSTANCE_NAME = prod2)
)
)

If I now try and create the connection, I get a "Unable to connect"
"SQLState=S1000 " "ORA-12705: invalid or unknown NLS parameter value
specified" error.

I have checked my HKEY_LOCAL_MACH INE\SOFTWARE\OR *ACLE\NLS_LANG value
which is AMERICAN_AMERIC A.WE8ISO8859P1 so that looks OK.

Does anyone have any ideas?? I am a developer not a DBA and haven't
played with Oracle clients for years.

If I change the port number to 1521 and try again I get a "ORA-12514:
TNS:listener could not resolve SERVICE_NAME given in connect
descriptor" error, but I am just clutching at straws now.

Thanks!
Simon Cullen
Australia
Simon.Cullen... @BHPBilliton.co *m remove the xxx

Jul 19 '05 #1
4 16835
"Tig" <Si**********@B HPBilliton.com> wrote in
news:11******** **************@ z14g2000cwz.goo glegroups.com:
Hi all.
I have a need to connect to an Oracle 7.3.3.5 database. I have a user
who successfully connects to it with her Oracle 7.3 client. I have an
Oracle 9.2 client installed on my machine.

I had her send me her tnsnames.ora from her PC. The entry I wanted
was as follows (some letters replaced with xxx for security reasons):

xxxora2_prod2 (DESCRIPTION (ADDRESS
(PROTOCOL=tcp)( PORT=1521)(HOST =xxxora2.xxx.xx x.com.au)
)
(CONNECT_DATA (SID=prod2)
)
)

She has an ODBC connection using her Ora 73 client drivers which works
fine.

I then add the same entry to my
C:\oracle\ora92 \network\ADMIN\ *tnsnames.ora file.

Now if I ping this hostname, it works fine.

If I tnsping this hostname it also works fine - see below:

Used HOSTNAME adapter to resolve the alias
Attempting to contact
(DESCRIPTION=(C ONNECT_DATA=(SI *D=*)(SERVICE_N AME=xxxora2.xxx .*xxx.com.a
u))(ADDRESS=(PR OTOCOL*=TCP)(HO ST=xxxora2.xxx. xxx.com*.au)(PO RT=1521)))

OK (70 msec)

If I try and tnsping the tnsname, however, I get an error:

TNS-03505: Failed to resolve name

And if I then try and create an ODBC connection using my client I get
a short wait and then an "Unable to connect" "SQLState=08004 "
"ORA-12154: TNS:could not resolve service name" error.

The existing entries in my (9.2 client) tnsnames.ora don't have a SID,
they have a SERVICE_NAME. So I change mine from SID to SERVICE_NAME.
My file now looks like this:

xxxora2_prod2 (DESCRIPTION (ADDRESS_LIST (FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxora2.xxx.xxx .com.au)(PORT
= 1526))
)
(CONNECT_DATA (SERVICE_NAME = prod2)
(INSTANCE_NAME = prod2)
)
)

If I now try and create the connection, I get a "Unable to connect"
"SQLState=S1000 " "ORA-12705: invalid or unknown NLS parameter value
specified" error.

I have checked my HKEY_LOCAL_MACH INE\SOFTWARE\OR *ACLE\NLS_LANG value
which is AMERICAN_AMERIC A.WE8ISO8859P1 so that looks OK.

Does anyone have any ideas?? I am a developer not a DBA and haven't
played with Oracle clients for years.

If I change the port number to 1521 and try again I get a "ORA-12514:
TNS:listener could not resolve SERVICE_NAME given in connect
descriptor" error, but I am just clutching at straws now.

Thanks!
Simon Cullen
Australia
Simon.Cullen... @BHPBilliton.co *m remove the xxx


V7.3 does NOT interoperate with V9.2. Period. End of statement.
V8.1.7 or V9.0 client s/w can inter-operate with all the above.
Jul 19 '05 #2

Tig wrote:
Hi all.
I have a need to connect to an Oracle 7.3.3.5 database. I have a user who successfully connects to it with her Oracle 7.3 client. I have an
Oracle 9.2 client installed on my machine.

I had her send me her tnsnames.ora from her PC. The entry I wanted was as follows (some letters replaced with xxx for security reasons):

xxxora2_prod2 =
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=tcp)( PORT=1521)(HOST =xxxora2.xxx.xx x.com.au)
)
(CONNECT_DATA=
(SID=prod2)
)
)

She has an ODBC connection using her Ora 73 client drivers which works fine.

I then add the same entry to my
C:\oracle\ora92 \network\ADMIN\ *tnsnames.ora file.

Now if I ping this hostname, it works fine.

If I tnsping this hostname it also works fine - see below:

Used HOSTNAME adapter to resolve the alias
Attempting to contact
(DESCRIPTION=(C ONNECT_DATA=(SI *D=*)(SERVICE_N AME=xxxora2.xxx .*xxx.com.au))( ADDRESS=(PROTOC OL*=TCP)(HOST=x xxora2.xxx.xxx. com*.au)(PORT=1 521)))
OK (70 msec)

If I try and tnsping the tnsname, however, I get an error:

TNS-03505: Failed to resolve name

And if I then try and create an ODBC connection using my client I get a short wait and then an "Unable to connect" "SQLState=08004 " "ORA-12154: TNS:could not resolve service name" error.

The existing entries in my (9.2 client) tnsnames.ora don't have a SID, they have a SERVICE_NAME. So I change mine from SID to SERVICE_NAME.
My file now looks like this:

xxxora2_prod2 =
(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxora2.xxx.xxx .com.au)(PORT
= 1526))
)
(CONNECT_DATA=
(SERVICE_NAME = prod2)
(INSTANCE_NAME = prod2)
)
)

If I now try and create the connection, I get a "Unable to connect"
"SQLState=S1000 " "ORA-12705: invalid or unknown NLS parameter value
specified" error.

I have checked my HKEY_LOCAL_MACH INE\SOFTWARE\OR *ACLE\NLS_LANG value
which is AMERICAN_AMERIC A.WE8ISO8859P1 so that looks OK.

Does anyone have any ideas?? I am a developer not a DBA and haven't
played with Oracle clients for years.

If I change the port number to 1521 and try again I get a "ORA-12514:
TNS:listener could not resolve SERVICE_NAME given in connect
descriptor" error, but I am just clutching at straws now.

Thanks!
Simon Cullen
Australia
Simon.Cullen... @BHPBilliton.co *m remove the xxx


We have an old server with 7.3.4 that we keep around for testing. You
are in a no win situation... you won't be able to connect to 7.3.x from
9.2.x client.

Here is an attempt using 9.2 client:
SQL*Plus: Release 9.2.0.5.0 - Production on Fri Apr 8 08:45:27 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect system/oracle@L73
ERROR:
ORA-24439: Connections to Oracle7 server are no longer supported

SQL> exit

Here is an attempt using 8.1.x client:
SQL*Plus: Release 8.1.7.0.0 - Production on Fri Apr 8 08:45:37 2005

(c) Copyright 2000 Oracle Corporation. All rights reserved.

SQL> connect system/oracle@L73
Connected.
SQL> exit
Disconnected from Oracle7 Server Release 7.3.4.0.0 - Production
With the distributed, replication and parallel query options
PL/SQL Release 2.3.4.0.0 - Production

C:\>

Regards
/Rauf

Jul 19 '05 #3
Tig
Thank you Rauf. Yes, it appears that as you said it is an Oracle
support issue, and I "won't be able to connect to 7.3.x from 9.2.x
client".

I got this from the Oracle site:
"However, since Oracle 7.3.4 was desupported before Oracle9i Release 2
(9.2) was released, 9.2 does not support Oracle 7.3.4."
So in spite of the fact that there are tens of thousands of productive
Oracle 7.3.x servers out there in commercial usage, Oracle doesn't
think anyone would want to connect to them. :( And yes, I know 7.3.x
is old now.

I do have an Oracle 7.3 client on the PC provided to me here, but it
looks as though the Oracle 9.2 client clobbered it, so I will get the
7.3 client re-installed. This should fix the problem. I don't need the
Oracle 9.2 client at the moment so I will get rid of it. Supposedly the
two clients should co-exist happily but I guess I won't try that until
i have a need for it.

Thanks,
Simon

Rauf Sarwar wrote:
Tig wrote:
Hi all.
I have a need to connect to an Oracle 7.3.3.5 database. I have a user who successfully connects to it with her Oracle 7.3 client. I have an Oracle 9.2 client installed on my machine.

We have an old server with 7.3.4 that we keep around for testing. You
are in a no win situation... you won't be able to connect to 7.3.x

from 9.2.x client.

ERROR:
ORA-24439: Connections to Oracle7 server are no longer supported

Regards
/Rauf


Jul 19 '05 #4
Tig
Thank you Rauf. Yes, it appears that as you said it is an Oracle
support issue, and I "won't be able to connect to 7.3.x from 9.2.x
client".

I got this from the Oracle site:
"However, since Oracle 7.3.4 was desupported before Oracle9i Release 2
(9.2) was released, 9.2 does not support Oracle 7.3.4."
So in spite of the fact that there are tens of thousands of productive
Oracle 7.3.x servers out there in commercial usage, Oracle doesn't
think anyone would want to connect to them. :( And yes, I know 7.3.x
is old now.

I do have an Oracle 7.3 client on the PC provided to me here, but it
looks as though the Oracle 9.2 client clobbered it, so I will get the
7.3 client re-installed. This should fix the problem. I don't need the
Oracle 9.2 client at the moment so I will get rid of it. Supposedly the
two clients should co-exist happily but I guess I won't try that until
i have a need for it.

Thanks,
Simon

Rauf Sarwar wrote:
Tig wrote:
Hi all.
I have a need to connect to an Oracle 7.3.3.5 database. I have a
user
who successfully connects to it with her Oracle 7.3 client. I have
an
Oracle 9.2 client installed on my machine.

We have an old server with 7.3.4 that we keep around for testing. You
are in a no win situation... you won't be able to connect to 7.3.x
from
9.2.x client.

ERROR:
ORA-24439: Connections to Oracle7 server are no longer supported

Regards
/Rauf
Jun 27 '08 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3705
by: jayPLEASEtylerNOwilliamsSPAM | last post by:
Hi, I set up PHP 4.xx using Apache 1.3 on Windows XP to begin a project. The project now needs to be moved to a real test box. Admittedly, I am not quite sure how I was able to access Oracle on my machine, but I know I have the Oracle client installed, have two odbc DSNs (CAI/PT Oracle 8) installed and uncommented php_oci8.dll and php_oracle.dll. Other than that, I kind of just played around until it worked. Now my code needs to be...
5
102538
by: SerGioGio | last post by:
Hello, I am going nuts. I am trying to connect to my local ORACLE instance using ODBC. It used to work few weeks ago, but it fails now. Connection with: - SQL*plus: connection works! - DataDirect 5.0 Oracle Wire protocol (3rd party ODBC driver): connection works when I hit the driver's "test connection"
4
5206
by: Ellen K. | last post by:
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...
0
3087
by: kamil | last post by:
Hi , Iíam having the following strange situation. First let me explain the configuration: Windows 2000 server with sql-server and running reportingservices. HP9000 Unix server with oracle 9i database Iíve installed oracle client client tools on the W2K server and
9
17023
by: mcbill20 | last post by:
Hello all. I just installed Oracle 10g developer tools on a machine running XP Pro and Office XP. Before this I had just the Oracle 9 client installed. I the previous configuration, I was able to access any of the Oracle tables on another machine but now I am having problems. Unfortunately, I don't remember the correct syntax for the ODBC connect string and I am hoping that is my whole problem. I am trying to connect to an Oracle 9...
9
2409
by: D. Patrick | last post by:
I need to connect to an Oracle database. I've never done it before. I see that with framework 1.1 you had to download ODP.NET from Oracle's site in order for the framework classes to even work. I tried that quickly, but the file is 400 MB, and the the installation asks for all kinds of things in order to install. Now I'm very confused. a) Do you still need ODP.NET with framework 2.0? b) Do you need to download and install other...
16
9183
by: network-admin | last post by:
We have Problems with Access query on Oracle 10g Database with ODBC Connection. The Query_1 is such as select * from xtable where ycolumn <"S" Result = ODBC Faild ----------------------------------------------------
0
1650
by: Harshadcode | last post by:
Hi, This is HARSHAD, I am creating a project in VB.NET for managing details like photos of criminals. but i am facing problems in converting a image in to filestream so that it can be inserted in to the oracle 10g database using BLOB variable type. if you can help me it will be very helpful.. This is my code: --------------------------------------------------------------------- Imports System
0
2605
by: | last post by:
Hi All, I have a client connection problem with Oracle. The exe which i did with C# (vs.net 2005) and Oracle XE , works well on my developer machine but i am getting a connection string error on the client side. The error comes from System.Exception class not from OracleException. The properties of the Oracle.DataAccess reference are ; Description: Oracle.DataAccess.dll
0
8623
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
8565
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9113
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8977
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8839
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8822
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
4577
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2997
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2269
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.