If you have used the command-line SQLPlus in a Windows environment, you will probably be used to using the command history to execute previous SQL statements using the arrow keys. $ sqlplus Did you enjoy? That’s all folks.įixing command history for using SQLPlus line edition with arrow keys To load this profile, run the following command:Īssuming you have set up your tnsnames.ora file correctly, you should now be able to connect one of the databases as follows: bash_profile before the file will be empty, otherwise just add the following lines to the end of the existing file.Įxport ORACLE_HOME=/Applications/oracle/product/instantclient_64/11.2.0.4.0Įxport DYLD_LIBRARY_PATH=$ORACLE_HOME/lib (You can better ask to a DBA to review the content of this file and ask her to provide you with a proper test connection) Create a proper tnsnames.ora file to define proper connection stringsĬopy or create a tnsnames.ora file to /Applications/oracle/product/instantclient_64/11.2.0.4.0/network/admin/Ĭreate the tnsnames.ora file with the vi editor, paste the following lines and save it. $ mv *README /Applications/oracle/product/instantclient_64/11.2.0.4.0/ $ mv glogin.sql /Applications/oracle/product/instantclient_64/11.2.0.4.0/sqlplus/admin/ $ mv x*.jar /Applications/oracle/product/instantclient_64/11.2.0.4.0/rdbms/jlib/ $ mv ojdbc* /Applications/oracle/product/instantclient_64/11.2.0.4.0/jdbc/lib/ Next, move the files over to these directories as follows: $ mkdir -p /Applications/oracle/product/instantclient_64/11.2.0.4.0/network/admin $ mkdir -p /Applications/oracle/product/instantclient_64/11.2.0.4.0/sqlplus/admin $ mkdir -p /Applications/oracle/product/instantclient_64/11.2.0.4.0/rdbms/jlib $ mkdir -p /Applications/oracle/product/instantclient_64/11.2.0.4.0/jdbc/lib $ mkdir -p /Applications/oracle/product/instantclient_64/11.2.0.4.0/lib $ mkdir -p /Applications/oracle/product/instantclient_64/11.2.0.4.0/bin Instead, we’ll create a nicely structured directory to keep these files in your user Applications folder. Note: The -qq flag will tell the unzip utility to run in quieter mode, preventing any output from being displayed on the screen.īy default, the archive will extract all these files to a single directory. Open a Terminal window and unzip the downloaded files. Extract the files and create the proper folder structure. Download the files from the Oracle SiteĢ. I just skipped some text and modified some paths to adapt it to oracle client 11.2.0.4 release.ġ. The How To has been extracted from the following link:

Install oracle database mac