There a many options on how to develop with an Oracle Database. By far the smartest way is to use on Oracle Cloud service like the Autonomous Transaction Processing. And it is also free, as you can use the Oracle Free Tier. If you cannot use the Oracle Cloud, you can run the database on your laptop or on your companies servers. And you can install all your tooling also on your laptop, server or you maybe have a VM with all the tooling you need. Just make sure, that you have the required license or go with the Express Edition. See also this post for a great overview on all the options.
I personally prefer, to have everything in one VM. I can still use it while travelling with limited connectivity and I heavily rely on snapshotting my VM (and rolling back when I did something wrong ;-)
If just a running VM with everything is all you need, then read no further. Oracle offers an excellent ready-to-run developer VM with the database, tools and tutorials under
But if you, for any reason, want to build your own VM, be it for your own education or just that you want to set up things differently, then I offer a guide with this series. Most of this series is still based on Oracle 19c, but I optionally offer updated guides for the Oracle Database 23c Free Developer Release where it makes sense. So you can decide to go with the stable release or explore the features of the latest version.
If just a running VM with everything is all you need, then read no further. Oracle offers an excellent ready-to-run developer VM with the database, tools and tutorials under
But if you, for any reason, want to build your own VM, be it for your own education or just that you want to set up things differently, then I offer a guide with this series. Most of this series is still based on Oracle 19c, but I optionally offer updated guides for the Oracle Database 23c Free Developer Release where it makes sense. So you can decide to go with the stable release or explore the features of the latest version.
- Setting up Oracle Linux 8.2 in Virtualbox
- Oracle Linux 8.2 on VirtualBox - basic usability settings
- Preparing the Linux VM for Oracle DB installation
- Installing Oracle DB 19c on Oracle Linux 8.2 in VirtualBox
or
Install Oracle 23c Developer Edition in Oracle Linux 8 VM - Upgrade SQLcl to latest version
- Installing SQLDeveloper
- Installing VSCodium and the Oracle Developer Tools
- Installing Apex 22.2, ORDS 22.4 und SQLDeveloper Web
or
Installing ORDS 23.1 with Apex on Oracle Database 23c Free Developer Release - Enabling Blockchain Tables and SQL Table Macros with Oracl 19.10 Patch
- Out-of-Place updating the Developer VM Oracle Database to 19.12
