Version 19.9.0.0.0
Oracle Client For Mac
Base - one of these packages is required
Name | Download | Description |
|---|---|---|
| Basic Package | All files required to run OCI, OCCI, and JDBC:OCI applications (82,202,458 bytes) (cksum - 2460015998) Review the Operating System Checklist for Oracle Database Client Installation. Note Windows 7 is not supported. The 19c Basic package requires the Microsoft Visual Studio 2017 Redistributable. | |
| Basic Light Package | Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support (41,941,662 bytes) (cksum - 1678903531) Review the Operating System Checklist for Oracle Database Client Installation. Note Windows 7 is not supported. The 19.9 Basic Light package requires the Microsoft Visual Studio 2017 Redistributable. |
Tools - optional packages
Name | Download | Description |
|---|---|---|
| SQL*Plus Package | The SQL*Plus command line tool for SQL and PL/SQL queries (973,433 bytes) (cksum - 474662487) | |
| Tools Package | Includes Data Pump, SQL*Loader and Workload Replay Client (1,206,688 bytes) (cksum - 3444890079) |
Oracle’s Instant Client is a valuable tool allowing anyone on a Mac to connect to Oracle databases, and is a prerequisite for installing SQL Developer, SQLPlus, or OCI8 (for PHP connectivity). However, Oracle’s documentation for installing Instant Client is very light. Install Oracle, following Howard Rogers' Oracle installation guide for CentOS. Install Oracle Instant Client For Mac OSX so we can have SQL.Plus in a Mac Terminal window, just like old times. Vii Preface This guide describes how to install and configure Oracle Database Client 10 g Release 2 (10.2) on Apple Mac OS X (Intel). Audience This guide is intended for anyone responsible for installing Oracle Database Client 10 g Release 2 (10.2) on a single Apple Mac OS X (Intel) system. Instant Client: As of 12c one can uses Instant Client to authenticate with Kerberos using Windows Internal cache. Tnsnames.ora and sqlnet.ora are not provided with Instant client so one needs to set a TNSADMIN variable pointing to a directory with sqlnet.ora and tnsnames.ora. The sqlnet.ora settings are the same as for a thick client.
Development and Runtime - optional packages
Name | Download | Description |
|---|---|---|
| SDK Package | Additional header files and an example makefile for developing Oracle applications with Instant Client (1,859,034 bytes) (cksum - 1971771715) | |
| JDBC Supplement Package | Additional support for Internationalization under JDBC (1,586,255 bytes) (cksum - 4198067402) | |
| ODBC Package | Additional libraries for enabling ODBC applications (862,712 bytes) (cksum - 1871686369) | |
| Precompiler Package | Precompiler Downloads | Additional files for Pro*C and Pro*COBOL |
Version 18.5.0.0.0
Base - one of these packages is required
Name | Download | Description |
|---|---|---|
| Basic Package | All files required to run OCI, OCCI, and JDBC:OCI applications (77,769,261 bytes) (cksum - 1317689833) The 18.5 Basic package requires the Microsoft Visual Studio 2013 Redistributable | |
| Basic Light Package | Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support (39,177,858 bytes) (cksum - 2058932148) The 18.5 Basic package requires the Microsoft Visual Studio 2013 Redistributable. |
Tools - optional packages
Name | Download | Description |
|---|---|---|
| SQL*Plus Package | The SQL*Plus command line tool for SQL and PL/SQL queries (974,185 bytes) (cksum - 3454636626) | |
| Tools Package | Includes Data Pump, SQL*Loader and Workload Replay Client (1,004,204 bytes) (cksum - 1254374575) |
Development and Runtime - optional packages
Name | Download | Description |
|---|---|---|
| SDK Package | Additional header files and an example makefile for developing Oracle applications with Instant Client (1,829,323 bytes) (cksum - 1367867993) | |
| JDBC Supplement Package | Additional support for Internationalization under JDBC (1,581,831 bytes) (cksum - 2123195004) | |
| ODBC Package | Additional libraries for enabling ODBC applications (766,984 bytes) (cksum - 2984061786) | |
| Precompiler Package | Precompiler Downloads | Additional files for Pro*C and Pro*COBOL |
Version 12.2.0.1.0
Base - one of these packages is required
Name | Download | Description |
|---|---|---|
| Basic Package | All files required to run OCI, OCCI, and JDBC:OCI applications (75,062,441 bytes) (cksum - 1462971172) The 12.2 Basic package requires the Microsoft Visual Studio 2013 Redistributable. | |
| Basic Light Package | Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support (37,128,586 bytes) (cksum - 865082268) The 12.2 Basic Light package requires the Microsoft Visual Studio 2013 Redistributable. |
Tools - optional packages
Name | Download | Description |
|---|---|---|
| SQL*Plus Package | The SQL*Plus command line tool for SQL and PL/SQL queries (959,896 bytes) (cksum - 3056233076) | |
| Tools Package | Includes Data Pump, SQL*Loader and Workload Replay Client (1,016,027 bytes) (cksum - 3645067508) |
Development and Runtime - optional packages
Name | Download | Description |
|---|---|---|
| SDK Package | Additional header files and an example makefile for developing Oracle applications with Instant Client (1,801,992 bytes) (cksum - 3191784704) | |
| JDBC Supplement Package | Additional support for Internationalization under JDBC Java 6 runtime download mac. (1,576,298 bytes) (cksum - 2378954267) | |
| ODBC Package | Additional libraries for enabling ODBC applications (Updated 9/20/2017) (804,715 bytes) (cksum - 1844846476) | |
| Precompiler Package | Precompiler Downloads | Additional files for 'proc' binary and related files to precompile a Pro*C application and demo |
Version 12.1.0.2.0
Name | Download | Description |
|---|---|---|
| Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (72,416,242 bytes) (cksum - 1751087003) The 12.1 Basic package requires the Microsoft Visual Studio 2010 Redistributable. | |
| Instant Client Package - Basic Light | Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (38,837,115 bytes) (cksum - 1745949615) The 12.1 Basic Light package requires the Microsoft Visual Studio 2010 Redistributable. | |
| Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (1,574,297 bytes) (cksum - 3613358776) | |
| Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (876,515 bytes) (cksum - 1826332995) | |
| Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (2,748,874 bytes) (cksum - 1448203088) | |
| Instant Client Package - ODBC | Additional libraries for enabling ODBC applications (518,721 bytes) (cksum - 675718609) | |
| Instant Client Package - WRC | Workload Replay Client used to replay workload for RAT's DB Replay Feature (15,237 bytes) (cksum - 2158108932) | |
| Precompiler Package | Precompiler Downloads | Additional files for 'proc' binary and related files to precompile a Pro*C application and demo |
Version 11.2.0.4.0
Name | Download | Description |
|---|---|---|
| Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (54,956,947 bytes) | |
| Instant Client Package - Basic Light | Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (10.2 only) (23,504,640 bytes) | |
| Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (1,565,996 bytes) | |
| Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (821,172 bytes) | |
| Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (1,446,625 bytes) | |
| Instant Client Package - ODBC | Additional libraries for enabling ODBC applications (1,358,385 bytes) | |
| Instant Client Package - WRC | Workload Replay Client used to replay workload for RAT's DB Replay Feature (13,542 bytes) | |
| Precompiler Package | Precompiler Downloads | Additional files for 'proc' binary and related files to precompile a Pro*C application and demo |
Version 11.1.0.7.0
Name | Download | Description |
|---|---|---|
| Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (49,416,845 bytes) | |
| Instant Client Package - Basic Light | Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (10.2 only) (20,050,763 bytes) | |
| Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (1,563,961 bytes) | |
| Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (828,923 bytes) | |
| Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (897,394 bytes) | |
| Instant Client Package - ODBC | Additional libraries for enabling ODBC applications (1,322,266 bytes) | |
| Instant Client Package - WRC | Workload Replay Client used to replay workload for RAT's DB Replay Feature (5,076 bytes) | |
| Precompiler Package | Precompiler Downloads | Additional files for 'proc' binary and related files to precompile a Pro*C application and demo |
Version 10.2.0.5
Oracle Client Download
Name | Download | Description |
|---|---|---|
| Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (36,255,100 bytes) | |
| Instant Client Package - Basic Light | Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (10.2 only) (12,218,457 bytes) | |
| Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (1,475,200 bytes) | |
| Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (764,303 bytes) | |
| Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (802,412 bytes) | |
| Instant Client Package - ODBC | Additional libraries for enabling ODBC applications (1,324,040 bytes) |
This how you install SQL Developer on Mac OS Yosemite. The first thing you need to do is download and install Java 8, not Java 7 on your Mac OS Yosemite as suggested on some web sites. You can determine whether or not Java is installed by running the following command:
You must accept the Java license to install Java 8 on the Mac OS X operating system:
You have the option of installing the Java SDK or JDK. I’ve opted to install Netbeans 8 with JDK 8u45, as you can tell from the screen capture after you launched the file:
It is a standard Mac OS installation, which is why I didn’t bother showing any dialog messages. After installing the Java JDK or SDK, you should download SQL Developer 4.1 from Oracle’s web site. Below is a screen shot of the Oracle download web page where I’ve accepted the license agreement:
If you attempt to launch the installation and you’ve set your Mac Security to the “Mac App Store and identified developers” setting, you should raise the following exception:
If you reset the Mac Security to an “Anywhere” setting, you can install Oracle SQL Developer on Yosemite. Just make sure you reset it to the “Mac App Store and identified developers” setting after you install SQL Developer.
If you launch SQL Developer with the Security “Anywhere” setting, it displays the following dialog:
After you launch the program, you will see the following progress dialog:
The last step of the installation launches SQL Developer, as shown below:
Click the Connections icon to create an initial connection, like the following:
After connecting to the database, you can write and execute a query as shown in the next screen capture:
Oracle Client For Mac Yosemite Mac
As always, I hope that this helps those who require an example to install SQL Server on a Mac OS.