467,213 Members | 1,096 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,213 developers. It's quick & easy.

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
  • viewed: 4519
Share:
4 Replies
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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Stephane VUILLIN | last post: by
2 posts views Thread by news.microsoft.com | last post: by
2 posts views Thread by Microsoft | last post: by
15 posts views Thread by Michael Rybak | last post: by
7 posts views Thread by rob | last post: by
11 posts views Thread by pshindle@comcast.net | last post: by
2 posts views Thread by Johan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.