Reputation: 5986
I'm trying to connect to an Oracle database using SQL Developper as Sys DBA but I'm receiving the error : ORA 1031 : Insufficient Privileges.
I'm sure the password is correct because I'm able to connect to the same database using SQLPlus :
Does anyone know how to solve that please ?
Thanks
Upvotes: 0
Views: 3368
Reputation: 10226
Check if the parameter REMOTE_LOGIN_PASSWORDFILE is set to exclusive. This is necessary to login AS SYSDBA
from SQL developer :
SQL> show parameter remote_login_passwordfile
To change it :
SQL> ALTER SYSTEM SET REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE SCOPE=SPFILE;
Upvotes: 0