After unzipping, Instant Client installation instructions require creating the following symlinks: Configuring SQL Developer I unzipped both these files under /opt so my Instant Client installation directory is /opt/instantclient_11_2. I downloaded Instant Client 11.2.0.3 (64-bit – since I installed 64-bit JDK): instantclient-basic-macos.圆4-11.2.0.3.0.zip and instantclient-sqlplus-macos.圆4-11.2.0.3.0.zip to be precise. SQL Developer 4.0 requires Oracle Client 11.2.0.3 and that is available for MacOS. There is another reason to choose SQL Developer 4.0 over 4.1 – 4.1 requires version 12.1 of the Oracle Client and that is not yet released for MacOS. When I’m writing this, SQL Developer 4.1 is in Early Adopter release and 4.0 is in production. JDKįirst you need Java installed, I installed 64-bit JDK8, but it would be better to install 64-bit JDK7, since SQL Developer 4.0 is not supported on JDK8. Jan Karremans just today published a similar article about Mac and Instant client, but the goal of my blog post is to get SQL Developer connected through Instant Client. If you find any mistakes here, please let me know – I’m new to the world of MacOS □ Here I’m trying to share my experiences if anybody else find themselves in the similar situation. Being new to Macworld and not finding any guides for this task online, it was quite a struggle in the beginning. One part of setting up my new laptop was also setting up SQL Developer WITH Oracle Driver, because a year or two ago I rolled out radius authentication for all users who need to access the production databases directly and radius (and other non-default-password authentication schemes) do not work with thin JDBC driver. I’ve never been a Mac user, but there seems to be a large group of people who think Macs are the best, so I needed to find out the goodness of Macs myself □ A quick tip: Don’t upgrade to Yosemite if you laptop is bound to Active Directory. Since I started a new job I also wanted to try out MacBook as my new laptop. Setting up SQL Developer with Instant Client on MacOSX Written by:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |