Message from discussion
Oracle 7.3 v 9.2 client connection problems
Path: g2news1.google.com!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail
From: "Rauf Sarwar" <rs_ar...@hotmail.com>
Newsgroups: comp.databases.oracle,comp.databases.oracle.misc
Subject: Re: Oracle 7.3 v 9.2 client connection problems
Date: 8 Apr 2005 18:17:57 -0700
Organization: http://groups.google.com
Lines: 125
Message-ID: <1113009477.096895.58650@g14g2000cwa.googlegroups.com>
References: <1112932195.964386.200910@z14g2000cwz.googlegroups.com>
NNTP-Posting-Host: 195.92.67.75
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1113009488 22585 127.0.0.1 (9 Apr 2005 01:18:08 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sat, 9 Apr 2005 01:18:08 +0000 (UTC)
In-Reply-To: <1112932195.964386.200910@z14g2000cwz.googlegroups.com>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=195.92.67.75;
posting-account=3xsT9QwAAAC3x7TJbwl3Hj0DXQs_bISq
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 =3D
> (DESCRIPTION=3D
> (ADDRESS=3D
> (PROTOCOL=3Dtcp)(PORT=3D1521)(HOST=3Dxxxora2.xxx.xxx.com.au)
> )
> (CONNECT_DATA=3D
> (SID=3Dprod2)
> )
> )
>
> 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\=ADtnsnames.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=3D(CONNECT_DATA=3D(SI=ADD=3D*)(SERVICE_NAME=3Dxxxora2.xxx.=ADx=
xx.com.au))(ADDRESS=3D(PROTOCOL=AD=3DTCP)(HOST=3Dxxxora2.xxx.xxx.com=AD.au)=
(PORT=3D1521)))
>
> 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=3D08004"
"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 =3D
> (DESCRIPTION =3D
> (ADDRESS_LIST =3D
> (FAILOVER =3D ON)
> (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D xxxora2.xxx.xxx.com.au)(PORT
> =3D 1526))
> )
> (CONNECT_DATA=3D
> (SERVICE_NAME =3D prod2)
> (INSTANCE_NAME =3D prod2)
> )
> )
>
> If I now try and create the connection, I get a "Unable to connect"
> "SQLState=3DS1000" "ORA-12705: invalid or unknown NLS parameter value
> specified" error.
>
> I have checked my HKEY_LOCAL_MACHINE\SOFTWARE\OR=ADACLE\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
>
>
> Simon.Cullen...@BHPBilliton.co=ADm 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=2E2.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
|
