Re: insufficient Privileges

[Quoted] i don't know it is the problem

did you create password file at the database server? if no, you cannot connect as sysdba remotely and it will prompt "insufficient Privileges"

Joe
OCP Association Hong Kong
www.ocphk.org

"Ron Reidy" <rereidy_at_indra.com> ¼¶¼g©ó¶l¥ó·s»D :3DBE592F.1CA210A3_at_indra.com...
> Hari Om wrote:
> >
> > Hi Experts:
> >
> > I have my Oracle DB Set up on IBM AIX Server. I have installed Oracle
> > Client on my Win XP System
> >
> > When I start my Oracle Enterprise Manager from my Cleint PC with
> > following data:
> > --------------------------------
> > Username=system
> > Passowrd=manager
> > Connect as: SYSDBA
> > --------------------------------
> >
> > the System throws "ERROR: ORA-01031: insufficient Privileges" - wonder
> > why! Later when I "connect as: NORMAL" - it just works fine.
> >
> > Does anyone know how to eliminate that Error.
> >
> > THANKS!
> SYSTEM does not have SYSDBA privs as a default. If you need to connect
> as SYSDBA, connect as SYS.
> --
> Ron Reidy
> Oracle DBA
Received on Tue Oct 29 2002 - 12:37:48 CET