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

In article <966360213.25593.1.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> 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?"
> >
>
>

I'm wondering if you do or do not have .world appended to the instance in tnsnames. Also, check db_global_names in the docs.

jg

--
These opinions mine
mailto:joel-garry_at_nospam.home.com
Remove nospam to mail
http://ourworld.compuserve.com/homepages/joel_garry


Sent via Deja.com http://www.deja.com/
Before you buy.