Monthly Archives: May 2010

Oracle Grid Control 11g

I was trying to install Oracle Grid Control 11g when I came across this gem:
partitioning option is not installed in the database, its strongly recommended to install it
“partitioning option is not installed its strongly recommended to install it”
I’m using an 11g r2 Standard Edition database for the repository as we only have Standard Edition licences at work but Standard Edition doesn’t include the Partitioning option. No where in the GC docs does it specify an Enterprise Edition repository database as a prerequisite!
There’s no way to ignore the ‘recommendation’ from the installer as clicking OK just returns you to the previous screen, this is the last thing I need on a Friday afternoon!

Seems like you can run partitioning, I found this in an upgrade doc (1090009.1) on My Oracle Support:

29) Database Partitioning Requirements
Ensure that the existing, certified Oracle Database has the Partitioning Option enabled. To verify this, connect to the database as SYSDBA and run the following query:
select value from v$option where parameter = ‘Partitioning’;
The result of this query should be VALUE=TRUE. No additional partitioning license is required for the database that houses the Management Repository.

Why is this is not mentioned in the install docs?

So I need to reinstall Oracle with the partitioning option. Ho Hum, back to the drawing board…