Tag Archives: 12c

A few more 12c articles

A few more 12c articles went live over the last few days… Database Migration Assistant for Unicode (DMU) in Oracle Database 12c Release 1 (12.1) Invisible Columns in Oracle Database 12c Release 1 (12.1) In-Database Archiving in Oracle Database 12c Release 1 (12.1) The DMU and In-Database Archiving are from the OCP syllabus. The Invisible Columns […]

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 […]

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 […]

Invoker Rights in Oracle Database 12c : Some more articles

I wrote about the Code Based Access Control (CBAC) stuff in Oracle Database 12c a while back. Code Based Access Control (CBAC) : Granting Roles to PL/SQL Program Units in Oracle Database 12 Release 1 (12.1) I’ve recently “completed the set” by looking at the INHERIT PRIVILEGES and BEQUEATH CURRENT_USER stuff for PL/SQL code and […]

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 […]