Re: Can't connect to instance

"Life Learner" <PowerE2E_at_yahoo.com> wrote in message 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.

This would be a feature. It is documented somewhere, but I forget where, maybe the install guide. You can always su from root to a dba account without a password anyways. Well, on hpux if I su from oracle to root then run a script in the background that su to oracle I get a bus error but I probably did something right with file protections.

>
> 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
> >
> >
> >
> >

jg

--
@home is bogus.
http://www.signonsandiego.com/news/uniontrib/tue/business/news_1b25airfiber.html