ORA-01031: only with sqlplus or srvmgrl !
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