Happy New Year 2017!

So here we are. Another year done and a new one beginning.

I failed abysmally at most of last year’s plans (see here), so I’m not going to make any for this year.

I hope things work out for you all this next year. There will obviously be ups and downs, but let’s hope at the end of the year everything lands on the up side.

Happy New Year!

Cheers

Tim…


Happy New (more...)

Oracle Linux 12cR2 Preinstall Package

I was doing some clean Oracle Linux 6 and 7 installs today and look what I noticed in the yum repository for OL6.

Available Packages
oracle-database-server-12cR2-preinstall.x86_64 1.0-1.el6 public_ol6_latest
oracle-rdbms-server-11gR2-preinstall.x86_64 1.0-13.el6 public_ol6_latest
oracle-rdbms-server-12cR1-preinstall.x86_64 1.0-14.el6 public_ol6_latest

And for OL7.

Available Packages
oracle-database-server-12cR2-preinstall.x86_64 1.0-2.el7 ol7_latest
oracle-rdbms-server-11gR2-preinstall.x86_64 1.0-4.el7 ol7_latest
oracle-rdbms-server-12cR1-preinstall.x86_64 1.0-5.el7 ol7_latest

A quick look at the repos and it first (more...)

Books I’ve read recently…

For those that don’t know, I came to reading Fiction rather late. In September of 2006, at the age of about 37 I decided to start reading. Up until that point I had pretty much avoided reading wherever possible for most of my life. I did what I had to for my degree, PhD and job, but I was a minimum effort reader. 🙂 The first series of books I read was The Vampire Chronicles and I (more...)

PL/SQL Objects for JSON in Oracle 12cR2

I’ve been playing around with some more of the new JSON features in Oracle Database 12c Release 2 (12.2).

The first thing I tried was the new PL/SQL support for the JSON functions and conditions that were introduced for SQL in 12.1. That was all pretty obvious.

Next I moved on to the new PL/SQL objects for JSON. These are essentially a replacement for APEX_JSON as far as generation and parsing of JSON data (more...)

Happy Holidays

So it’s Christmas morning here in the UK.

I’m pretty tired after last night’s events. The night before I heard something in my ceiling, which I was hoping was mice, but suspected might be this.

Last night I put a humane trap in the attic and in the evening heard some noise as the trap was rocking back and forth. I took it outside to a hedge about 100 yards away, as suggested by a couple (more...)

APEX 5.1 Installations and Upgrades

APEX 5.1 was released for download a few days ago. I tried doing an upgrade against an installation on a VM at home and it worked fine, which was hardly surprising. 🙂

Officially I’m on holiday, but I figured I would upgrade all our Dev/Test installations while everything is quiet. Major version upgrades, changes in either of the first two numbers, require a full installation. There was no major difference between this and what I (more...)

VirtualBox 5.1.12

All I want for Christmas is VirtualBox 5.1.12…

Downloads and changelog are in the usual places.

It’s a maintenance release, containing lots of lovely bug fixes, mince pies and eggnog.

I’ve only done the installation on my Windows 7 desktop at work, which was fine. I’ll do the macOS and Oracle Linux 6 installs when I get home and update this post with the results. 🙂

Cheers

Tim…


VirtualBox 5.1.12 was first (more...)

Old Database Sessions and some more ORDS

I spent some time on two totally unrelated things at the weekend.

Old Database Sessions

We’ve been having some problems with old database sessions recently. One of our reporting servers seems to grab loads of sessions and just not let go. In many cases they seem to remain active for a long time, while doing trivial tasks. My first thought was it was a problem with the database, but there doesn’t seem to be any evidence (more...)

Oracle Database 12c on Fedora 25

I was having a play around with Fedora 25 last weekend and I just noticed there was no associated blog post about it, so here goes.

First the warning I always have to include. Do not install Oracle on Fedora before reading this! With that out of the way, let’s continue.

Since Fedora is the proving ground for future releases of Red Hat Enterprise Linux (RHEL) and I’m a fan of running Oracle on (more...)

UKOUG Tech16 : Wednesday

Similar to last year, I had a presentation on a day I wasn’t attending, so I used my “lunch break” to drive in, present and drive back to work. I did get to see a bunch of people while I was waiting for my session to start, including my dad and wife. 🙂

My session was called “Put your feet up and have a REST. Take a tour of JSON support in the Oracle database. (more...)