- ORACLE DATABASE FOR MAC OS INSTALL
- ORACLE DATABASE FOR MAC OS SOFTWARE
- ORACLE DATABASE FOR MAC OS CODE
Ln -s libclntsh.dylib.11.1 libclntsh.dylib
ORACLE DATABASE FOR MAC OS INSTALL
Once installed, you will also need to run it, to agree with the terms and conditions: I ran the command “sudo gcc” at the command line to do this.Ģ) Set up a link for a library file that the install will require: cd $ORACLE_HOME
ORACLE DATABASE FOR MAC OS CODE
It’s big, but a free download from the App Store, and necessary to compile some of the code within cx_Oracle. The main steps here are:ġ) Install xcode (sorry!). I use the cx_Oracle library for this it works nicely on all platforms I’ve tried (Windows, Mac, linux). With python and Oracle working, all that’s required now is to get the two talking to each other. This installs the incredibly useful iPython, and also allows you to use pip (the recursively-named “PIP installs packages” package manager) to install python packages in a way that plays nicely with the conda package manager (which I also use widely – and the subject of another post soon). With Miniconda ready, I added a few “essentials”: At time of writing, I’m using python 2.7.9 rather then 3+, because Pandas is very useful but currently not available for python 3. For these instructions, I started by installing Miniconda. The easiest way to get python working, in my experience, is to use either Anaconda or Miniconda the former is fully-loaded with all the packages you could ever need, and the latter is stripped down to the basics, but with tools to add what you need. Install your own installation of python rather than using the default version on Mac, which is both old (version 2.6) and slightly risky (it is used by the operating system so inadvertent changes to the configuration could be catastrophic). At this point, you should be able to use SQL*Plus to connect to a server: I’m assuming you’ll be able to manage the contents of this file, or find appropriate settings elsewhere based on your Oracle server. Vi $ORACLE_HOME/network/admin/tnsnames.ora I created this and set it up as follows: mkdir -p $ORACLE_HOME/network/admin You will also probably want to set up a TNSNAMES.ORA file to hold your server settings. ~/.bash_profile” to get the settings into your current shell – we’ll be referring to some of them below. Edit your ~/.bash_profile file using your favourite editor and add the following lines at the end: export ORACLE_HOME=~/Applications/Oracle/instantclient_11_2Įxport PATH="$$ORACLE_HOME"
There are three environment variables we will need to set up in order to make things work. This created a subdirectory called instantclient_11_2. Unzip ~/Downloads/instantclient-basiclite-macos.圆4-11.2.0.4.0.zip I created a directory and unzipped these files: mkdir -p ~/Applications/Oracle
ORACLE DATABASE FOR MAC OS SOFTWARE
A recent disk failure left me having to reinstall the software I use on my Mac laptop.