Re: Cant connect oracle 8 client to oracle7

In article <8nvpd7$h4c$1_at_nnrp1.deja.com>,   rajendra3818_at_my-deja.com wrote:
> I am trying to connect to oracle7 (7.3.4) server running on
> sco unix from Oracle8.0.5 running on linux.
> I get ora-12505 error.
> On the server side, the listner.log file says connection
> established.
> my tnsnames.ora (on linux) is as follows:
> SCOMACHINE.BOGUS.COM =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL=TCP)(HOST=10.14.2.9)(PORT=1521))
> (CONNECT_DATA=(SID=WG73))
> )
> when I try sqlplus scott/tiger_at_SCOMACHINE.BOGUS.COM
> I get the above error.
> The listener log file on SCO UNIX shows everything is Ok
> The sqlnet.log file on linux machine shows the following:
> TNS-12204 TNS recieved data refused from an application
> TNS-12564 TNS: connection refused.
> The listener.log file on oracle7 server machine( sco unix ) says
> connection established.
> What are the possible causes for this "connection refused".
> Please help me in overcoming these problmes.
> Thanks in advance
> Rajendra
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Oracle is downwards compatible, not upwards compatible. This means you can use V7/sqlnet 2 software to connect to Oracle 8, however the other way around should not necessarily work.

Sorry,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.