Tuesday, December 22, 2015

Oracle Cloud Control 13c R1 Basic Installation on Oracle Linux 6.5

- Source Links:

- Download the following software:
Oracle Database (x86_64) 12.1.0.2 Enterprise Edition
Enterprise Manager Cloud Control 13c Release 1 (13.1.0.0) (x86_64)
13.1.0.0 DB Template for EM 13.1.0.0 on Linux x86-64
Oracle Linux 6.5 (x86_64)

OS Installation
Install Oracle Linux (OL) in the same way you would for a regular Oracle Database installation. You can see examples of this type of installation below. Remember to check database installation article (listed below) for the specific package group selection.
During this installation I used a virtual machine with 10G RAM and 100G disk space. The swap size was set at 8G, the firewall was disabled and SELinux was set to permissive.

- Database Installation (Software-Only)
For this installation you will need 12.1.0.2 for the repository database, so use the installation instructions from one of the following articles.

- OMS Server Virtual Machine details:
hostname: em131.example.com
IP Address: 1.0.3.71
CPU: 2x2 Cores
RAM: 11GB (minimal 10GB or just ignore warning during installation)
HDD: 120G -> /boot 500MB
-> /root 110GB
-> swap 10GB

- Install VMware guest tools
 # tar -zxvf /media/iso/VMwareTools-10.0.5-3228253.tar.gz -C /tmp
 # /tmp/vmware-tools-distrib/vmware-install.pl -d
 # reboot

- Mount shared folder in Linux guests with oracle software directory in host
 # mkdir /mnt/hgfs
 # vim /etc/fstab
 .host :/ /mnt/hgfs vmhgfs defaults 0 0

- Stop postfix service that hang system at boot time
# chkconfig postfix off
# /etc/init.d/postfix stop

- Disable and shutdown network manager to avoid reset network settings
# service NetworkManager stop
# chkconfig NetworkManager off

- Edit "/etc/hosts" file must contain a fully qualified name for the server
127.0.0.1   localhost.localdomain   localhost
1.0.3.71    em131.example.com       em131

- Set secure Linux to permissive by editing the "/etc/selinux/config" file
# setenforce Permissive
# vim /etc/selinux/config
SELINUX=permissive

- If you have the Linux firewall enabled, you will need to disable or configure it
# service iptables stop
# chkconfig iptables off

- Edit "/etc/sysconfig/network" file
vim /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=em131.example.com
NOZEROCONF=yes

- Set network interface file -ifcfg-eth0
# vim /etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE=eth0
BOOTPROTO=none
ONBOOT=yes
IPADDR=1.0.3.71
NETMASK=255.255.255.0
GATEWAY=1.0.3.2
USERCTL=no

- Edit /etc/resolv.conf file
# vim /etc/resolv.conf
search example.com
nameserver 1.0.3.2

- Add or amend the following lines in the "/etc/sysctl.conf" file
# vim /etc/sysctl.conf
#### Oracle Cloud Control 13cr1 settings
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 11000 65500
kernel.panic_on_oops = 1

- Run the following command to apply the current kernel parameters.
/sbin/sysctl -p
/etc/init.d/network restart

- Add the following lines to the "/etc/security/limits.conf" file
# vim /etc/security/limits.conf
#### Oracle Cloud Control 13cr1 settings
oracle   soft           nofile          4096
oracle   hard           nofile          65536
oracle   soft           nproc           16384
oracle   hard           nproc           16384
oracle   soft           stack           10240
oracle   hard           stack           32768
oracle   soft           memlock         4095746
oracle   hard           memlock         4095746

- Create the new groups and users
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
groupadd -g 54327 asmdba
groupadd -g 54328 asmoper
groupadd -g 54329 asmadmin
useradd -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba,asmdba,asmoper,asmadmin,wheel oracle
passwd oracle

- Create the directories in which the Oracle software will be installed
rm -rf /u01
mkdir -p /u01/app/12102/grid
mkdir -p /u01/app/oracle/grid
mkdir -p /u01/app/oracle/product/12102/db_1
mkdir -p /u01/app/oracle/oms13cr1
mkdir -p /u01/app/oracle/agent13c
chown -R oracle:oinstall /u01
chmod -R 775 /u01/

- Amend the "/etc/security/limits.d/90-nproc.conf" file
# vim /etc/security/limits.d/90-nproc.conf
#### Change this
*          soft    nproc    1024

#### To this
* - nproc 16384

- Add the following lines at the end of the "/home/oracle/.bash_profile" file
# vim /home/oracle/.bash_profile
#### Oracle Cloud Control 13cr1 settings
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
alias adrci='rlwrap adrci'
alias asmcmd='rlwrap asmcmd'

export TMP=/tmp;
export TMPDIR=$TMP;

export ORACLE_HOSTNAME=`hostname`
export ORACLE_UNQNAME=emrep
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12102/db_1
export GRID_HOME=/u01/app/oracle/grid
#export GRID_HOME=/u01/app/12102/grid
export OMS_HOME=/u01/app/oracle/oms13cr1
export AGENT_HOME=/u01/app/oracle/agent13c
export ORACLE_SID=emrep
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export PATH=$OMS_HOME/bin:$PATH
export PATH=$AGENT_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

- Install required packages
# mv /etc/yum.repos.d/public-yum-ol6.repo /etc/yum.repos.d/public-yum-ol6.repo.bk
# mount
# vim /etc/fstab
/dev/sr0             /media/iso           iso9660 defaults         0 0

# mkdir /media/iso
# mount -a
# rpm --import /media/iso/RPM-GPG-KEY
# rpm --import /media/iso/RPM-GPG-KEY-oracle
# cd /etc/yum.repos.d/
# vim dvd.repo

[Server]  
name=Server
baseurl=file:///media/iso/Server  
gpgkey=file:///media/iso/RPM-GPG-KEY  
gpgcheck=1  
enabled=1  

[HighAvailability]  
name=HighAvailability
baseurl=file:///media/iso/HighAvailability  
gpgkey=file:///media/iso/RPM-GPG-KEY  
gpgcheck=1  
enabled=1  

[LoadBalancer]  
name=LoadBalancer
baseurl=file:///media/iso/LoadBalancer
gpgkey=file:///media/iso/RPM-GPG-KEY  
gpgcheck=1  
enabled=1  

[ResilientStorage]  
name=ResilientStorage
baseurl=file:///media/iso/ResilientStorage
gpgkey=file:///media/iso/RPM-GPG-KEY  
gpgcheck=1  
enabled=1  

[ScalableFileSystem]  
name=ScalableFileSystem
baseurl=file:///media/iso/ScalableFileSystem
gpgkey=file:///media/iso/RPM-GPG-KEY  
gpgcheck=1  
enabled=1  

[UEK3]  
name=UEK3
baseurl=file:///media/iso/UEK3
gpgkey=file:///media/iso/RPM-GPG-KEY  
gpgcheck=1  
enabled=1   
 
# yum clean all  
# yum makecache  
# yum repolist  

- Install the following packages if they are not already present.
# yum install -y binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33.i686 gcc gcc-c++ glibc.i686 glibc-devel.i686 glibc-devel glibc-common glibc-headers glibc-utils glibc ksh libgcc libgcc.i686 libstdc++ libstdc++.i686 libstdc++-devel libstdc++-devel.i686 libaio libaio.i686 libaio-devel libaio-devel.i686 libXext libXext.i686 libXtst libXtst.i686 libX11 libX11.i686 libXau libXau.i686 libxcb libxcb.i686 libXi libXi.i686 make sysstat unixODBC unixODBC-devel 

- Install Extra packages
Flash Player
JDK7U80
rlwarp
# rpm -Uvh flash-plugin-11.2.202.540-release.x86_64.rpm jdk-7u80-linux-x64.rpm rlwrap-0.42-1.el6.x86_64.rpm

- Extract Oracle Database files to virtual Machine using VMware shared folder
$ su - oracle
$ cd /mnt/hgfs/shared/db/db_121012_lnx64/ (shared folder in physical machine)
$ unzip -d /tmp linuxamd64_12102_database_1of2.zip && unzip -d /tmp linuxamd64_12102_database_2of2.zip

- Install Oracle Database software only
$ export ORACLE_SID=emrep
$ export ORACLE_HOME=/u01/app/oracle/product/12102/db_1
$ /tmp/database/runInstaller &

- run root scripts
# /u01/app/oraInventory/orainstRoot.sh
# /u01/app/oracle/product/12102/db_1/root.sh

- unzip repository template under ORACLE_HOME
$ cd /mnt/hgfs/shared/em/em13100_linux64/
$ unzip -d $ORACLE_HOME/assistants/dbca/templates/ 12.1.0.2.0_Database_Template_for_EM13_1_0_0_0_Linux_x64.zip

- use Oracle OUI to install "emrep" repository database using templates
$ dbca &

- start Oracle database Cloud Control installer
$ cd /mnt/hgfs/shared/em/em13100_linux64/
$ chmod +x em13100_linux64.bin
$ ./em13100_linux64.bin

 install details - 

 OMS_HOME=/u01/app/oracle/oms13cr1
 AGENT_HOME=/u01/app/oracle/agent13c
 hostname=em131.example.com


- Open a terminal and switch to root, and run the root script.
/u01/app/oracle/oms13cr1/allroot.sh

- Edit the "/etc/oratab" file setting.
$ vim /etc/oratab
emrep:/u01/app/oracle/product/12102/db_1:Y

- Cloud Control summary:
Use the following URL to access:

 1. Enterprise Manager Cloud Control URL: https://em131.example.com:7802/em
 username: sysman

 2. Admin Server URL: https://em131.example.com:7102/console
 username: weblogic

 3. BI Publisher URL: https://em131.example.com:9803/xmlpserver
 username: sysman


- Configure Oracle database to use archivelog mode, force logging and controlfiles trace and get a clean backup

SQL> shutdown immediate  
$ sqlplus / as sysdba
SQL> startup mount;  
SQL> alter database archivelog;  
SQL> alter database force logging;  
SQL> alter database backup controlfile to trace;  
SQL> alter database open';  
SQL> exit
RMAN> report schema; # check schema  
RMAN> configure controlfile autobackup on; # set controlfiles to be backup with database  
RMAN> backup database plus archivelog; # backuped database with archivelogs   

- Shutdown Oracle Cloud Control 13c with it's repo database
$ vim shutdown.sh
#!/bin/bash
# shutdown Oracle database Server && Cloud Control && Cloud Agent
export ORACLE_HOME=/u01/app/oracle/product/12102/db_1
export OMS_HOME=/u01/app/oracle/oms13cr1
export AGENT_HOME=/u01/app/oracle/agent13c/agent_13.1.0.0.0

# Stop everything
$OMS_HOME/bin/emctl stop oms -all

$AGENT_HOME/bin/emctl stop agent

$ORACLE_HOME/bin/dbshut $ORACLE_HOME

echo "*************** BYE BYE ***************"

$ chmod +x shutdown.sh


- Startup Oracle Cloud Control with it's repo database
$ vim startup.sh
#!/bin/bash
# Startup Oracle database Server && Cloud Control && Cloud Agent
export ORACLE_HOME=/u01/app/oracle/product/12102/db_1
export OMS_HOME=/u01/app/oracle/oms13cr1
export AGENT_HOME=/u01/app/oracle/agent13c/agent_13.1.0.0.0

# Start everything
$ORACLE_HOME/bin/dbstart $ORACLE_HOME

$OMS_HOME/bin/emctl start oms

$AGENT_HOME/bin/emctl start agent

echo "**************** WELLCOME *****************"

$ chmod +x startup.sh

No comments:

Post a Comment