Setting Up Oracle SQL Developer on a Mac

thatjeffsmith SQL Developer 67 Comments

Tell Others About This Story:

My work machine is a Dell laptop running Windows 7. My home machine is a MacBook Air running OS X Yosemite.

98% (made up number) of the posts on this site were written using my Windows machine.

But now that I’ve discovered that my SnagIt license is also valid on my Mac, I’m trying to do more writing there. It’s also a good way to see how the other 10% of our users work, live, and breathe in SQL Developer.

Installing

We don’t have a download installation package. You just download the file from OTN, and extract it. You’ll want to extract it in your Applications space in Finder. Or just copy and paste the contents over…

I like to rename it here, so I know what version I'm opening when I access it from the Dock

I like to rename it here, so I know what version I’m opening when I access it from the Dock

Once you’ve done this, it should be ready to go. If it doesn’t work, there’s probably a Java problem. You’ll need to make sure you have java…

Getting java installed on the Mac is easy too, you can just ask for it!

Getting java installed on the Mac is easy too, you can just ask for it!

If you want to follow the official directions, these should help. Just try to get the latest JDK, 7 or 8. We’ll officially support Java 8 in the next release of SQL Developer but it’s OK to run now (note that I’m using version 4.0.3!)

If you need to mess with any of the JVM settings or even specify WHICH Java to use, you’ll need to go into your $HOME directory.

It's going to help a lot if you're already familiar with Linux commands and 'customs'...

It’s going to help a lot if you’re already familiar with Linux commands and ‘customs’…

Make It Pretty

I’m using the OS X Look and Feel – see yesterday’s post for details.

I’ve enabled font anti-aliasing – folks with Retina displays pay attention here. Apparently this can help with ‘blurry’ text.

I’ve downloaded the Droid fonts, free with Apache dist license 🙂 I didn’t know how to install fonts on a Mac until I read this great tutorial.

Anti-aliasing preference is on the 'Display' page

Anti-aliasing preference is on the ‘Display’ page

A Mac Quirk?

I like to drag and drop multiple things from the tree to an editor or a diagram.

I’ve noticed to get multi-select drag and drop to work with my Magic Mouse touchpad, I have to end the shift+select and drag from that end-point immediately and then drop where I want it – all while holding the SHIFT key…if I let go of the ‘mouse’ and then try to drag, I get back into a single selection again.

Anyways, this is probably me not reading the Mac docs or doing the right Google search, but just in case it helps you 🙂

I'd make an animated GIF, but I haven't setup Camtasia yet...

I’d make an animated GIF, but I haven’t setup Camtasia yet…

Tell Others About This Story:

Comments 67

  1. Hi, I have a strange problem, I’m executing a script on MAC sqldeveloper and getting message as no rows returned, whereas same script on same database when executed on windows machine sqldeveloper returns rows, this is happening for some tables in schema, whereas for others I’m able to extract data

    1. thatjeffsmith Post
      Author
  2. Hello,
    I have a persistent problem with sql developer. Users wants lots of data. It will run (increased the worksheet settings so that works). Then I save the script output and it will not write a large file. I cannot find a setting to change so that works. Do you know?

    1. thatjeffsmith Post
      Author
      1. Today I was writing 80,000 rows, 18 columns from 6 tables. The columns are names, addresses, dates.
        Sometimes I get a low memory warning when I have 2 scripts open.
        “Memory is running low.
        740 used of 769 Maximum MB.
        Memory can be reduced by closing applications and projects not in use.
        Memory can be increased by modifying the setting in null”.

      2. thatjeffsmith Post
        Author
  3. Hi,
    I have a question. I have downloaded and installed Oracle SQL developer and JDK but there is no Oracle Database 11 or 12 for mac version. how can I make this work??

    1. thatjeffsmith Post
      Author
  4. I just downloaded latest java JDK and oracle developer 4.1. I tried setting up connection with HR as both username and password I kept getting ‘the network adapter could not establish the connection’.

    I have used both the service name as orcl and SID as xe but I get the same error in each case.

    Somebody help me please!!

    1. thatjeffsmith Post
      Author
      1. No I guess that was the problem, I can use mysql it works fine. Plus I am currently downloading the DeveloperDay to use since I am a student and only need it to complete a class project.

      2. thatjeffsmith Post
        Author
  5. Hi all, I have small trouble with sql developer and mac. I created same local connection (same configuration) like on Windows but in OSX env it does not work ends with ‘the network adapter could not establish the connection’. Do you have any idea why it’s working for Windows but not for OSX ?

    Maybe another question. I needed to install Oracle XE for Windows but I did not install something like this on OS X on my mac. Thank you for your help.

    Lukas

  6. I have the same error Vendor code 17002″
    Have a macbook pro and installed java and sql developer just now.
    Help me what I can do to resolve this error

    1. thatjeffsmith Post
      Author
      1. I just downloaded latest java JDK and oracle developer 4.1. I tried setting up connection with HR as both username and password I kept getting ‘the network adapter could not establish the connection’.

        I have used both the service name as orcl and SID as xe but I get the same error in each case.

  7. Dear ThatJeffSmith thank you so much for this explanation.
    I still have some issues though.
    1. When I download SQL developer from OTC, the icon just appears on my download list, I open it. How do you extract it ?
    2. It just opens but is missing the connect bottom on the connection menu. It has the test bottom though
    3. When I do ls in the terminal I only see three files:
    4.1.0, system4.1.3.20.78, and tmp

    Any help is really appreciated.

  8. I downloaded SQL Developer version 4.1 Everything works fine, but I do not see the “Preferences” on the menu anymore. I need to change the NLS date format permanently which is under the Preferences, but I cannot find it. Please help.

    1. thatjeffsmith Post
      Author
      1. It is not for some strange reasons. When I go to “Tools”, it is missing the “Preferences” option on the bottom. Should I look somewhere else?

      2. thatjeffsmith Post
        Author

        Preferences isn’t on the Tools menu, on a mac. OS X standard is to put the preferences item on the application main menu, right below ‘About Oracle SQL Developer’

      3. thatjeffsmith Post
        Author

        No problem, that messed with my head when I first switched to Mac too.

        Note that your application settings will go in your OS User $home directory, in a hidden (.) sqldeveloper folder. So if you want to save your sql history or application settings, you just need to open a terminal.

  9. My Mac just upgraded to OS 10.10.5 last night and now SQLDeveloper will not open. It tries to open and then simply closes with no error or any window. I downloaded the newest version of SQLDeveloper 4.1.1.19.59 and it did not help. I have Java 8 Version 25. I believe these are now the most up-to-date version of Mac OS, SQLDeveloper, and Java. Can you at least confirm that SQLDeveloper should work? Thanks for any assistance, Cabe

    1. thatjeffsmith Post
      Author
      1. Thank you for the prompt reply Jeff. My product.conf is commented out so it uses the default. But I finally figured it out and hopefully this will help others reading this page. The Java Control Panel told me that I was using Java 8 Version 25 which I reported initially – but it turns out that is the JRE. To check the version of the JDK which is what matters to SQLDeveloper, I had to go to terminal and type “java -version” which told me I was using 1.7.0_67. I downloaded the newest version of the JDK which is 1.8.0_60 and now SQL Developer works again.

      2. I also have this issue. I just downloaded java 1.8.0_60 and when I do “java -version” is says 1.8.0_60. However I cannot get SQL Developer to open. I just got this Mac and I am trying to set it up so I also just downloaded SQL Developer. My product.config file is all commented out. I have also tried to look at the sqldeveloper.conf file and set the “SetJavaHome” there. Is there anything else you had to do to get SQL Developer running?

      3. thatjeffsmith Post
        Author
      4. So I have uncommented the line “SetJavaHome” and I have added my path, /Library/Java/Java…/jdk1.8…/. And it said that was not a path. Then I added on Contents/Home and that was “not a path”. Then I tried adding on “bin” to the end of all of that. And it still says it’s not a path. I know this is a path though because I copied it right from my JAVA_HOME variable. Do you have any other suggestions?

      5. thatjeffsmith Post
        Author
      6. Unfortunately that did not work either. I have just tried restarting my computer and still nothing. Any other suggestions? I also looked through that other page but it didn’t seem to fix my issues.

      7. thatjeffsmith Post
        Author
      8. So that did not work…
        Administrators-MacBook-Pro:bin angela.benway$ ./sqldeveloper

        Oracle SQL Developer
        Copyright (c) 1997, 2015, Oracle and/or its affiliates. All rights reserved.

        java.lang.Exception: Stack trace
        at java.lang.Thread.dumpStack(Thread.java:1329)
        at oracle.ideimpl.MainWindowImpl.(MainWindowImpl.java:166)
        at oracle.ide.osgi.Activator.setupWindow(Activator.java:281)
        at oracle.ide.osgi.Activator.start(Activator.java:135)
        at org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702)
        at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683)
        at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381)
        at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:390)
        at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1176)
        at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559)
        at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:544)
        at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:457)
        at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:243)
        at org.eclipse.osgi.framework.internal.core.EquinoxLauncher.internalStart(EquinoxLauncher.java:271)
        at org.eclipse.osgi.framework.internal.core.EquinoxLauncher.start(EquinoxLauncher.java:241)
        at org.eclipse.osgi.launch.Equinox.start(Equinox.java:258)
        at org.netbeans.core.netigso.Netigso.start(Netigso.java:191)
        at org.netbeans.NetigsoHandle.startFramework(NetigsoHandle.java:209)
        at org.netbeans.ModuleManager.enable(ModuleManager.java:1352)
        at org.netbeans.ModuleManager.enable(ModuleManager.java:1156)
        at org.netbeans.core.startup.ModuleList.installNew(ModuleList.java:340)
        at org.netbeans.core.startup.ModuleList.trigger(ModuleList.java:276)
        at org.netbeans.core.startup.ModuleSystem.restore(ModuleSystem.java:301)
        at org.netbeans.core.startup.Main.getModuleSystem(Main.java:181)
        at org.netbeans.core.startup.Main.getModuleSystem(Main.java:150)
        at org.netbeans.core.startup.Main.start(Main.java:307)
        at org.netbeans.core.startup.TopThreadGroup.run(TopThreadGroup.java:123)
        at java.lang.Thread.run(Thread.java:745)

      9. thatjeffsmith Post
        Author
      10. So if anybody else is still having issues, I just solved mine by downloading SQLDev 4.1.0 instead. Once I did that it worked perfectly!

    1. thatjeffsmith Post
      Author
  10. Hi Jeff, I’m helping a student install SQL Developer and the preferences menu is simply not there under the tools menu. We need to install the MSSQL database driver but need that menu to do so. Any thoughts?

    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author
  11. Hi, I indtalled the Sql developer VM on my Mac, but I couldnt select DB connection as SYS. I’ve tried connection name: ORCl
    Username: SYSDBA
    Basic connection type,
    Role:SYSDBA
    SID: orcl
    But it does not work. So my question how to set the DB as sys ?!
    Thnx in advance .

  12. I have OSX Yosemite (latest version) and java 1.8.0_31 (latest) installed (this is the only java version on my machine. SQL developer does not want to start. Instruction java -version in terminal indicates that no version is installed (No Java runtime present, requesting install). What should I do to get this running?

    1. thatjeffsmith Post
      Author
  13. I installed SQL Developer on my Macbook air OSX 10.10.1 ,
    but when I try to connect to DB i got the following error
    “An error was encountered performing the requested operation:

    IO Error: The Network Adapter could not establish the connection

    Vendor code 17002”

    I tried to turn off my wireless and firewall but same problem always ?!

    1. thatjeffsmith Post
      Author
      1. thatjeffsmith Post
        Author
      2. thatjeffsmith Post
        Author
      3. Thanks a lot ,
        I cannot find an Oracle Database for MAC os .. only for windows and linux , how can I can install it for MAC please

      4. thatjeffsmith Post
        Author
      5. Thanks a lot 🙂 you are the best ..
        I’ll use OTN VirtualBox image for testing and learning as you mentioned.

        Thanks again

      6. thanks it works on OTN VM fine all users , but on my mac SQL Developer connection only worked with SYS user with Role SYSDBA and SID cdb1 .. and if I tried to enter HR user it says wrong username or password.

        and user HR with SID orcl it shows an error
        Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

        I did the port forwarding

      7. thatjeffsmith Post
        Author

        Here’s what my connection looks like – SQL Dev running on the Mac, connecting to the VirtualBox VM, also running on the Mac. Note that I have port forwarding setup

        I have a couple of posts here on help with getting setup with this image and port forwarding…

  14. No Java runtime present, requesting install.
    Strange I have 1.8.0_25 installed and my ebs is also looking it and opening forms .
    I have checked in system preferences java console the security is high . I have high and very high as my options and I did check high and add the edit sites list for EBS.
    Thank you
    Krishna

  15. I am trying to instal sql developer on my mac . OS X Yosemite 10.10.1
    and I have java 8u25. My oracle apps on safari is working fine after adding to serucity list . But I am unable to open the SQL devloper applicaiton which is 4.0.3!. Please help me to get installed.

    1. thatjeffsmith Post
      Author
      1. I did as you said and I get this error
        Krishnas-MacBook-Pro:macos sai$ ./sqldeveloper.sh
        Unable to find any JVMs matching version “1.7”.
        No Java runtime present, try –request to install.
        Unable to find any JVMs matching version “(null)”.
        No Java runtime present, try –request to install.

        I am having java1.8
        I dont want to work with two java’s as my other applications will impact.
        thanks
        Krishna

      2. thatjeffsmith Post
        Author
  16. Hi Jeff,
    Thank you so much for your posts, they are very useful. One question not related to this post. How can you see the query results in two colors? I have been investigating in SQLDeveloper and I can’t find it.
    Thanks!

    1. You mean light yellow / dark yellow? That’s in Preferences, under “Database->Worksheet”, a checkbox saying “grid in checker board or zebra pattern”.

Leave a Reply

Your email address will not be published. Required fields are marked *