Video : Multitenant : Refreshable PDB Switchover in Oracle Database 18c Onward

Today’s video is a run through the Refreshable PDB Switchover feature introduced in Oracle 18c.

I also have a Multitenant YouTube playlist.

If you prefer reading over watching a video, you can find all the information and more here.

The star of today’s video is Kamran Agayev A. When he’s not working with Oracle technology and helping people to pass their OCM exam, he’s choking people out at Brazilian Jiu Jitsu. 🙂

Cheers

Tim…

Oracle 18c and 19c on Oracle Linux 8 (beta)

Fresh on the back of yesterday’s Fedora 30 post, I noticed a post from Avi Miller about the release of Oracle Linux 8 Beta. I had a day off work, so once I had finished the Fedora 30 builds, I started on the Oracle Linux 8 builds.

It should be obvious, but this is a beta release of the OS, so everything below is just me playing. It will all have to be done again, and done “properly” once the final release appears. Even then, it will be a while before anything is certified against the new OS, so don’t take this seriously.

I’ve pushed some stuff up to GitHub. It uses a Vagrant box I created myself, in the same way I wrote about here.

I think it’s time I did something “real”, rather than playing around with stuff that doesn’t relate to something I would do at work. 🙂

Cheers

Tim…

Oracle 18c and 19c on Fedora 30

As is customary, Fedora 30 has been released and I’ve done some Oracle installations on it.

Before we get to the good stuff, let’s do the warnings.

With that out of the way, here are the articles.

Not surprisingly, things feel pretty similar to Fedora 29 from an Oracle perspective. There are a few small edits to the process due to the package changes with this OS version.

I’ve pushed some stuff up to GitHub, but there is no Vagrant box available for Fedora 30 yet, so I had to create my own, in the same way I wrote about here.

So now you know how to do it, please don’t. 🙂

Cheers

Tim…

Video : JSON_EQUAL Condition in Oracle Database 18c

Today’s video is a demonstration of the JSON_EQUAL condition introduced in Oracle 18c.

If videos aren’t your thing, you can read about it here.

The star of today’s video is Patrick Hurley, being a little over-dramatic. 🙂

Cheers

Tim…

Oracle OpenWorld and Code One 2018 : Oracle ACE Director Briefing (and 18c XE)

I woke up at 02:00. I tried to got back to sleep, but by a little after 03:00 I gave up and got out of bed. I hit the gym for a while, but felt pretty dreadful.

I mentioned yesterday, I had helped some people with setting up Oracle Cloud. Since I was awake I grabbed some screen shots and wrote a couple of small posts so I could forward them to one of the folks, so they could remember what we did. These along with a couple of other posts I released a few days ago pretty much show how we set up a demo environment in a few minutes..

Pretty soon it was time to go down to the Oracle ACE Director Briefing…

Like yesterday, the meeting was covered by a Non-Disclosure Agreement (NDA), so there isn’t really anything I can say about it, but during the briefing we were told Oracle Database 18c Express Edition (XE) had been released for download. I had previously done an 18c RPM installation on Vagrant, so it was pretty simple to modify it to do the XE installation in a similar way and leave it going while I was watching the sessions. Yay! Go automation! 🙂

I did my thing of not eating again, so I could stay awake during the meeting. By the end of the last session I felt pretty hungry, so I picked up a bag of cheese flavoured popcorn and downed that before heading to Chipotle (again). I think I’m done with Chipotle now. My vegetarian burrito had a huge chunk of meat in it, which I bit into and spat out. If it had been at the start of I would have demanded a new one, but as I had nearly finished I just walked up to the counter and said, “This is a vegetarian burrito and that is meat. Sort yourself out!”, then left in a bad mood.

I got back to the hotel and had about an hour before 19:00, when I was meant to go and meet people at some place about a block down the road. I made the fatal mistake of lying on the bed to watch TV for a bit, and waking up at 04:00 the next day. Sorry folks! 🙁 The fact I slept for about 10 hours, which is extremely rare for me, kind-of shows you were I was at by this point. 🙂

So that’s the first two days of briefings done. Tomorrow (today by the time you read this) is a “day off”, but I do have an event in the middle of the day and a dinner in the evening. I’ve also got to go through my three (and a bit) talks, because once the conference starts, there’s no telling when I will get time…

Cheers

Tim…

PS. I was forced to “disappear” Maria Colgan from the family because she came into the room and didn’t come immediately to say hello to me. If she is really good, and I don’t replace her with someone else, she may be allowed back into the family at some point in the future… 🙂

Oracle Database 18c “Hands-Off” Data Guard Build Using VirtualBox and Vagrant

I wanted to try something with Oracle 18c Data Guard, so I thought I might as well create a hands-off build of it using VirtualBox and Vagrant, much as I did with my recent hands-off RAC build.

I did the 18c build and figured I might as well do 12cR2 and 12cR1 builds too, as they were pretty similar. I could have done them as a single build with a few tweaks to sort out the differences, but I couldn’t be bothered. 🙂

Along the way I noticed I hadn’t done a 12cR2 data guard article, so I did these.

Cheers

Tim…

Oracle Database 18.3.0 and Docker

Just a quick heads-up to let you know I’ve updated my Docker builds to use the new 18c on-prem software.

If you like to play around with Docker, here is some stuff you might want to check out. Remember, I’m not saying this is production ready. It’s just stuff I use for learning and demos…

  • My Docker GitHub Repo here.
  • The new 18c container build here.
  • The new Docker compose file here to fire up an 18c DB container and a Tomcat 9 + ORDS 18.2 container to front APEX 18.1, and allow you to play with ORDS.

Remember, if Docker is not your thing, you can always my Vagrant build here to fire up the same thing, but in a single VirtualBox VM.

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…

Nobody is an expert at Oracle Database 18c

Every time a new database version is released a group of people, myself included, start pushing out content about it. I can guarantee you one thing about all these people. None of them are experts at Oracle 18c! There isn’t a single expert at 18c on the planet. Not even in Oracle. To be honest, I would say there are very few people who could really call themselves experts at 12cR2 at this point. Why? Because it takes time to get good at stuff and even 12cR2 hasn’t been out that long. It’s about 1 year since it was released for use on-prem (see announcement). Yes, it was around on cloud for a while before then, but most folks have had 12cR2 for 1 year and that’s it. Most people writing about 18c have had it for a few days tops. 🙂

So you’ve got one year of experience at 12cR2 right? I’m not so sure. You see you’re probably spending a lot of time working on 11gR2 and/or 12cR1 instances, as well as the odd 12cR2 instance that has made if to production. Humans are pretty lazy, so you are probably still doing a lot of stuff “the old way”.

I mentioned on a recent mailing list conversation, my approach to a new version is as follows.

  • I stop using the old version for my non-work environments. I’m 100% on the new version from day 1.
  • I try to move to the latest version as quickly as possible for work, with the necessary application testing of course.
  • I try to use the new version as “vanilla” as possible. Defaults for everything. I try not to bring my old habits with me to the new version.
  • I use all the new features (that I am licensed for), including all the automated features that are available. For example, when multitenant came out, after a small period of denial, I committed myself to it. My default stance was I will use it (lone-PDB for free) unless (A) a vendor doesn’t support it, or (B) I find an issue that means switching to it will be a problem for that project.

I’ve been doing this for a long time and this approach has served me well, but I still think it takes me a few years before I feel really confident with a new version.

I don’t think many of the good content producers throw around the term “expert” very often, but I think some of the people who follow can have unrealistic expectations when they look at content on the internet. Most people are writing about something new they are doing, so at the point they are writing it, they are far from being experts. If you’re lucky they will go back and revise that content when they learn more, but more often than not they don’t. As a result, you are often following the guidance of a first-time user. 🙂

So when you ask me to help you with your implementation of Data Guard between two 18c Exadata machines, you’ve got to realise how naive that question is. There will be lots of people and companies who will happily take your money to learn the new tech, but that’s probably the subject of another post… 🙂

Cheers

Tim…