Re: Oracle 7.3 v 9.2 client connection problems

"Tig" <Simon.Cullen_at_BHPBilliton.com> wrote in news:1112932195.964386.200910_at_z14g2000cwz.googlegroups.com:

> 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=1521)(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 also works fine - see below:
>
> Used HOSTNAME adapter to resolve the alias
> Attempting to contact
> (DESCRIPTION=(CONNECT_DATA=(SI­D=*)(SERVICE_NAME=xxxora2.xxx.­xxx.com.a
> u))(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))

V7.3 does NOT interoperate with V9.2. Period. End of statement. V8.1.7 or V9.0 client s/w can inter-operate with all the above. Received on Fri Apr 08 2005 - 16:28:31 CEST