DataGrip: How to connect to Oracle as SYSDBA

Pratik Kate
Feb 5, 2021

In Oracle SQL Developer Tool we add user name as

sys

But we have a Role Dropdown to select SYSDBA

Oracle SQL Developer Tool Add Database Connection

But when we try to added Oracle DB as data source in DataGrip you won’t find role dropdown and username “sys” will give you following error

ORA-28009 Error Dialog

To fix ORA-28009 error you need to change your username to following

sys as sysdba

DataGrip Oracle Configuration

I hope above information was helpful.

--

--

Pratik Kate

An analytical and curious individual with 7+ years of problem-solving experience for Fortune 500 companies and startups. More : https://katepratik.com/