DataGrip: how to connect to Oracle as SYSDBA

oracle sys datagrip sysdba
Vadzim picture Vadzim · Sep 8, 2016 · Viewed 7.5k times · Source

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.

Answer

Lerk picture Lerk · Sep 27, 2018

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)

Related questions

How to connect in java as SYS to Oracle?

I receive this error: java.sql.SQLException: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER How to fix? (I need to be SYS). Thanks.

Read More
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More