Friday, September 27, 2013

Patch and Provision with EM12c: #3 Database Provisioning - Using Profiles

With my previous post on creating Profiles with OEM12c completed, I wanted to use them for actual deployments. If you recall, Mr. Green wants to make sure that his deployments are consistent across each environment. What I'd to achieve today Provision RDBMS software and Create a Database using a procreated profile Let's Begin 1. Find your custom...
continue reading "Patch and Provision with EM12c: #3 Database Provisioning - Using Profiles"

Thursday, September 26, 2013

How long did your Database Upgrade actually take?

This might be old news, but it became new news for me after I discovered it last week. As far as I know, there's no way to determine the length of a database upgrade. There are, however, ways to influence the length by gathering dictionary stats, truncate AUD$ and FGA_LOG$. At the end of the upgrade...
continue reading "How long did your Database Upgrade actually take?"

Saturday, September 21, 2013

ORA-00119 During a Database Upgrade

I consider myself a reasonably detail oriented person – reasonably… Well, every now and then, more often than not, I tend to overlook documentation. Either that, or my dyslexia kicks in. Before I go into my story, let me explain the configuration, which led me to the setup on which I had a problem.     11.1.0.7.0 CRS & ASM upgraded...
continue reading "ORA-00119 During a Database Upgrade"

Wednesday, September 18, 2013

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...
continue reading "DB12c: ORA-19504: failed to create file "+DATA" While Creating Pluggable Database Manually"

Tuesday, September 17, 2013

Oracle Open World 2013 Schedule

So, two weeks before OOW, when I had resigned myself for nothing being able to go I found out that I'm actually going! Now, I'd been following the twitter feed on the happenings out here so, it didn't take me long to get my schedule together. Saturday: I'm taking the last flight out to SFO, and fortunately for the time change arrive late in the evening...
continue reading "Oracle Open World 2013 Schedule"

Saturday, September 14, 2013

Patch and Provision with EM12c: #2 Database Provisioning - Profiles

Now that I've recovered from a straight 10 hour session I did to write the blog in the previous topic in this series (Provision me a Database!), I wanted to touch on a few of the "softer" pieces in the "Database Provisioning" functionality. Provisioning Profiles To put the concept into perspective, lets start with a story. A certain Mr. Green (DBA...
continue reading "Patch and Provision with EM12c: #2 Database Provisioning - Profiles"