Re: Can't connect to instance

From: Life Learner <PowerE2E_at_yahoo.com>
Date: Wed, 26 Feb 2003 19:32:13 GMT
Message-ID: <1D87a.91333$na.1745413@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 - 13:32:13 CST