Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sys as sysdba on root user

Re: sys as sysdba on root user

From: sybrandb <sybrandb_at_gmail.com>
Date: Thu, 28 Jun 2007 06:06:23 -0700
Message-ID: <1183035983.887964.238670@n60g2000hse.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US