I get the following error: This webpage is not available However, when I try to browse to any of the following addresses in Chrome, from my host: My understanding is that the -p switch will map a port on the host (8080) to a port inside Docker (2368), so that I can hit the web server running within Docker, from outside docker, i.e. When the logs read “Database ready to use.I have pulled a Docker image: $ docker pull ghostĪnd run a container from the image: $ docker run -name test-ghost -p 8080:2368 -d ghostħd984e974f6a75fe18b3d397b5c8f0a428928a2be9df83f0d61a679aa5f537fc Open Kitematic, select your Oracle container, and click “Start”. This means that you are trying to connect with SQL Developer, but your Docker container is stopped. IO Error: The Network Adapter could not establish the connection.Execute the following in a SQL worksheetĬhange SALES to whatever database name you want CREATE USER SALES 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”. In Oracle 12c, users and databases are essentially the same thing.If you didn’t get a success message, double-check your IP address and username/password combination. If the message in the lower-left corner reads “Status: Success”, you’ve done it correctly. When you’ve filled all that out, hit “Test”.The default credentials to connect are as follows:.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.In SQL Developer, click the green plus button to create a new connection.Unzip, drag the app into the Applications folder, and fire it up.You’ll have to create a quick account to continue through the download (very annoying, I agree). Head to this page, click the Agree button and hit Download.Just wait until the log reads: DATABASE IS READY TO USE! The first time you start the container, it will take a 5-10 minutes for the database to build. Open Kitematic and find the container we just created.If you get no errors Docker is installed correctly and running.ĭocker run -d -p 8080:8080 -p 1521:1521 -e ORACLE_PWD = 'Password1' -v ~/oracle_data/:/u01/app/oracle hothamandcheese/oracle-18.4.0-xe ![]() Open the Terminal app and run the following.You’ll install a tool called “Docker Toolbox” which includes everything you need.ĭownload and install “Docker Toolbox” here. ![]() You can still run Docker, but there will be a few extra steps. Install Dockerĭownload and install “Docker for Mac” from here (You’ll have to create a quick account to download it. This is a much lighter way of running Oracle locally compared to running a full Windows virtual machine with VMWare or Virtualbox. 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. If you need to run 12c specifically, you’ll need to look for instructions elsewhere. I have updated the instructions to work again, though the image it uses now runs Oracle 18c. The Docker image that was being used was deleted by the author and so was not usable. Update: This article originally contained instructions for running Oracle 12c. ☁️ New Hetzner users get €20 in free cloud credits! ☁️
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |