By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,467 Members | 1,308 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,467 IT Pros & Developers. It's quick & easy.

ORA 7.3 v 9.2 client conneection problems

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.