Installing Oracle Enterprise Manager Grid Control 11g on RHEL 5

In this article I will take you through step by step installation of Oracle Weblogic Server,Oracle Database 11g and Enterprise Manager Grid Control 11g.
Please make sure following rpm's are installed.
binutils
compat-libstdc++
elfutils-libelf
glibc-2.5-12
glibc-2.5-24
ksh
libaio
libgcc
libstdc++
make
elfutilslibelf-devel
elfutils-libelf-devel-static
kernel-headers
glibcheaders
glibc-devel
libstdc++-devel
libgomp
gcc
gcc-c++
libaiodevel
sysstat
unixODBC
unixODBC-devel
rng-utils
setarch
compatdb
pdksh
compat-libstdc++-33
compat-libstdc++-296
lsof
strace
wget
system-config-lvm

Installation Oracle WebLogic Server 11gR1 (10.3.2)

. Before installing,  create OS users and group.

groupadd dba

useradd -g dba -G oinstall oraoem

mkdir /u01/app/oraoem/Middleware

chown -R oraoem:dba /u01/app/oraoem/Middleware

./wls1032_linux32.bin

Install Database 11gR2

The following requirements are necessary:

/etc/sysctl.conf:

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 6815744

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

/etc/security/limits.conf:

ora11gr2 soft nproc 2047

ora11gr2 hard nproc 16384

ora11gr2 soft nofile 1024

ora11gr2 hard nofile 65536

oraoem soft nproc 2047

oraoem hard nproc 16384

oraoem soft nofile 1024

oraoem hard nofile 65536

/etc/profile:

if [ $USER = "ora11gr2" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -u 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

if [ $USER = "oraoem" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -u 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

useradd -g dba ora11gr2

mkdir -p /u01/app/ora11gr2

chown -R ora11gr2:dba /u01/app/ora11gr2

unzip linux_11gR2_database_1of2.zip

unzip linux_11gR2_database_2of2.zip

export ORACLE_BASE=/u01/app/ora11gr2

./runInstaller

At this point, we are installing Oracle Binaries only, without creating a database.

Installation of RDBMS patches:

I recommend to download and install these patches:

OPatch p6880880_112000_LINUX.zip

p6880880_112000_LINUX.zip

p9165206_112010_LINUX.zip

p9352237_112010_LINUX.zip

DBCA

Network Configuration (Listener, TNS)

 

Database Preparations

Ensure that the UNDO tablespace and the TEMP tablespace are autoextensible in

the existing, certified Oracle Database. Moreover, resize UNDO tablespace to

>200M.

Documentation mentions that for RDBMS 11.2.0.1 as Grid Control Repository, patch for

bug# 9002336 and 9067282 should be installed. I prefer to install PSU 11.2.0.1.1, which

contains bugfix 9067282. Bug 9002336 can be addressed by underscore parameter

"_optimizer_distinct_agg_transform = false"

SQL> alter system set "_optimizer_distinct_agg_transform"=false

scope=spfile;

SQL> alter system set log_buffer=10485760 scope=spfile;

SQL> alter system set processes = 500 scope=spfile;

SQL> alter system set session_cached_cursors=200 scope=spfile;

SQL> alter database datafile

'/u01/app/ora11gr2/oradata/EMREP/undotbs01.dbf' resize 256M;

Check whether fine grained access control is installed:

select value from v$option where parameter = 'Fine-grained

access control';

At this point, deinstall DB Control:

./emca -deconfig dbcontrol db -repos drop

Note:

My Oracle Support Node 561429.1 mentions that 11.2.0.1 can only be used as repository,

if DNS is used. For my demo installation, I prefer usage of /etc/hosts. I have tested and

found no issues without DNS.

Upgrade Weblogic Server To WDJ7


cd /u01/app/oraoem/Middleware
cd utils/bsu
./bsu.sh

Click Tab "Get Patches", Select WDJ7 and click "Download Selected".

Instllation Enterprise Manager Grid Control 11g

Installation is now complete and Grid Control can be accessed via browser:

https://testsystem:7799/em/

Click on "Setup" Tab, then Agents, then testsystem:3872. Then you see that EMREP database

is not configured yet.

Unlock and set the password:

SQL> user dbsnmp identified by xxx account unlock;

Configure the respective password for dbsnmp and finish.

Enterprise Manager Grid Control 11g Patches

Environment-Files:

/home/oraoem/OMS.env:

export ORACLE_HOME=/u01/app/oraoem/Middleware/oms11g

export PATH=$ORACLE_HOME/bin:$PATH

/home/oraoem/AGENT.env:

export ORACLE_HOME=/u01/app/oraoem/Middleware/agent11g

export PATH=$ORACLE_HOME/bin:$PATH

Stoppen von OMS und Agent

as root: /etc/init.d/gcstartup stop

OMS Patch: (as oraoem)

. /home/oraoem/OMS.env

unzip p9659466_111010_Generic.zip

cd 9659466

/u01/app/oraoem/Middleware/oms11g/OPatch/opatch apply

/u01/app/oraoem/Middleware/oms11g/bin/rcuJDBCEngine

sys/xxx@ora-vm2.intra:1521:EMREP JDBC_SCRIPT

post_install_script.sql $PWD $ORACLE_HOME

Agent Patch: (as oraoem)

. /home/oraoem/AGENT.env

unzip p9738008_111010_LINUX.zip

cd 9738008

/u01/app/oraoem/Middleware/agent11g/OPatch/opatch apply

unzip p9676134_111010_Generic.zip

cd 9676134

/u01/app/oraoem/Middleware/agent11g/OPatch/opatch apply