SQL*PLus on Mac
I would think installing SQL*Plus on the Mac would be point, click download, point click, install bam it works.
It did install mostly straight forward on my old Mac. Got a new Mac and no dice.
Tried installing myself guessing at the downloads. First of all why isn’t there just one download?
Downloaded instantclient and instantclient with SQL*Plus which turns out to be correct, but no dice. Still got errors.
Got errors. Gave up.
Came back again to look at it yesterday and followed this:
worked like a charm.
Then I ran a shell script that used SQL*Plus oramon.sh and get the error
dyld: Library not loaded: /ade/dosulliv_sqlplus_mac/oracle/sqlplus/lib/libsqlplus.dylib
Referenced from: /Applications/oracle/product/instantclient_64/220.127.116.11.0/bin/sqlplus
Reason: image not found
so I set my environment variable
Let’s check the environment variable:
$ env | grep LIB
Huh?! Where is my environment variable?
Apparently you can’t set DYLD_LIBRARY_PATH on Mac without over riding some security settings which didn’t sound attractive.
I googled around and found
which didn’t work for me. Then found
which has as a solution to set the library path inside an alias for SQL*Plus – cool!
alias sqlplus=”DYLD_LIBRARY_PATH=/Applications/oracle/product/instantclient_64/18.104.22.168.0/lib sqlplus”
and I put that into my ~/.bashrc and it worked!