CODEWITHSUNDEEP
oracle-databasesysdatagripsysdba
Vadzim
Vadzim

Reputation: 26160

DataGrip: how to connect to Oracle as SYSDBA

I tried to setup in DataGrip an Oracle connection under SYS user.

But got error:

ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

But there is no option in GUI to choose as SYSDBA option.

Upvotes: 36

Views: 15926

Answers (5)

Prasannjeet Singh
Prasannjeet Singh

Reputation: 1427

While this has been answered already. I would like to be a little more descriptive by adding screenshots.

Add a new database. Make sure the username is set to sys as sysdba. The default password usually is oracle.

enter image description here

Now moved to Advanced tab. Here find internal_logon and set it's parameter to sysdba.

enter image description here

That's it. You're ready to connect.

Upvotes: 13

speznaz
speznaz

Reputation: 98

sys as sysdba

As username works fine in Pycharm

Upvotes: 0

Arun
Arun

Reputation: 81

sys as sysdba as username works fine for Database plugin in IntelliJ IDEA.

Upvotes: 7

Lerk
Lerk

Reputation: 1115

Coming back here two years later, it seems to be not possible anymore to change the advanced properties in the connection settings.

Instead you have to supply sys as sysdba as username. (This might seem obvious but took me a while to find this out)

Upvotes: 59

Vadzim
Vadzim

Reputation: 26160

While there is no easy switch currently, it's still possible to go to Advanced tab in connection's properties and set internal_logon param to sysdba value.

Upvotes: 23

Related Questions