Grid Control Database Install Guide

Background & Overview

The following documentation provides instructions for building an Oracle database for Oracle Grid Control conforming to Oracle OFA database standards and residing on a Oracle Linux (Version 5) operating system and using ASM.

Assumptions & Pre-Requisites

This document expects and assumes the following:

  • The instructions are carried out by a qualified DBA.
  • Access to the internet is available.
  • All necessary client software, e.g. Telnet and X-Server is available.
  • All references to SID should be replaced with correct database name as derived using a valid database naming standard.
  • There is only ONE database installed on the server.

Useful Information

  • None Currently.

Step-By-Step Guide

1. Download the recommended patches for the Oracle 11g Database when installing Grid Control 11g. At the time of producing this guide the following patches were recommended.

Enterprise Edition for Oracle Linux Operating System (x86) (64-bit) : 71,586 bytes; cksum - 2644868718 : 215,694 bytes; cksum - 1064576673

2. Install and create an Oracle database using the following guide How to Install Oracle 11g (11.2) on Linux with ASM

When prompted in the above guide to apply the oneoff patches, patch bundles or CPU patch bundles to the database, then follow the steps below to apply the recomended patches before continuing with the above guide. For this documentation, the following Database patches have been identified: 9002336 and 9067282

  • export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
  • unzip
  • unzip
  • cd 9002336
  • opatch apply
  • cd 9067282
  • opatch apply
  • Return back to the database guide How to Install Oracle 11g (11.2) on Linux with ASM and finish the install before continuing.

3. Ensure dbconsole is not installed

  • sqlplus '/ as sysdba'
  • SQL> select count(*) from all_users where username='SYSMAN';

4. If the previous step returns 1, then deinstall dbconsole using the following command

  • $<ORACLE_HOME>/bin/emca -deconfig dbcontrol db -repos drop -cluster -SYS_PWD <sys pasword> -SYSMAN_PWD <sysman password>

5. Ensure the following initialization parameters are set to the following values or greater.

  • alter system set log_buffer=10485760 scope=spfile;
  • alter system set session_cached_cursors=200 scope=spfile;

6. Restart the database

  • sqlplus '/ as sysdba'
  • SQL> shutdown immediate
  • SQL> startup

7. Ensure there system, undo, temp and sysaux have suitable amounts of space allocated.

  • sqlplus '/ as sysdba'
  • SQL> alter database datafile '+DATA/<full ASM filename for SYSTEM' resize 100m;
  • SQL> alter database datafile '+DATA/<full ASM filename for UNDO' resize 100m;
  • SQL> alter database datafile '+DATA/<full ASM filename for TEMP' resize 100m;
  • SQL> alter database datafile '+DATA/<full ASM filename for SYSAUX' resize 100m;

Other References

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License