Tag Archives: Oracle

OTN APAC Tour 2014

As well as losing the ACED OpenWorld confirmation email, it turns out my website/mailbox move also caused me to lose the email about being accepted on the OTN APAC Tour 2014. I saw a tweet this morning saying that I was on the agenda for the NZOUG event and checked with Francisco to see what was […]

ALS (No) Ice Bucket Challenge

Ronald Vargas challenged me to the ALS Ice Bucket Challenge. Unfortunately we didn’t have any ice, but the water was cold anyway, as you can see by my reaction at the end. I challenge Debra Lilley, Graham Wood and Heli Helskyaho. Please don’t forget to donate! Cheers Tim…

Multitenant : PDB CONTAINERS Clause

I forgot to mention, I put another multitenant article live at the weekend. Multitenant : PDB CONTAINERS Clause in Oracle Database 12c Release 1 (12.1.0.2) I’m not sure I will ever use it, but it’s good to know it’s there. I was originally working on an article on a completely different multitenant feature, but the […]

Oracle Midlands : Event #5

Just a quick reminder that Oracle Midlands Event #5 is just around the corner (Tuesday 16 September). Boost Performance by Clustering Data – Martin Widlake Data Virtualisation and Instant Cloning – Ron Ekins (Delphix) Martin is always good value, so I’m looking forward to that session. I’ve seen a couple of talks on the Delphix stuff and it is seriously […]

To PDB or not to PDB : The final decision

After yesterday’s to PDB or not to PDB post, I decided the answer was “to PDB”. Here’s what I did… Installed the Oracle 12c (12.1.0.2) software. There is an installation article here, but all I had to do was a software-only installation because the OS already met all the prerequisites because of the existing 11.2.0.3 […]

To PDB or not to PDB

I’m about to start a Proof of Concept (POC) for a 12c upgrade of one of our databases. The production database in question is running on Oracle Linux inside a VMware virtual machine, so the starting point I’ve been given for the POC is a clone of the whole VM… Probably the biggest decision I’ve got to […]

More Oracle Multitenant Changes (12.1.0.2)

When I wrote about the remote cloning of PDBs, I said I would probably be changing some existing articles. Here’s a change I’ve done already. Preserve PDB Startup State (12.1.0.2 onward) There are also new articles. Multitenant : Metadata Only PDB Clones in Oracle Database 12c Release 1 (12.1.0.2) Multitenant : PDB Subset Cloning in Oracle Database […]

MySQL Upgrades

I read Wim Coekaerts post about the MySQL 5.6.20-4 this morning. I logged on to my server and did the following command as root. # yum update -y That’ll be the upgrade done then… If you are using MySQL on Linux you can use the MySQL Repository for your distribution, rather than using the bundled MySQL […]

EM Cloud Control 12c : The 24 Hour DBA

I think I’ve lived through all the ages of Enterprise Manager. I used the Java console version back in the days when admitting you used it got you excommunicated from the church of DBA. I lived through the difficult birth of the web-based Grid Control. I’ve been there since the start of Cloud Control. I’ll […]

Oracle 11gR2 and 12cR1 on Oracle Linux 7

I did a quick update of my Oracle installation articles on Oracle Linux 7. The last time I ran through them was with the beta version OL7 and before the release of 12.1.0.2. The installation process of 11.2.0.4 on the production release of Oracle Linux 7 hasn’t changed since the beta. The installation of 12.1.0.2 on Oracle Linux […]