Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
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
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