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.
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.
- Use OUI from the 188.8.131.52.0 installation directory to add in the partitioning option.
- Use OUI from the 184.108.40.206.0 patchset directory to patch the partitioning option.
Installation of Partitioning Option
Shutdown the Database Instance
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 220.127.116.11.0 installation directory and ran OUI.
cd /opt/oracle/software/database ./runInstaller
- Select Installation Method
- Ignored the warnings
- Oracle Enterprise Edition Options 18.104.22.168.0
- Oracle Partitioning 22.214.171.124.0
Add in the Partitioning Option
I changed directory to the 126.96.36.199.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
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 188.8.131.52.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 184.108.40.206.0 - Production With the Partitioning option SQL>