Oracle Database 19c (19.3) : Installations, RAC, Data Guard etc.

A few weeks ago I put out a post about 19c installations and all that good stuff. That post was using the 19.2 release, which was not the official on-prem release of the product. Now Oracle 19c (19.3) has dropped and is available from here, and here, this post is just to say all those builds have been updated to use this 19.3 release. I also noticed the 19c preinstall package is available from yum.oracle.com.

Not surprisingly, I took the Vagrant and Docker builds I did for 19.2 and just changed the environment variables holding the software zip names, and everything worked just fine. Here are the associated articles, with those minor edits to reflect this version change.

I’ve committed a whole bunch of stuff to GitHub.

  • Vagrant build of 19c on OL7 with APEX and ORDS (here).
  • Vagrant build of 19c on Fedora 29 (here).
  • Vagrant hands-off build of 19c RAC on OL7 (here).
  • Vagrant hands-off build of 19c Data Guard on OL7 (here).
  • Docker 19c on OL7 build (here).
  • Docker 19c RPM on OL7 build (here).
  • Docker compose (here) and swarm (here) stacks.

Automation is awesome! 🙂

Cheers

Tim…

Java and Tomcat Updates : Vagrant and Docker

Yesterday was another update frenzy.

I already mentioned the update to VirtualBox 6.0.6 in yesterday’s post.

At the same time we got the quarterly updates to Java and I noticed a new version of Tomcat, so I downloaded OpenJDK 12.0.1 and Tomcat 9.0.19 and added them to my Vagrant and Docker builds.

If you are interested in this stuff, you can check it out here.

Remember, this is just my playground stuff. If you find it useful, that’s great. If not, there are plenty of other people messing about with this stuff. 🙂

Cheers

Tim…

The Art of Miscommunication : About that thing from last week…

One of the things I get all the time is an apparent continuation of a conversation I was in some time ago, and I’m meant to pick up the thread without any explanation or context.

Depending on the people you are dealing with, this can be quite an easy trap to fall into. As a DBA that looks after many instances of multiple database engines, middle tier technologies and load balancers, I tend to get pulled into loads of conversations. For the person in question, let’s say a developer working on one project, they see this interaction as a one-to-one relationship between them and me, but for me it’s a one-to-many, as I’m dealing with many such conversations at the same time.

When I’m in that position I’ve stopped trying to figure it out, and now the conversation goes something like this.

  • Person : You know that thing we were talking about last week?
  • Me : No.
  • Person : You know, that thing…
  • Me : I literally have no idea. Please explain…

In some situations, it turns out it wasn’t even me they had the conversation with, or I wasn’t copied into the emails. A fact that only becomes evident when they take the time to order their thoughts…

I’m generally pretty happy to help people out, but I’m not going to go through hypnotherapy to pull back distant memories in order to continue a conversation you think I should remember. As you saw from my previous post on this subject, I expect each interaction to be self-contained. If there is any context necessary, it should be in the interaction itself. I shouldn’t need the skills of Professor X to pull it out of your head…

So before you pick up the phone, start typing on chat, or begin an email, take a second to plan the conversation in your own mind.

  • What introduction is necessary to get people up to speed?
  • Is there any prior knowledge I’m assuming, that I probably shouldn’t?
  • What is the main purpose of this interaction?
  • What are the outcomes I’m looking for?

It will only take a couple of seconds to figure this out. I’m not asking you to spend an hour preparing for a five minute chat, but don’t just launch into a stream of consciousness and expect everyone else to jump back in at exactly the same spot they left.

Cheers

Tim…

ORDS, SQLcl and SQL Developer 19.1 Released, and some Vagrant and Docker Stuff

Yesterday Kris Rice put out some tweets to say ORDS, SQLcl and SQL Developer version 19.1 had been released.

As usual I downloaded SQL Developer and put it on my desktop, and I started the process of updating my Vagrant and Docker builds. If you are interested in that stuff, you can find those updates here.

You won’t be surprised that these updates are pretty simple. Just replacing the environment variables with the new version numbers. Such are the joys of automation. 🙂

Happy upgrading!

Cheers

Tim…

Video : JSON_MERGEPATCH Function in Oracle Database 19c

Today’s video is a run through the JSON_MERGEPATCH function, which was introduced in Oracle 19c.

For those that don’t do video, this was based on the following article.

The star of today’s video is Rene Antunez.

Cheers

Tim…

Oracle Help Center of the Future: Reimagining Documentation (COLLABORATE 19)

If you follow me on Twitter you will know I recently had a conference call with the Oracle Documentation folks. We were discussing a number of points, some of which were related to a blog post of mine here.

Following that Roland Mcleod from the team mentioned they would be at Collaborate 19. This is an ideal opportunity for people to give their feedback directly to the team, and help shape the future of the documentation. Please go and speak to them, and give some constructive feedback about the documentation for whatever Oracle products you work with. Let them know what you like, dislike and how things would work better for you! It’s important they understand how you like to consume information, if you want the documentation to improve.

It’s also important that a variety of people get involved. Young, old, experienced and fresh to the game. We all like to consume information in a different way, and it’s important the documentation works for everybody.

I also said I would give their Collaborate 19 sessions a shout out, so here is what Roland sent me.

Can you reimagine Oracle Documentation and Help?

The Oracle Help Center is undergoing a complete redesign. We need all customers, partners and consultants to help us make it work for you.

Please attend one of our sessions and come by to see us at the Oracle Exhibit Area: Oracle Help Center Ambassadors!

Session ID: 112040
Oracle Help Center of the Future: Reimagining Documentation
10:30 AM–11:30 AM Apr 8, 2019
CC 2ND FL 225B

Oracle Help Center of the Future: Reimagining Documentation
3:15 PM–4:15 PM Apr 8, 2019
CC 2ND FL 225B

Session Abstract: In this interactive session; you’ll have an opportunity to provide your feedback about the current and future Oracle Help Center (docs.oracle.com). You will be invited to share how you use documentation in your role and at your organization. This session includes a brief preview of the future Oracle Help Center experience.

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…

The Oracle ACE Program : My 13 Year Anniversary and Website History Lesson

Another year has gone by, and somehow I’m still doing this. 🙂

As I’ve mentioned numerous times, last year was tough year for me. So far this year is going better. That’s partly because I’ve reduced the amount of travelling I’m planning to do, which has freed me to do more fun stuff, like writing and doing the odd video.

As usual I’ll mention some of the other anniversaries that will happen throughout this year.

  • In July I will hit the big five zero.
  • 24 years working with Oracle technology in August. (August 1995)
  • 19 years doing my website in July. (Original name: 03 July 2000 or Current name: 31 August 2001)
  • 14 years blogging in June. (15 June 2005)
  • 13 years on the Oracle ACE Program. (01 April 2006)
  • A combined 2 years as an Oracle Developer Champion, now renamed to Oracle Groundbreaker Ambassador. (21 June 2017)

I thought it would be fun to do a little time travel and look at the website over the years. There were a few really bizarre things I tried out in the early days, including a Gothic horror theme, but I don’t have a record of them and the Way Back Machine only goes back to 2001. You know you are old when the Way Back Machine can’t go that far back! 🙂

So skipping the first year of existence and starting in 2001 the site looked like this.


This was still using the old name before I switched to the current name and URL.

Later in 2001 I started putting the latest articles on the front page and the menu includes link to my Oracle 9i articles. Bleeding edge! 🙂

Things stayed pretty similar looking until 2006, where a new column was added to the front page. I put a rating system in place for the articles, but didn’t know how to stop the search engine spiders from clicking them, so pretty much everything got something like a 2.5 star rating. I quickly removed that and salvaged what little pride I had left.

In 2010 I tried to clean up the look of the site a lot. I removed the left had menu bar and used tabs and quick links instead. I think this was the beginning of the site looking a little more like it does today.

In 2011 I got a bit sick of the washed out colours and increased the contrast. The basic layout is the same though.

Things stayed pretty much the same until 2015, when I switched the site over to use Bootstrap 3. Prior to this I was forever tweaking things for browser compatibility, and having a responsive design was way beyond my meagre web skills. Bootstrap solved loads of problems for me.

The upgrade to Bootstrap 4 a few days ago made some slight changes, but I’m guessing hardly anyone would notice.

This time next year, the site will look … exactly the same. 🙂

Cheers

Tim…

APEX 19.1, Vagrant and Docker

Last night Joel Kallman announced the release of APEX 19.1.

It wasn’t exactly a surprise as the APEX 19.1 Early Adopter site was shutdown and there was a maintenance window on apex.oracle.com, which is running APEX 19.1.

I downloaded the 19.1 software and plugged though my Vagrant and Docker stuff bringing it up to date. If you are into that stuff you can find it on my GitHub.

I guess this means I can start the process of upgrading everything at work on Monday. 🙂

Cheers

Tim…

General Website News

Hopefully you won’t have noticed, but there have been a few changes to the website over the last week.

I started the process of moving to Bootstrap 4 and FontAwesome 5 when they were released, but kind-of lost momentum. This stuff is a “necessary evil”, rather than something I’m actively interested in. A couple of early trials proved it wasn’t just a case of using the new versions. I had got about 90% of the way there, but couldn’t force myself to complete the last bit.

Recently I had some advice from a couple of people at work who know more about this sort of thing than me. They quickly pointed out some glaringly obvious flaws in what I was doing, which focused me somewhat. I finally bit the bullet over the weekend and flipped to the new versions. There were a few “interesting” things along the way, including me forgetting to style CODE and PRE tags, which are kind-of important for a website that is almost entirely about code samples. 🙂

I’m sure there will be tweaks over the coming weeks, but I think it’s sorted now. I’m guessing if I hadn’t mentioned it, most people wouldn’t know it had happened. 🙂

Much as this stuff is “not my thing”, but it is good to keep an eye on how things change over time. I now know enough to know I don’t know enough though… 🙂

Cheers

Tim…