29 September 2013

Switchover Dataguard under Cloud Control 12c fails

During a switchover test in Enterprise Manager Cloud Control 12c, I got the error:

--------------------------------------------------------------------------------

Session Information Unavailable

Enterprise Manager is unable to proceed. The most likely cause of this is that database session information could not be retrieved or that EM was unable to process a user-invoked bookmark. Press OK to continue.

--------------------------------------------------------------------------------


The switchover did not take place, even though under DGMGRL it works fine, and the Verify Configuration in Cloud Control reveals no errors.

This appears to be a stupid bug in IE9. It runs fine under Chrome! See Doc ID 1512567.1 under Oracle Support.

This really makes me ....






23 September 2013

Basic steps upgrade to 12c

After reading the Upgrade Guide, you might like to create a short list of steps to take.
You are always responsible to check if the following steps are suitable for your situation. Always check the Upgrade Guide or consult Oracle Support.

This is how I manually upgraded a simple Dev database from 10.2 to 12.1 (no multi-tenant)
  • Run the <12c-home>/rdbms/admin/preupgrd.sql on the old database.
  • Check the $ORACLE_BASE/cfgtoollogs//preupgrade/preupgrade.log and fix whatever needs to be fixed
  • Re-run preupgrd.sql to check after fixing.
  • Shutdown old database.
  • Move all datafiles, controlfiles, redologfiles etc to new host
  • Move the init.ora to new host.
  • Make changes in init.ora following preupgrade.log
  • Create directories for e.g. audit_dump_dest
  • SQL> startup Upgrade
  • Go to OS prompt, cd $ORACLE_HOME/rdbms/admin
  • $ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sql  (takes about 30-40mins)
  • SQL> startup
  • SQL> @?/rdbms/admin/utlrp    (to repair invalid objects)
  • SQL> @?/rdbms/admin/utlu121s.sql   (to check status of components, should show VALID only)
  • Backup database

Oracle 12c Architecture

I found this great Interactive Quick Reference for 12c.

You can find all the background processes in the following overview: