472,353 Members | 1,251 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

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.xxx.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=(CONNECT_DATA=(SID=*)(SERVICE_NAME=xx xora2.xxx.xxx.com.au))(ADDRESS=(PROTOCOL=TCP)(HOST =xxxora2.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_MACHINE\SOFTWARE\ORACLE\NLS_LANG value
which is AMERICAN_AMERICA.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.com remove the xxx

Jul 19 '05 #1
4 4723
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
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...
2
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...
2
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...
88
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...
15
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...
7
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...
7
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...
11
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'...
2
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,...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

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.