Re: Cant connect oracle 8 client to oracle7

Hi,

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.

Should work although the Net8 implementation for Linux is buggy (at least in 8.0.5).

> 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.

I had a similar problem while connecting from Linux to a Solaris 7.3.4 server. The problem became clearer after increasing the verbosity level in sqlnet.ora on the client.

This gave me insight to the actual error codes emerging in deeper levels of Net8. I was able to find them via deja.com and found out thet I should set the parameter disable_oob=true in sqlnet.ora. But I wonder if this will help in your case.

If you have a support contract with Oracle, do contact them.

Uwe

-- 
Uwe Schneider - WEB.DE AG - Amalienbadstr. 41 - 76227 Karlsruhe 
Forschung & Entwicklung - Tel. (+49) 721 94329 832
"In a world without walls and fences, who needs windows and gates?"