Thomas Carlton
Thomas Carlton

Reputation: 5986

Connect Sys as Sysdba : Insufficient privileges

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

Upvotes: 0

Views: 3368

Answers (3)

Tigran Shahnazaryan
Tigran Shahnazaryan

Reputation: 176

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

Upvotes: -1

waleedazam
waleedazam

Reputation: 367

change role to be sysdba instead of default in sqldeveloper

Upvotes: 4

Thomas G
Thomas G

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

Related Questions