Category DB12c
Migrate Enterprise Manager 12.1.0.4.0 to a PDB from a non-CDB
One of the things I’ve been eager to try with the latest (12.1.0.4.0) EM release was to change the repository from a non-CDB to a PDB. There’s a note in the EM documentation that discusses migrating the SYSMAN schema option mentioned here. As a mentionable note, Martin Bach wrote a post on switching the repository […]
DB12c: ORA-19504: failed to create file "+DATA" While Creating Pluggable Database Manually
In my previous post on DB12c, while manually creating a pluggable database (on ASM), I hit the above error. No matter which way I tried to splice it, the error still occurred. SQL> CREATE PLUGGABLE DATABASE heinz_pdb ADMIN USER heinz_admin IDENTIFIED BY beans STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 100M) DEFAULT TABLESPACE heinz_data DATAFILE […]
Patch and Provision with EM12c: #1 Database Provisioning – Provision Me a Database!
PrefaceAmong the several (too many to list) useful features in Enterprise Manager 12c (specifically 12.1.0.3) is Database Provisioning. With the numerous benefits of a multi tenant architecture in newer releases Database 12c, I want to begin this series of blog posts with starting with a simple database provisioning exercise. Provisioning is, in my humble opinion, […]
Adding Entities (Component) to the Software Library in Oracle Enterprise Manager 12.1.0.3.0
As part of a blog series I’m currently working on for Provisioning and Patching in OEM12c, I needed to create a Software Library Component for the DB12c installation media. With 12.1.0.3, oracle introduced an dmcli approach (create_swlib_entity) to creating the relevant components. I’ll explore the GUI method for now, and write a related blog for […]
Fun with DB 12cR1 Upgrade
It’s 5 AM and its pouring outside – couldn’t be a worse start to a July 4th holiday in the summer! I woke up (for some reason) and can’t fall back asleep and figured I might try my luck at a database upgrade with 12.1.0.1 🙂 Many of us have already posted blogs about their […]