Tag Archives: 12c

Automatic Diagnostics Repository (ADR) in Oracle Database 12c

There’s a neat little change to the Automatic Diagnostics Repository (ADR) in Oracle 12c. You can now track DDL operations and some of the messages that would have formerly gone to the alert log and trace files are now written to the debug log. This should thin out some of the crap from the alert log […]

Oracle 11gR2 and 12cR1 on Oracle Linux 7 beta

I’ve been having a play with Oracle Linux 7 beta over the weekend. Not surprisingly my first thoughts were to install the Oracle database on it. Oracle Linux 7 (OL7) Installation Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 7 (OL7) Oracle Database 12c Release 1 (12.1) Installation On Oracle Linux 7 (OL7) […]

Some new Oracle Database 12c Articles

I’ve recently put some new Oracle 12c articles on the website. Code Based Access Control (CBAC) : Granting Roles to PL/SQL Program Units in Oracle Database 12 Release 1 (12.1) Capture Privilege Usage (DBMS_PRIVILEGE_CAPTURE) in Oracle Database 12c Release 1 (12.1) The privilege usage stuff is really cool. Normally, trying to figure out what you […]

Running scripts in CDBs and PDBs in Oracle Database 12c

You’ve been sold on the whole concept of the multitenant option in Oracle 12c and you are launching full steam ahead. Your first database gets upgraded and converted to a PDB, so you start testing your shell scripts and bang! Broken! Your company uses CRON and shell scripting all over the place and the multitenant architecture has […]

Oracle Database 12c : Some Backup and Recovery Stuff

In a previous post, I had already listed an article on backup and recovery when using the Oracle 12c multitentant option. Multitenant : Backup and Recovery of a Container Database (CDB) and a Pluggable Database (PDB) In that article I made reference to a restriction when using flashback database against a CDB with a PDB […]

Articles on Oracle Database 12c Multitenant Option

From a technology perspective, the Multitenant option is really cool, but it can be rather difficult to get to grips with some aspects of it. Everything is so intertwined and every feature in 12c somehow links back to the Multitentant option. As I’ve been working my way through the features the same pattern keeps repeating. […]

Scheduler Enhancements in Oracle Database 12c

I’ve spent the last couple of days playing around with the scheduler enhancements in Oracle 12c. Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 12c Release 1 (12.1) I guess the big news is the new “script jobs”, which are pretty cool. This kind-of passed me by until Brynn Llewellyn mentioned them at UKOUG in his Multitenant […]

Data Pump Enhancements in Oracle Database 12c

Another one to file under “Not sexy but flippin’ awesome!” If you are a DBA, you are going to spend a lot of time with Data Pump. All roads seem to lead back to it. There are some more headline worthy features, like transportable database, but the two that jumped out at me were actually […]

PL/SQL White Lists in Oracle Database 12c Release 1 (12.1)

I’ve been playing about with the ACCESSIBLE BY clause to create PL/SQL white lists in Oracle 12c. Here’s the article I wrote about it. PL/SQL White Lists Using the ACCESSIBLE BY Clause in Oracle Database 12c Release 1 (12.1) There seem to be some discrepancies in the documentation*, which I’ve highlighted in the article. Not […]

Online Move Datafile in Oracle 12c

The ability to move datafiles as an online operation is bloody awesome! It’s another one of those cool little things that you will wonder how you ever lived without. I can’t wait to move to 12c just for this feature. I could clean up so much crap so easily. Here’s a little write-up on it. […]