Re: Linux: Problem using sql*plus to talk to remote databases

Yo,

I'm not sure what you mean exactly but I just installed Oracle8 on linux and I CAN connect to external Oracle databases located on other servers on our Inter/Intranet using SQL*PLUS on the linux box. I do this by setting the TNSNAMES.ORA, the TNSNAV.ORA to be the same as the ones on the other system, then, I added what I needed to make it work with my local DB. So, I guess, it can be done. Look in "your oracle home"/Network/Admin.

I am using Net8 on a 7.3 database and, of course, my new Oracle8 on Linux database.

Oracle rules.

dimeglio_at_spam.sucks.videotron.ca <- remove spam.sucks

>On Sat, 31 Oct 1998 19:44:29 +0000, Mourad Veeneman
><mourad_at_speed.a2000.nl> wrote:
>>Rupa,
>>
>>I've had exactly the same problem on my Linux box
>>running SQL*Plus 8.0.5.0.0 connecting to a remote
>>Oracle Server 7.3.2.3.0.
>>After reinstalling only the client,SQL*Net TCP/IP
>>and SQL*Plus is miraculously worked! But as soon
>>as I tried to install anything more it stopped
>>working.
>>My guess is that there is a bug with the client trying
>>to negotiate some advanced Oracle 8 features with an
>>Oracle 7 Server. I'm sure other Linux users must have
>>experienced the same.
>>I might be wrong ofcourse, but my Perl DBD-Oracle on
>>Linux works fine now and I'm not touching it!
>>
>>Cheers,
>>
>>Mourad
Received on Sat Oct 31 1998 - 22:10:30 CST