Monday, December 30, 2019

Change font for "Connections", "Reports", etc in Oracle SQL Developer

NOTE: These instruction apply to the connections, reports, menus, etc in Oracle SQL Developer. If you are looking to change the font of your PL/SQL Code, these instructions in StackOverflow are for you.

I found instructions here for changing fonts in Oracle SQL Developer (OSD) menus and trees, but being sloppy caused me to struggled a bit.

 (Story of my life ¯\_(ツ)_/¯ ) 

A couples things that should probably have been obvious, but were cheerfully ignored by the idiot with a laptop (Dr. Who Reference) :
1) Before making any changes, shut down Oracle SQL Developer.
    This is important because the file gets overwritten when OSD is closed.
2) Make the recommended changes to the file at:
C:\Users\\AppData*\Roaming\SQL Developer\system19.2.1.247.2212\o.sqldeveloper\ide.properties
NOTE*: AppData is a hidden file.
      In Windows Explorer, go to view and make sure hidden files are enabled.
     
NOTE: This was true for OSD  Version 19.2.1.247, Build 247.2212
      The system19* folder details may change for previous or subsequent releases

3) Start OSD and enjoy not having to squint at your connection data ;-)

Another quick note: If Oracle would open-source OSD, I would be happy to add a menu item that would set this font. This is an example of the ways in which OSD, which is a FANTASTIC TOOL all things considered, nonetheless feels just sort of unfinished.

Big thanks to Jeff Smith for publishing instructions on this topic. :-D


The Database is not accessible after creating Always On Availability Group

 Having created a fully functional SQL Server Always On Availability Group, I connect using SSMS. Upon trying to expand the database, I get ...