This document describes the installation process for the Oracle 12c Client software. The University of Wisconsin-Madison doesn't require any particular version installation of the Oracle client, but for best compatibility, it is recommended users install the 12c client. It is NOT recommended users running the Oracle 11g client update to 12c unless they are experiencing technical issues with the 11g client.
(For 64-bit Intel Macs, download Java for Mac OS X 10.5, Update 1. For the latest version of Mac OS, use the Software Update feature) Download the file for OS X on the Downloads page; Double-click the SQL Developer icon. It is possible to install Oracle Client on Mac Os X (for Intel x86 or PPC) downloading the Instant Client for Mac OS X from the Oracle site 1. The steps I follow to download the version 11.2.0.4.0 (64-bit) are: Go to the oracle site 1; Select Instant Client for Mac OS X (Intel x86) (32-bit and 64-bit); Accept the agreement. Installing Instant Client 12.2 on macOS. Instant Client 12.2 supports macOS High Sierra, Sierra and El Capitan. Download the desired Instant Client ZIP files. All installations require the Basic or Basic Light package. Unzip the packages into a single directory such as /instantclient122 that is accessible to your application. How to install Oracle Instant Client Version 12.1.0.2 (64-bit) on a Mac (OS X 10.11.5) I have downloaded version 12.1.0.2 (64-bit) version and unzipped the file. I now have the following files under /downloads/instantclient. DBeaver - Universal Database Manager and SQL Client. DBeaver is free and open source.
Downloading the Oracle 12c Client
Oracle 11g Mac
Navigate to the Oracle Database downloads page.
Scroll down to the client options and click the download link for your appropriate OS.
Note: 32-bit Windows applications will not work with Oracle's 64-bit ODBC driver. Therefore, users of 64-bit versions of Windows may need to install the 32-bit version of the Oracle Client if they intend to make ODBC connections with 32-bit applications. For instance, if you are running 64-bit Windows 7 but you plan to use a 32-bit copy of MS Access to connect to EPM, you should install the 32-bit version of the Oracle Client. If you intend to use both 64-bit and 32-bit applications to create ODBC connections, you will need to install both clients.
Accept the 'License Agreement' by checking the box in the popup window.
You will be prompted to sign in with an Oracle account, or to create one (free). Once you have signed in, or created your account and then signed in, you will be asked to download the client. Choose to Save the file to an easily accessible location on your computer's hard drive.
The zip archive containing the client installer is large and may take several minutes to download. Once the download is complete, you can continue to the installation process.
Installing the Oracle 12c Client
Install Oracle Database On Mac
Locate the zip archive containing the client installer on your computer's hard drive.
Right-click the zip archive and select 'Extract All...'. Windows will decompress the contents of the zip archive into a folder in the same location.
Open the resulting folder called 'Client32' (or 'Client64'.). Double-click on the application labeled 'setup' to launch the installer program.
On the first installer screen choose 'Administrator' as the installation type.
Click 'Next >' on the language selection screen.
Make sure 'Use Windows Built-in Account' is selected, then click 'Next >'..
On the 'Specify Installation Location' screen change the default 'Oracle Base' location to C:app, and Software Location to C:appclientproduct12.2.0client_1. Click 'Next >' to continue with the installation.
The image below does not have the correct install paths. Please follow the install paths above.The installer program will check for prerequisites and initiate the installation process. Once the installation is complete, you will be taken to a summary screen.
Final Setup Instructions
- Save UW TNSnames.ora file to the correct location in the Oracle directory: Adding, Edting, or Replacing Your TNSnames.ora File for InfoAccess
- Set up ODBC connection (using either 32 or 64 bit as appropriate): Configuring an ODBC connection to InfoAccess in Windows . It is critical to name the Data Source Name in ODBC as 'UW Data Warehouse' otherwise BA's Access files will give errors when connecting to InfoAccess. Test connection.
- Test in Oracle.
In Terminal go to your Downloads directory. Unzip both files: MacBook:Downloads alex$ unzip instantclient-basic-macos .... Install Oracle instant client (sqlplus) v12.1 on MacOSX - README.md. ... Download 'instantclient-sdk-macos.x64-12.1.0.2.0.zip'. Unarchive downloaded zip files .... Hi, The How To has been extracted from the following link: http://www.joelennon.ie/2014/02/06/installing-oracle-instant-client-mac-os-x/ I just .... SQL Developer by Oracle is one of the most traditional database tools to offer ... While in beta, you can run on Windows, MAC & Linux OS.. Set the library loading path in your environment to the directory in Step 2 ('instantclient'). On the Macintosh OSX platform, DYLD_LIBRARY_PATH is the .... In order to do so, you may need to register as an Oracle developer, or log in. The three files you need are the “basic”, “SDK” and “sqlplus” files for .... for Mac OS X (PPC). You must accept the Oracle Technology Network License Agreement to download this software. Subject to the Oracle Technology Network .... ... OCI8, I quickly concluded that it is a pain to configure. This post will go through how to get any OCI and Instant Client up and running on your Mac OSX.. Make dir for instant client then unzip zips mkdir -p ~/bin/oracle unzip -d ~/bin/oracle instantclient-basic-macos.x64-12.2.0.1.0-2.zip unzip -d ...