Re: Insufficient Privileges

Hi Hari,

The "problem" is that system has not been granted sysdba privileges (or at least Oracle doesn't know that system has not been granted sysdba privileges). You need to :

1. Create a password file in order to store these special dudes. As you are using OEM, you can only authenticate sysdba/sysoper users via this password file. To create a password file, check out the ORAPWD utility (eg. orapwd file=$ORACLE_HOME/dbs/orapwBOWIE.ora password=bowie entries=10)
2. Ensure the remote_login_passwordfile parameter is set to exclusive.
3. Grant sysdba to system (by a user who already has sysdba privileges). This will store system in the password file.

Now when logging in to OEM with sysdba privileges, Oracle knows to suz out the password file and upon finding system will say "go for it ..."

Good Luck

Richard
"Hari Om" <hari_om_at_hotmail.com> wrote in message news:d1d5ebe4.0210281336.3365f513_at_posting.google.com...
> 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!
Received on Mon Oct 28 2002 - 18:10:42 CST