Connect Sys as Sysdba : Insufficient privileges

0
votes

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 :

enter image description here

enter image description here

Does anyone know how to solve that please ?

Thanks

3
oracleoracle-sqldeveloper

3 Answers

4
votes

change role to be sysdba instead of default in sqldeveloper

0
votes

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;
-1
votes

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