I swear, every single time I update major version numbers for Navicat you break the functionality of Oracle TNS connections. EVERY. SINGLE. TIME! If it wasnt for the fact that my alternative clients make me want to gouge my eyes out I would never open this stupid software. You advice to set environment variables and open the application through the command line DOES NOT WORK! And besides, if youre telling your users to open a Mac GUI application through the command line YOUVE DONE SOMETHING COMPLETELY WRONG! Its just utterly unvelievable that youre asking people to pay money for this software.