REMOTE_LOGIN_PASSWORD = EXCLUSIVE ??
if not, set it
"Life Learner" <PowerE2E_at_yahoo.com> a écrit dans le message de news:
1D87a.91333$na.1745413_at_news2.calgary.shaw.ca...
> I am tring to connect to the instance with root user, I know I dont have
to
> do this via root, but I am just doing a test. I am able to connect to the
> instance successfully via other regular users if only they are added into
> "dba" group.
>
> I compared all the environment variables of root user with others, they
are
> the same. and with root, I can log on to system under root. That proved
all
> the necessary environment setting is correct.
>
> It seems that the root user is restricted by Oracle.
>
> P.S I am working with Oracle 8.1.7 on Solaris 8 2/02.
>
>
> "Life Learner" <PowerE2E_at_yahoo.com> wrote in message
> news:IdW6a.336431$Yo4.12110110_at_news1.calgary.shaw.ca...
> > Hi all,
> >
> > I already added one user into "dba" group on my Solaris machine, but
still
> > couldn't connect to the instance:
> >
> > # sqlplus /nolog
> >
> > SQL*Plus: Release 8.1.7.0.0 - Production on Wed Feb 26 11:03:57 2003
> >
> > (c) Copyright 2000 Oracle Corporation. All rights reserved.
> >
> > SQL> connect / as sysdba
> > ERROR:
> > ORA-01031: insufficient privileges
> >
> >
> >
> >
>
>
Received on Wed Feb 26 2003 - 14:39:33 CST
