Add Partitioning Option to REPOS

My second attempt at configuring OEM failed as recounted in 11G OCM Patch OEM (3) as the partitioning option was not installed in the Oracle Home for the repos database instance. So, I have to add in the partitioning option.


Looking for Partitioning in the OEM Repository

The Oracle Support article, Oracle Enterprise Manager 10g Grid Control Certification Checker [ID 412431.1], does not mention partitioning only that the repository software is Enterprise Edition. The link called Database Platform Certification was broken (29 Dec 2009) as it referred to the old MetaLink site.

According to Oracle® Database Licensing Information 11g Release 1 (11.1): Options and Packs, the partitioning option is an extra cost to the Enterprise Edition license. My understanding would be that a DBA should not install the partititioning unless the license is purchased. I was trying to follow the best practices.

The Preinstallation Requirements for OEM does not mention partitioning either, but refers to the above Oracle Support Document (412431.1).

Looks like Oracle assumes everyone installs the partitioning option whether they have the license or not.

How to Install the Partitioning Option

I found the Oracle Support article called How to install Partitioning after Patchset Installation [ID 373383.1] which refers to an earlier version of Oracle RDBMS ( to I think the same plan could work here.

  1. Use OUI from the installation directory to add in the partitioning option.
  2. Use OUI from the patchset directory to patch the partitioning option.

Installation of Partitioning Option

Shutdown the Database Instance

I used SQL*Plus to shut down the repos database instance which is the only one of its kind running on gridctrl. (There is no need to use oraenv as all of the parameters are set in .bash_profile – see 11G OCM .bash_profile for GRIDCTRL.)

sqlplus / as sysdba
shutdown immediate

Add in the Partitioning Option

I changed directory to the installation directory and ran OUI.

cd /opt/oracle/software/database
  1. Select Installation Method
    • Advanced Installation

  2. Selection Installation Type
    • Custom
  3. Install Location (No Changes)
  4. Product-Specific Prerequisite Checks
    • Ignored the warnings
  5. Available Product Components (only selected the following options)
    • Oracle Enterprise Edition Options
    • Oracle Partitioning
  6. And select the defaults on the following screens.

Add in the Partitioning Option

I changed directory to the patchset directory and ran OUI.

cd /opt/oracle/software/p6890831/Disk1

All of the options selected were the defaults. And I ignored the MetaLink setup.

Startup the Database Instance

I used SQL*Plus to start up the repos database instance.

sqlplus / as sysdba

Validating Partitioning Option

The simplest way to validate the installation of the partitioning option is to get into SQL*Plus again after startup and look at the banner (see the highlighted line below):

[oracle@gridctrl ~]$ sqlplus / as sysdba

SQL*Plus: Release - Production on Tue Dec 29 08:32:04 2009

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release - Production
With the Partitioning option


2 thoughts on “Add Partitioning Option to REPOS

  1. The partitioning option is mentioned in “Checklist for EM 10g Grid Control 10.2.x to OMS and Repository Upgrades [ID 464674.1]”.

    The note also says that “Note: No additional partitioning license is required for the Database housing the Grid control repository, as it is basic Grid Control requirement.”

  2. I don’t know if it was available in but in 11gR2 there is a utility for this: chopt. I’ve posted a how to on my blog.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s