11G OCM Exam Completed

I completed the 11G OCM Update Exam yesterday.

11G OCM PENRITH1 Turned Off

I had to turn off the PENRITH cluster completely.

11G OCM Install and configure EM Agent

I have achieved another 11G OCM Objective: 11G OCM Install and configure EM Agent.

11G OCM Create and Manage a tablespace that uses NFS mounted file system file

I have now rated myself a four (4) out of five (5) for the OCM objective of 11G OCM Create and Manage a tablespace that uses NFS mounted file system file after I successfully got the DirectNFS driver working.

11G OCM Database Creation Failed Using FreeNAS

Looks like I cannnot create a database using ASM files on a FreeNAS server.

11G OCM Penrith2 Reboot Loop

I had to disable the PENRITH2 node because it goes into a reboot loop for some reason.

11G OCM Penrith Clusterware Installed

Finally got Oracle Clusterware 11.1.0.6 up and running on the PENRITH cluster. The diary of the build is on my Wiki here.

11G OCM Rebuild PENRITH1

I have dropped the PENRITH1 image created in 11G OCM Planning (2) and plan to rebuild from scratch.

Capturing 10053 trace files continued

The Oracle Optimizer blog has published a note on an undocumented procedure in the DBMS_SQLDIAG package called DUMP_TRACE in Capturing 10053 trace files continued:

This procedure, just like the event requires only the SQL_ID of the statement you wish to generate an Optimizer trace for but it doesn’t require you to re-execute the statement. The procedure will automatically trigger a hard parse of the statement to generate the trace.

11G OCM Self-Assessment

I have done a self assessmemt on the 11G OCM Upgrade Exam objectives here.

I have a lot of work to do.

I have booked myself in for the exam on 20 January 2012.