Add Partitioning Option to REPOS


My second attempt at configuring OEM 10.2.0.5 failed as recounted in 11G OCM Patch OEM 10.2.0.5 (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.

Investigation

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 10.2.0.5 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 (10.1.0.2 to 10.1.0.5). I think the same plan could work here.

  1. Use OUI from the 11.1.0.6.0 installation directory to add in the partitioning option.
  2. Use OUI from the 11.1.0.7.0 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
exit

Add in the Partitioning Option

I changed directory to the 11.1.0.6.0 installation directory and ran OUI.

cd /opt/oracle/software/database
./runInstaller
  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 11.1.0.6.0
    • Oracle Partitioning 11.1.0.6.0
  6. And select the defaults on the following screens.

Add in the Partitioning Option

I changed directory to the 11.1.0.7.0 patchset directory and ran OUI.

cd /opt/oracle/software/p6890831/Disk1
./runInstaller

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
startup
exit

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 11.1.0.7.0 - 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 11.1.0.7.0 - Production
With the Partitioning option

SQL>
Advertisements

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 10.2.0.4/10.2.0.5 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 11.1.0.7 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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s