Tag: 18.3

ORDS, SQLcl and SQL Developer 18.3 Updates (VirtualBox, Vagrant, Docker)

A few days ago we got version 18.3 of a bunch of Oracle tools.

Over the weekend I updated some of my VirtualBox and Vagrant builds to include these versions. If you want to play around with them you can see them on GitHub here.

I also updated my ORDS Docker container build, which uses both ORDS and SQLcl. You can find this on GitHub here.

I use this container for live demos of ORDS, as well as a demo for my “DBA Does Docker” talk, which I am doing at Oracle OpenWorld this year.

I put the latest versions of SQL Developer and SQLcl on my laptop. I’m doing an analytic functions talk at Oracle Code One this year. The demos use SQLcl on my laptop connecting to Autonomous Transaction Proccessing (ATP) on Oracle Cloud. I had a little bit of drama with SQLcl on Saturday, which turned out to be PEBCAK. I thought “SET ECHO ON” wasn’t working, but it turned out I had a “login.sql” file in the path that contained “SET TERMOUT OFF”. Once I removed that setting the demos ran fine. 🙂

I’m going to put a freeze on changing my stuff until after OpenWorld and Code One. Honest. 🙂

Cheers

Tim…

Installation of Oracle Database 18.3.0 On-Prem for Linux

Hot on the release of Oracle Database 18.3.0 On-Prem for Linux, I got on the case with doing some installations. The first of which can be found here.

I few things to point out about these…

First, I’ve gone with a read-write Oracle home. I like the idea of the read-only home, but I’ve not played around with it enough at this point to commit.

The other thing is the Oracle home path itself. Currently I’m using “18.0.0”, rather than “18.3.0”. This feels a little strange to me, but I’m not sure how the Release Updates (RUs) will work out for this. I’m guessing what I’ll end up doing is creating a new Oracle home when a RU drops, then switch across to it, so it would be more appropriate to use 18.3.0, with a switch to 18.4.0 later. I’m still trying to decide how I want to play this. If you look at the SQL*Plus banner you will see this.

Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

So neither of these choices feel bad. 🙂

I usually post pictures of the installer, but I think this is sending the wrong message. IMHO you shouldn’t be installing this way, so this time I’ve made the break and only posted the silent installation.

In addition to the articles I’ve got some Vagrant builds for it (OL7, F28). The OL7 one also includes APEX and ORDS etc.

I’ve got a couple more things in the pipeline, which will probably come out tonight. We shall see.

Cheers

Tim…

Oracle Database 18.3.0 On-Prem for Linux

I was just about to go to bed when I saw this post by Mike Dietrich. Yay!

I’ve had access to 18c on the Oracle Cloud for some time, so I’ve already been able to write a bunch of stuff about it (see here), but it always feels geekier when it’s running on your own kit. It also makes demos a little less dangerous if you can fall back to your own machine. 🙂

Of course I’m starting the downloads now, so maybe I’ll get to have a play tomorrow? 🙂 If you want it you can grab it from here.

Happy upgrading…

Cheers

Tim…