On Jun 28, 12:33 pm, bitmus <d.bit..._at_yahoo.com> wrote:
> Hi.
>
> i've faced a problem that connecting sys as sysdba is always giving
> ORA-01031: insufficient privileges.
> the problem is only occured when using as sysdba on root user. if i
> connect using system/blabla, there is no error.
>
> also connecting sys as sysdba is ok for other system user such as
> oracle.
>
> i have added root user to dba group. that is not helped me.
> and i compared root user to other system user, and i did not found any
> other differences.
> Help me.
>
> Thanks.
Why do you want to misuse root to connect as a sysdba user to the
database? As you are root, su - oracle -c <command> allows you to
execute *anything* as user oracle.
--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Jun 28 2007 - 08:06:23 CDT
