Monday, May 14, 2012

Oracle Cloud Control 12c on Amazon Web Services

Oracle Enterprise Manager 12c can run on Amazon's cloud services if you know a few tricks. You can download a copy of the how-to guide at OEMonEC2partTwo.pdf. It is in draft form. Over the next few weeks a bit more will be outlined before I move onto part three of this series. You can obtain part one here.

The highlights of  Part Two are:

  • Brief over of  features and architecture OEM CC 12c.
  • Extensive links to Part One of the series and other sources of necessary information to run an Oracle database repository (OMR) in an AWS EC2 environment.
  • Set up of the Amazon Machine Image to satisfy CC prerequisites.
  • Extensive discussion of  Name Resolution to enable CC to run in a DHCP environment.
  • Scripts for dynamic Hosts file management.
  • Firewall configuration to enable the CC architectural pieces to communicate in an EC2 context.
  • Debugging tips if the installation goes not as planned.
  • How to configure CC security credentials.

 If anyone how has already done this, or, will use this guide to do so I'd like to hear from you.

Saturday, May 5, 2012

DB Startup Fails on WORKAREA_SIZE_POLICY

A short posting just as an FYI in case you hit this Oracle startup error. I couldn't find any web post or MOS post covering this error so maybe this will help some one else hitting this nuance error.

When using the init parameters MEMORY_MAX_TARGET and/or MEMORY_TARGET you may get and error on startup the these are incompatible with WORKAREA_SIZE_POLICY. If this occurs simply unset that policy parameter. On startup it will then be set to the default value of AUTO which is the most common value. Setting it to MANUAL does not work.

That was my experience.
Just an FYI.