Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sys as sysdba on root user
On Jun 28, 9:06 am, sybrandb <sybra..._at_gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -
Sybrand is most definitely correct. You should never use the root account to directly access Oracle but should either su - oracle to run DBA type tasks and just connect via a valid Oracle username for running scripts.