473,574 Members | 2,661 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ORA 7.3 v 9.2 client conneection 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=1526)(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 works fine.

Used HOSTNAME adapter to resolve the alias
Attempting to contact
(DESCRIPTION=(C ONNECT_DATA=(SI D=*)(SERVICE_NA ME=xxxora2.xxx. xxx.com.au))(AD DRESS=(PROTOCOL =TCP)(HOST=xxxo ra2.xxx.xxx.com .au)(PORT=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

Si************* @BHPBilliton.co m remove the xxx

Jul 19 '05 #1
4 4807
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.


STOP reading... bzz, twink!
7.3.3 was a non-version anyway, and obsoleted long ago, in the previous
century... I don't want to know what excuse you have, upgrade!
At least to the last version 7.

Do you think a network component of 4 MAJOR versions later
is compatible? Well it's not.

Apart from that - check your ports (you mention 1526 in the 7.3
environment - a remnant of SQL*Net V1, yet have 1521 specified)
And next time, post the actual commands - you just yab something
doesn't work, but we are not clearvoyant.
TNSPING may fail to resolve the name when your sqlnet has
a default domain - we don't know, as you don't tell us.

And don't get smart and start changing SID into SERVICE_NAME;
Oracle 7.3 doesn't understand that.
--
Regards,
Frank van Bortel
Jul 19 '05 #2
Are you attempting to utilizing SQLPLUS to connect to your database?
If so the client for 9.2 will not connect to the 7.3 database. You can
install multiple oracle clients on your desktop.

Ken Martin
km****@comcast. net

Jul 19 '05 #3
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.
STOP reading... bzz, twink!
7.3.3 was a non-version anyway, and obsoleted long ago, in the previous
century... I don't want to know what excuse you have, upgrade!
At least to the last version 7.

Do you think a network component of 4 MAJOR versions later
is compatible? Well it's not.

Apart from that - check your ports (you mention 1526 in the 7.3
environment - a remnant of SQL*Net V1, yet have 1521 specified)
And next time, post the actual commands - you just yab something
doesn't work, but we are not clearvoyant.
TNSPING may fail to resolve the name when your sqlnet has
a default domain - we don't know, as you don't tell us.

And don't get smart and start changing SID into SERVICE_NAME;
Oracle 7.3 doesn't understand that.
--
Regards,
Frank van Bortel
Jun 27 '08 #4
Are you attempting to utilizing SQLPLUS to connect to your database?
If so the client for 9.2 will not connect to the 7.3 database. You can
install multiple oracle clients on your desktop.

Ken Martin
km****@comcast. net

Jun 27 '08 #5

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

Similar topics

1
14791
by: Stephane VUILLIN | last post by:
Hi, I read a lot of threads about Oracle8i Client 8.1.7 installation. I did not succeed to install this product on a Pentium 4 Windows NT workstation. I downloaded the patch number 1507768 from metalink. The installation failed too. I downloaded a SUN JRE 1.1.8.16 from SUN archives products. Same result : installation failed. I did not...
2
2512
by: news.microsoft.com | last post by:
Hi I write dll library which one of it component will be Net socket communication. Communication is working very good, but i've got problem when client is connecting. When server is started, client is connecting without problems; but when servre is down and i start client, client connect to server! Few lines from code: client.Socket =...
2
2394
by: Microsoft | last post by:
I'm about to start converting my application from a old-style monolith exe (with flat files and limited database support for sharing some of the data) to a layered .NET SQL server version. I have decided to do it as a Windows Forms client application, hooking up to a central SQL Server, and then maybe later create an asp version of the client...
88
12391
by: Mike | last post by:
Is there a way to determine what a user's default email client is? I read a post from 3 years ago that said no. I guess I'm hoping something has come along since then.
15
4462
by: Michael Rybak | last post by:
hi, everyone. I'm writing a 2-players game that should support network mode. I'm now testing it on 1 PC since I don't have 2. I directly use sockets, and both client and server do computations, the only data transfered is user mouse/kbd input. It works synchronously, but somehow, when I play in client window, both client and ...
7
7093
by: David Laub | last post by:
I've also posted this issue to a Sun/java formum, but since it appears to be an integration issue, this may be the better place to posr: I have written a dot net/c# Web Services doesn't fully work with J2ME client a) c# web service works with c# WIndows Client (local & remote web service) b) c# web service works with J2ME client - when the...
7
1537
by: rob | last post by:
I want to create an application that can be used both for a server-client model as well as a standalong application. The idea is to write a general server-client application. The standalong then just has both components on the same system. Now the question is if this is a good approach or if this is even doable. For instance do web services...
11
4200
by: pshindle | last post by:
We have several machines currently running the DB2 V7 Run-time Client that we would like to actually be running the App Dev Client. To 'upgrade' (within the same version) this client software can we simply install the App Dev Client on 'top of' the Run-time Client? Will the install routine uninstall the Run-time Client under the covers...
2
2841
by: Johan | last post by:
We have run into problems calling a web service from a client running .NET framework 2.0. The problem is that the first call to the web service, after the client has been started, takes very long time, something like 15 to 30 seconds. All subsequent calls are really fast (about 10 milliseconds). But when the client is restarted, the first call...
0
7814
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...
0
7736
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...
0
8067
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. ...
1
7826
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...
0
6464
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5307
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3756
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1352
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1071
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.