- #Install oracle sql developer for mac how to
- #Install oracle sql developer for mac for mac os
- #Install oracle sql developer for mac install
- #Install oracle sql developer for mac archive
Section 1.2, "Installing and Starting SQL Developer" Section 1.1, "SQL Developer System Recommendations" This chapter contains the following major sections:
#Install oracle sql developer for mac install
Please read the information in this chapter before you install Oracle SQL Developer. If you plan to SQL Developer as part of the Oracle Database release 11 installation, see the Oracle Database installation documentation. Now, when you launch SQL*Plus and try to use the arrow keys to access previous commands, it will work.This guide assumes that you plan to download the SQL Developer kit (.zip) file and install it as a freestanding tool. bash_profile file again.Īdd the following line to the end of the file. The final thing you need to do is tell your system to use rlwrap whenever you use SQL*Plus. With Homebrew installed, you can now easily install rlwrap on your system with one command: Head over to and follow the instructions to install and set up Homebrew (it’s very easy).
#Install oracle sql developer for mac for mac os
You could download this from source and build it yourself, but I find it much easier to use the fantastic brew package manager for Mac OS X. One thing you’ll notice in SQLPlus for the Mac is that this doesn’t work by default, if you hit the up key you’ll see a strange character sequence ^[[A rather than the previous command. 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.
#Install oracle sql developer for mac archive
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.ġ.
#Install oracle sql developer for mac how to
The How To has been extracted from the following link:
0 kommentar(er)
