DataGrip: how to connect to Oracle as SYSDBA

Question

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.

Insensible

Answer 1

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)

Cumae

How did you manage to change the advanced properties? I couldn't find the internal_logon key and was unable to add one. – Cumae

I guess, available property names list comes from the driver when it's attached. – Insensible

This does not work for me in v2022.1.4, while @Insensible solution to set internal_logon to sysdba in Advanced tab worked fine – Terracotta

Answer 2

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.

Insensible

Yeah, that's the answer – Summarize

Not able to modify the values in that tab (2018.2.3). The sys as sysdba solution worked for me. – Clearing

Answer 3

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.

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

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

Recusant

Off-topic, how did make this screenshots? – Revetment

inbuilt in mac. Command + Shift + 5. Then select Capture Selected Window. That's it! – Recusant

Answer 4

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

Euglena

Answer 5

sys as sysdba

As username works fine in Pycharm

Lesialesion