Oracle DBA – A lifelong learning experience

Greyed out connections in SQL Developer

Posted by John Hallas on January 26, 2016

After upgrading to SQL Developer a number of users noticed that some connections in the left hand pane were greyed out. I had the same experience for myself. There did not seem to be any pattern as to why specific connections were chosen and not others. Once greyed out they remained greyed out permanently – the selection did not change

I have not been able to find out an answer as to why it is happening, other than it is a bug/feature of that release.

However what I do know is that it is fixable

Right click any connection and view properties. Next to the ‘save password’ option – which for security reasons should not be ticked – but I bet it is for most of us – is a box entitled ‘connection color’


The normal connection style has a box with a cross through which stands for None or no color (as in the diagram). The ones with the greyed connection seem to default to a shade of grey (one of 50 ?). So the fix is to reset the color back to NONE again.

I have actually started changing my production connections to red now, just as a reminder that it is a live system and to be extra careful


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: