random technical thoughts from the Nominet technical team

Using gqlplus with Instant Client on Mac OS X

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5 out of 5)
Loading ... Loading ...
Posted by chris on Sep 15th, 2008

I need to use Oracle’s SQL*Plus quite often from my Mac but Oracle’s support for OS X is sketchy to say the least.  You can’t install the proper client on Intel machines, so you have to use the Instant Client instead.  I also want to use gqlplus, which adds things like a command history to SQL*Plus.  (You may be amused to know that SQL*Plus was once called UFI, meaning “User Friendly Interface”, not sure how it could be made less friendly really).  After a bit of trial and error, I got it working.  This is how I have it set up:

  • I installed instantclient into its own directory
  • I added this directory to PATH and to both LD_LIBRARY_PATH and DYLD_LIBRARY_PATH environment variables
  • I put tnsnames.ora and login.sql (for commands to be run at login time) in my home directory
  • I pointed the TNS_ADMIN and SQLPATH environment variables to my home directory
  • I built and installed gqlplus in /usr/local/bin

I have also set up an alias so that gqlplus runs with the -d flag.  This turns off the auto-completion which can make gqlplus slow to load.

One Response

  1. Matt Says:

    Strange, I didn’t have any problems – having previously installed instant client I simply ran:

    ./configure && make

    to build GQL*PLus. Don’t run ‘sudo make install’ as it fails however and the README says not to bother anyway! Simply copy the executable to your chosen location, e.g. $HOME/bin

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.

Recent Posts

Highest Rated