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.

score 50 · Accepted Answer · answered Sep 27 '18 at 09:41

50

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)

answered Sep 27 '18 at 09:41

Lerk

946
1
15
21

How did you manage to change the advanced properties? I couldn't find the `internal_logon` key and was unable to add one. – Lerk Oct 05 '18 at 12:36
1

I guess, available property names list comes from the driver when it's attached. – Vadzim Oct 05 '18 at 12:46
1

This does not work for me in v2022.1.4, while @Vadzim solution to set `internal_logon` to `sysdba` in Advanced tab worked fine – Andrea Di Stefano May 25 '22 at 14:32

score 21 · Answer 2 · answered Sep 08 '16 at 14:29

21

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.

answered Sep 08 '16 at 14:29

Vadzim

24,954
11
143
151

2

Yeah, that's the answer – moscas Sep 09 '16 at 10:59
1

Not able to modify the values in that tab (2018.2.3). The `sys as sysdba` solution worked for me. – ICanChange Jan 08 '19 at 21:33

score 12 · Answer 3 · answered Nov 15 '21 at 15:09

12

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.

answered Nov 15 '21 at 15:09

Prasannjeet Singh

756
7
17

Off-topic, how did make this screenshots? – Desperado Nov 06 '22 at 13:55
1

inbuilt in mac. `Command` + `Shift` + `5`. Then select `Capture Selected Window`. That's it! – Prasannjeet Singh Nov 08 '22 at 11:29

score 6 · Answer 4 · edited Dec 01 '19 at 15:32

6

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

edited Dec 01 '19 at 15:32

Vadzim

24,954
11
143
151

answered Apr 18 '19 at 10:11

Arun

71
1
2

score 0 · Answer 5 · answered Feb 04 '20 at 12:40

0

sys as sysdba

As username works fine in Pycharm

answered Feb 04 '20 at 12:40

speznaz

98
1
10

DataGrip: how to connect to Oracle as SYSDBA

5 Answers5