Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Linux: Problem using sql*plus to talk to remote databases

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

From: Rupa Schomaker <rupa_at_rupa.com>
Date: Tue, 03 Nov 1998 01:33:20 GMT
Message-Id: <slrn73snb0.quc.rupa@gw.rupa.com>


I don't have tnsnav.ora, but I did copy the relavent lines from tnsnames.ora on the production machines and now when I connect sqlplus crashes and dumps a stack trace. <sigh>

I'll keep "hacking" away.

On Sat, 31 Oct 1998 23:10:30 -0500, A DiMeglio <dimeglio_at_videotron.ca> wrote:

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

--

-rupa Received on Mon Nov 02 1998 - 19:33:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US