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

Home -> Community -> Usenet -> c.d.o.tools -> Re: 8.0.5 client -> 7.3.4 server connect from svrmgrl works, from sqlplus and perl doesnt

Re: 8.0.5 client -> 7.3.4 server connect from svrmgrl works, from sqlplus and perl doesnt

From: <gmei_at_my-deja.com>
Date: Thu, 02 Nov 2000 18:57:37 GMT
Message-ID: <8tsdes$ia5$1@nnrp1.deja.com>

Does your tnsnames.ora file on linux has the part which identify the oracle instance on Solaris?

Compare the tnsnames.ora file on both boxes which might give you some clue.

Another thing is svrmgrl does not use tnsname.ora file, it "talks" to Db directly while sqlplus goes through tnsnames.ora file, so looks like your tnsname.ora file entry is not correct.

Hope this helps.

Guang

In article <slrn902jlm.n0.schmadde_at_orca.syscall.net>,   schmadde_at_syscall.de (Martin Schmachtel) wrote:
> I need to make a connection from linux machine to an Oracle Server
 7.3.4 on
> a Solaris box (to which I don't have access other than through
 sqlnet).
> Since the oldest oracle version for linux is 8.0.5 I had installed
 that.
>
> I created a tnsnames.ora file, in which I defined a connection, lets
 call
> it BLUBBER. I can connect to the database and access data with select,
> if I use svrmgrl> connect username/password_at_BLUBBER.
> If, however I try to do the same thing from sqlplus
> (Username: username/password_at_BLUBBER), I get the error:
>
> ORA-01034: ORACLE not available
>
> the same thing happens, if I try to use a perl script with DBD-
 Oracle, which
> works fine on a Solaris Box with 7.3.4 Client libs installed (on this
 box,
> connecting via sqlplus and the perl script works just fine).
>
> Does anybody have an Idea what I could be doing wrong?
>
> thanks for any hints
> schmadde
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 02 2000 - 12:57:37 CST

Original text of this message

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