Re: SQL*Plus connection Problem (ORA-01034)

At this is stage (having all things correctly set) it is usually a security issue. The protection for the Oracle executable and at least the tnslsnr.exe must be 6751, ie the setuid bit on.

Hth,

Sybrand Bakker, Oracle DBA

"Alain Léglise Consultant" <alc.info.conseil_at_freesurf.fr> wrote in message news:399974C8.C4D99888_at_freesurf.fr...
> As I write, the ORACLE_SID has been set correctly... And I can access the
> database via my local network, so tnsnames.ora is also set correctly...
> I know about this parameters, that's why I send my question...
> Thanks anyway.
>
> Uwe Schneider wrote:
>
> > Alain Léglise Consultant wrote:
> > >
> > > Hi everybody !
> > >
> > > I'm running an Oracle 8i (8.1.5.0.0) on Linux RedHat 6.0
> > >
> > > When I launch "sqlplus system/manager" as oracle connected, it works !
> > >
> > > When I try to launch the same command line on another Linux user, it
> > > doesn't work (for information, ORACLE_SID is good positionned).
> > > When I launch sqlplus on a client Windows PC, it does work !!!
> >
> > when you issue the command "sqlplus system/manager" you need to have the
> > ORACLE_SID environment variable set. Make sure it is.
> >
> > If you can connect from a remote pc your listener should be working
> > correctly. So if you add the correct network alias to your tnsnames.ora
> > you even should be able to connect locally via TCP (e.g. sqlplus
> > system/manager_at_ORCL).
> >
> > Regards!
> >
> > 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?"
>
Received on Tue Aug 15 2000 - 12:25:11 CDT