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. I think I am pretty good at following instructions (and also at asking follow-up questions if and as needed), so if this, or some of it, is already answered somewhere, please just point me in the right direction.Setting up SQL Developer with Instant Client on MacOSX Written by: When I tested the connection with these settings, I got the following error message: Status: Failure - Test failed: IO Error: The Network Adapter count not establish the connection. Is there anything else I need to "share" on the Windows machine to allow SQL Developer on the Mac to access the DB on the Windows machine? Then, continuing with the Connection setup: I gave it a username and password I use on the Windows machine, Port=1521, Service Name = orcl (all are the same as on the Windows machine). I am, indeed, able to see everything in this directory and its subdirectories on the Mac. On the Windows machine I shared the entire "app" directory created when I installed Oracle the path to the Oracle Home is C:\app\intro\product\12.1.0\dbhome_1\ (shown just to explain what the directory "app" is). What I tried was to set up a connection just like I did on my Windows computer: Connection Type = Basic, Hostname = the name of my laptop (as recognized on the laptop, for example, by SELECT host_name FROM v$instance ) I am able to see the Windows machine, under the exact same name, from the Mac, in a Finder window. I don't know much about networking - some time ago I got the idea, which may be wrong, that computers that share an Internet connection all have the same IP address, and I don't know if that is an issue. I wasn't able to establish a connection though, I spent an hour or so looking through the documentation but I am not able to find what I am looking for. Is that completely idiotic, or does it make sense? I was able to download and install JDK 8 and SQL Developer on the Mac, so far so good. However, they do support SQL Developer, and somehow I got the idea that it should be possible to access my DB from the Windows computer through SQL Developer on the Mac. I know Oracle no longer supports the DB on Mac. Now I would like to be able to access it from a Mac laptop, OS X / Intel 64. SQL Developer on it, too, to work with the DB. I've been using it for a while, it's all good. I installed it as a stand-alone DB (not in the CDB/PDB setup). I have Oracle 12 on my Windows 10 laptop, and it works fine. Thought I'd turn to the forum's wisdom before I spend much more time, to make sure I'm not missing some easy pointers (and/or to make sure this is even possible). I spent a few hours today trying to figure this out.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |