Connect Sys as Sysdba : Insufficient privileges

Question

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

Answer 1

Role(par defaut) - role(sysdba) or sysoper

Answer 2

change role to be sysdba instead of default in sqldeveloper

Answer 3

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;