Late yesterday the breaking news was our 23c Free – Developer Release. Here’s the press release.
Oracle Database 23c Free – Developer Release is the first release of the next-generation Oracle Database, allowing developers a head-start on building applications with innovative 23c features that simplify development of modern data-driven apps. The entire feature set of Oracle Database 23c is planned to be generally available within the next 12 months.
TL;DR Watch the Movie!
We’ve updated our VirtualBox Appliance
What it has and what you need to use it
You need – at least 4 GB of RAM to run the image. That’s 4GB of RAM you’re not currently using. You’ll need at least 20 GB of disk space for the files once imported to the VM. Finally, you’ll need an x64 Pentium based piece of hardware.
You get –
- 23c, specifically 23.2 installed with a PDB already created
- the pdb has sample schemas and their data pre-loaded
- ORDS 23.1 installed, configured, and running
- HR user is REST Enabled, you can can login to SQL Developer Web
- APEX 22.2 is installed
- local port forwards for 8080 and 1521, so you can use your desktop database tools and browsers to work with the database
If you want to use the Oracle Linux 8.7 desktop and terminals directly, have at it! But I can say with confidence the BEST way to use this is from your host, merely connecting to the database that’s running on the VM.
The Linux Desktop
What it looks like on my Mac Mini 2018 –
SQL / as SYSDBA
If you use SQLcl on the virtual machine, the environment is setup (via TWO_TASK) to have you login directly to the PDB. So if you want to login to the Container via
sql / as sysdba
The Container or CDB is called ‘FREE’ and the Pluggable Database or PDB is called ‘FREEPDB1.’ So connecting looks like this –
SQL Developer Web & APEX from your Host Machine
There’s a port forward from your host to the VM on 8080. So I can simply pull up http://localhost:8080/ords/sql-developer to pull up SQL Developer Web.
And if I go to a SQL worksheet, I can start playing with 23c features, as discussed in the New Features Guide Docs.
Yes, APEX is there too!
What a SQL Developer Desktop Connection Looks Like
What it looks like in the upcoming SQL Developer Next 🙂
Where do we go for 23c Free – Developer Release help?
Report your feedback, questions, bugs, enhancement requests, etc on the Forums.
The first community member to report an issue was Lukas!