thanks for the reply.

I don't know about UNIX, since i'm using Windows, but I guess when you talk about the dba group in UNIX is this same as ORA_DBA group in Windows.

Here's some more information on the problem I'm having, if somebody can help...

The parameter remote_login_passwordfile is set to exclusive
and this is all I had in the password file were the users INTERNAL and SYS

Then I added my OS username (part of the ORA_DBA group)to the password file.

Now I am able to connect to the database as SYSDBA using DBA Studio and OEM, which I couldn't do before. Great!!!

BUT... I still get the “Insufficient Privileges” error if I try to connect as sysdba through Srvmgrl or Sqlplus… What am I missing? If these users (sys and hp) are in the password file, why can't I connect as sysdba then?

D:\>sqlplus sys/change_on_install
SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.

D:\>sqlplus hp/password
SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.

Thank you.

Heloisa