Movatterモバイル変換


[0]ホーム

URL:


Skip to content
DEV Community
Log in Create account

DEV Community

Cover image for 5 ways to get an Oracle Database
Gerald Venzl 🚀
Gerald Venzl 🚀

Posted on • Edited on • Originally published atblogs.oracle.com

     

5 ways to get an Oracle Database

Do you want to get your hands on an Oracle Database but don't know how? Here are5 ways to get you going:

LiveSQL

Do you just want to type some awesome SQL and need a database to do so? ThenLiveSQL.oracle.com is your friend. LiveSQL is a browser-based SQL scratchpad that not only allows you to pull off some SQL magic but also to save and share your scripts with others. It also comes with a comprehensive library of tutorials and samples. LiveSQL is the best place for anybody that is completely unfamiliar with Oracle Database and wants to get going.

LiveSQL

Docker/Container image

If you want to have an Oracle Database on your machine instead, but don't want to worry about setup and configuration, the Oracle provided Docker images are a good choice. All you need is to install Docker, Podman or an equivalent on your machine (Mac orWindows) and pull the Oracle Database image fromOracle's Container Registry. From then on, all you have to remember is:

docker run--name oracle-p 1521:1521 container-registry.oracle.com/database/free:latest
Enter fullscreen modeExit fullscreen mode

and

docker start oracle
Enter fullscreen modeExit fullscreen mode

Oracle Database in Docker

Docker is great for running one or many instances and versions of an Oracle Database on your machine without having to know how to operate (start/stop/setup) them. What you end up with is still a full-fledged Oracle Database.

Vagrant box VM

If you want to have an Oracle Database on your machine, but you prefer to run it inside a Virtual Machine, then the Oracle provided Vagrant scripts will do a great job. HashiCorp'sVagrant is a great tool to provision repeatable VM environments, includingVirtualBox VMs. For this scenario, you will need to installOracle's VirtualBox andHashiCorp's Vagrant on your machine first. Once you have done that, provision a VM via the scripts from theOracle Vagrant Boxes GitHub repo and let Vagrant take care of the rest. All you have to remember is:

vagrant up
Enter fullscreen modeExit fullscreen mode

and

vagrant ssh
Enter fullscreen modeExit fullscreen mode

Oracle Database with Vagrant

The Vagrant box is great if you want a scripted and repeatable way of creating a VirtualBox VM that contains an Oracle Database. You can also provision multiple VMs with different versions of the Oracle Database. The VM comes with port forwarding enabled by default, which means that you are able to connect any of your tools from your host directly, say SQL Developer for example, to the database inside the VM and treat the VM like a little embedded server.

Database App Dev VM

If you like the VM approach but don't want or need the repeatable nature of Vagrant, then theOracle Database Application Development VM is the right choice for you. Simply download the .ova file, import it into VirtualBox, and start the VM. The VM will boot into a graphical Linux desktop.

Oracle Database App Dev VM

The Oracle Database App Dev VM comes with tools like SQL Developer and Oracle REST Data Services preinstalled, which makes it a great self-contained, one-stop-shop VM. It too has port forwarding enabled by default, in case you want to connect your tools from your host directly. Another bonus of the App Dev VM is that it also includes some hands-on labs that you can go through.

Always Free Oracle Autonomous Database

If you want an Oracle Database but not on your laptop, then you should check out theOracle Cloud Free Tier which includes an Always Free Oracle Autonomous Database. Once you have signed up for the free tier and provisioned your Always Free Autonomous Database, you can head over to SQL Developer Web and get going.

Always Free Autonomous Database

The Always Free Tier Oracle Autonomous Database is great if you want the latest and greatest what Oracle has to offer in terms of cloud databases. SQL Developer Web and APEX come out of the box and you can connect any other app or IDE from anywhere around the world, as long as it has access to the internet. And the best part, as long as you use the database, it stays with you forever!

Now, what you are waiting for? Get yourself an Oracle Database!

Top comments(0)

Subscribe
pic
Create template

Templates let you quickly answer FAQs or store snippets for re-use.

Dismiss

Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment'spermalink.

For further actions, you may consider blocking this person and/orreporting abuse

Common-Sense Developer, Oracle Expert, Performance Enthusiast, Technology Geek and Creator of #csv2db."Write code to solve problems, not to create them!"
  • Location
    San Francisco
  • Work
    Developer, Tinkerer, Product Manager
  • Joined

More fromGerald Venzl 🚀

DEV Community

We're a place where coders share, stay up-to-date and grow their careers.

Log in Create account

[8]ページ先頭

©2009-2025 Movatter.jp