Installing Sql Developer On Parallels For Mac

Posted on by

In this section, you will get SQL Server 2017 running on Docker on your Mac and then you will install the necessary dependencies to run GoLang. Step 1.1 Install SQL Server In order to run SQL Server on your Mac, we are going to use the SQL Server on Linux Docker Image.

  • 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’.
  • Aug 23, 2007  Excited I am.I have been able to connect JDeveloper to a Oracle XE database running under Parallels for Mac on on MacBook Pro 17' with a 2.33GH Intel Duo Core processor.

Installing Sql Developer On Ubuntu

Update: May 14, 2019This article originally contained instructions for running Oracle 12c. The Docker image that was being used was deleted by the author and so was not usable. I have updated the instructions to work again, though the image it uses now runs Oracle 18c. If you need to run 12c specifically, you’ll need to look for instructions elsewhere. Some screenshots may now be out of date.

In this post, we will go through the steps of installing Oracle 12c in a Docker container and connect to the database using SQL Developer on a Mac. This is a much lighter way of running Oracle locally compared to running a full Windows virtual machine with VMWare or Virtualbox.

1. Install Docker

- If your Mac is newer than 2010
You can simply install “Docker for Mac”.Download and install “Docker for Mac” from here (You’ll have to create a quick account to download it. Annoying, I know)

- If your Mac is 2010 or older
You can still run Docker, but there will be a few extra steps. You’ll install a tool called “Docker Toolbox” which includes everything you need.Download and install “Docker Toolbox” here.

2. Pull Docker image

  • Open the Terminal app and run the following. If you get no errors Docker is installed correctly and running.
  • Pull the Oracle image by running

3. Create container

  • First we create a directory outside the Docker container to store the database
  • Then we create a new container with our downloaded image

This should return a long hash string.

Oracle

Scripts are disabled!

  • Open Kitematic and find the container we just created.
  • Click the “Start” button. The first time you start the container, it will take a 5-10 minutes for the database to build. Just wait until the log reads: DATABASE IS READY TO USE!

4. Install SQL Developer

  • Head to this page, click the Agree button and hit Download. You’ll have to create a quick account to continue through the download (very annoying, I agree).
  • Unzip, drag the app into the Applications folder, and fire it up

5. Connect to Oracle database

  • In SQL Developer, click the green plus button to create a new connection.
  • If your Mac is 2010 or older: Get the IP address of your Oracle container by opening Kitematic and switching to the Settings and then Hostname / Ports. Use this in the next step for Hostname.
  • The default credentials to connect are as follows:
    • Connection Name: Whatever you want. I suggest “Docker - Oracle System”
    • Username: system
    • Password: Password1
    • Hostname: localhost
    • Port: 1521
    • SID: xe
  • When you’ve filled all that out, hit “Test”. If the message in the lower-left corner reads “Status: Success”, you’ve done it correctly. Hit Save and then Connect. If you didn’t get a success message, double-check your IP address and username/password combination.

6. Creating new databases

  • In Oracle 12c, users and databases are essentially the same thing. So to create a new database, we’ll create a new user with the following SQL queries, assuming we want to create a database with name “SALES” and password “password”. Execute the following in a SQL worksheet

Change SALES to whatever database name you want

Sql developer for mac

Potential Problems

  • IO Error: The Network Adapter could not establish the connection

Download Sql Developer For Mac

This means that you are trying to connect with SQL Developer, but your Docker container is stopped. Open Kitematic, select your Oracle container, and click “Start”. When the logs read “Database ready to use. Enjoy! ;)”