Re: ORA-01031: insufficient privileges

Comments embedded.
mehaboob_at_gmail.com wrote:
> Thanks for the reply.
>
> Sorry I did not get what you are saying.
> First of all: please do not top post ???
>
> No , the oracle account is not a member of dba group.?
>
> Mehaboob
>

THIS is what we consider 'top posting' ... placing your response on TOP of the previous message. It is annoying; stop doing it.

Since the 'oracle' account is not a member of the 'dba' group you can't do what you want, as it doesn't have the authority to do so. The 'oracle' UNIX account needs to be a member of the 'dba' group; this is how the O/S authentication operates on a UNIX system. You will need to have your system administrator correct this.

> Sybrand Bakker wrote:
> > On 6 Jun 2006 08:19:13 -0700, mehaboob_at_gmail.com wrote:
> >
> > >SQL*Plus: Release 9.2.0.6.0 - Production on Tue Jun 6 14:07:42 2006
> > >
> > >Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
> > >
> > >SQL> connect / as sysdba
> > >ERROR:
> > >ORA-01031: insufficient privileges
> >
> > First of all: please do not top post. If you want to receive no
> > responses, by all means toppost.
> >
> > Is the oracle account member of the dba group.?
> > Was Oracle linked with the dba group?
> >
> > --
> > Sybrand Bakker, Senior Oracle DBA

David Fitzjarrell Received on Tue Jun 06 2006 - 11:10:02 CDT