Oracle Class – Wissem's Oracle and NOSQL Tips – Tunisia's First Oracle, NOSQL Website

Introduction:

This document describes in detail the Steps for Installing Enterprise Manager Cloud Control 12 on Centos operating system 5.5 (64 bit) managed by an Oracle database 11.2.0.3 Patch Set 3.
We will use Oracle restart feature to automatic restart the database components in case of server reboot.

Prerequisites for Enterprise Manager Cloud Control 12 installation:

• Before we start installing EMC 12, we will install an Oracle database 11.2.0.3 for Enterprise Manager Cloud database repository. If you already have an Oracle database installed with a version earlier than 11.2.0.2 Patch Set 2, make sure to apply on it the latest Patch Set Updates (PSU) or Critical Patch Updates (CPU).

• Before we begin the installation, make sure the DNS server resolves the host name

• /etc/hosts file should contain the IP address and fully qualified host name. See my example below.

-bash-3.2$ cat /etc/hosts
127.0.0.1       localhost.localdomain localhost
# ::1           localhost6.localdomain6 localhost6
XXX.XXX.X.XXX   ut06dbmon01.domain.com     ut06dbmon01
-bash-3.2$

• Make sure you environment meets the hardware Requirements:
http://docs.oracle.com/cd/E24628_01/install.121/e22624/preinstall_req_hw.htm#BACDDAAC

• Install the following 64-Bit Packages for 64-Bit Platform:

make-3.81
binutils-2.17.50.0.6
gcc -4.1.1
libaio-0.3.106
glibc-common-2.3.4
libstdc++ -4.1.1
setarch-1.6
sysstat-5.0.5
rng-utils-2.0

In addition, install the 32-bit version as well as the 64-bit version of glibc-devel-2.5-49.
This is described; http://docs.oracle.com/cd/E24628_01/install.121/e22624/preinstall_req_packages.htm#CHDEHHCA

Oracle Software installation:
As mentioned before, we are going to install Oracle database version 11.2.0.3.
First, download the software from; Patch 10404530 from My Oracle Support website; https://support.oracle.com/
Check the following meets the requirements:

● Physical memory
● Swap space
● Temporary space.
● A processor type (CPU) that is certified with the version of the Oracle software being installed.

Please refer to the appropriate installation guide: http://www.oracle.com/pls/db112/portal.portal_db?selected=11

● Create OS groups using the command below. Enter these commands as the ‘root’ user:

/usr/sbin/groupadd -g 501 oinstall
/usr/sbin/groupadd -g 502 dba
/usr/sbin/groupadd -g 504 asmadmin
/usr/sbin/groupadd -g 506 asmdba
/usr/sbin/groupadd -g 507 asmoper

● Create the users that will own the Oracle software using the commands: we will use grid user for Oracle grid standalone infrastructure installation.

#/usr/sbin/useradd -u 501 -g oinstall -G dba,asmadmin,asmdba,asmoper grid
#/usr/sbin/useradd -u 502 -g oinstall -G dba,asmdba oracle

● Set the password for the oracle account using the following command. Replace password with your own password.

passwd oracle
Changing password for user oracle.
New UNIX password: password
retype new UNIX password: password
passwd: all authentication tokens updated successfully.

passwd grid
Changing password for user grid.
New UNIX password: password
retype new UNIX password: password
passwd: all authentication tokens updated successfully.

● Set user profiles:

[root@ut06dbmon01 script]#  cat /home.local/oracle/.bash_profile
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_UNQNAME=mondb01; export ORACLE_UNQNAME
ORACLE_BASE=/opt/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=mondb01; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH:$ORACLE_HOME/OPatch; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
EDITOR=vi; export EDITOR
NLS_DATE_FORMAT='mm/dd/yyyy hh24:mi:ss'; export NLS_DATE_FORMAT
NLS_LANG=AMERICAN_AMERICA.AL32UTF8; export NLS_LANG
OMS_HOME=/opt/app/oracle/Middleware/oms; export OMS_HOME
AGENT_HOME=/opt/app/oracle/Middleware/agent/agent_inst; export AGENT_HOME
[root@ut06dbmon01 script]#

[root@ut06dbmon01 script]#  cat /home.local/grid/.bash_profile
# Grid User Settingss
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
GRID_HOME=/opt/11.2.0/grid; export GRID_HOME
export ORACLE_HOME=$GRID_HOME
PATH=/usr/sbin:$PATH; export PATH
PATH=$GRID_HOME/bin:$PATH:$GRID_HOME/OPatch; export PATH
OMS_HOME=/opt/app/oracle/Middleware/oms; export OMS_HOME
AGENT_HOME=/opt/app/oracle/Middleware/agent/agent_inst; export AGENT_HOME
EDITOR=vi; export EDITOR
[root@ut06dbmon01 script]#

● Configure kernel parameters:

As the root user add the following kernel parameter settings to /etc/sysctl.conf. If any of the parameters are already in the /etc/sysctl.conf file, the higher of the 2 values should be used.

kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6553600
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
fs.file-max = 6815744
fs.aio-max-nr = 1048576

Run the following as the root user to allow the new kernel parameters to be put in place:

/sbin/sysctl -p

● Set shell limits for the Oracle user:

To improve the performance of the software on Linux systems, you must increase the shell limits for the oracle user. Add the following lines to the /etc/security/limits.conf file:

grid            soft    nproc           2047
grid            hard    nproc           16384
grid            soft    nofile          4096
grid            hard    nofile          65536
oracle          soft    nproc           2047
oracle          hard    nproc           16384
oracle          soft    nofile          4096
oracle          hard    nofile          65536
oracle          soft    memlock         30000000
oracle          hard    memlock         30000000

● Add or edit the following line in the /etc/pam.d/login file, if it does not already exist:

session required pam_limits.so

● Make the following changes to the default shell startup file, add the following lines to the /etc/profile file:

if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
   if [ $SHELL = "/bin/ksh" ]; then
        ulimit -p 16384
        ulimit -n 65536
   else
        ulimit -u 16384 -n 65536
   fi
   umask 022
fi

● Create the Oracle Inventory and Oracle Grid Installation home directories:

To create the Oracle Inventory directory, enter the following commands as the root user:

mkdir -p /opt/app/oraInventory
chown -R oracle:oinstall /opt/app/oraInventory/
chmod -R 775 /opt/app/oraInventory/

● To create the Grid Infrastructure home directory, enter the following commands as the root user:

mkdir -p /opt/11.2.0/grid
chown -R grid:oinstall /opt/11.2.0/grid
chmod -R 775 /opt/11.2.0/grid/

● Create the Oracle base directory:

To create the Oracle Base directory, enter the following commands as the root user:

mkdir -p /opt/app/oracle
mkdir /opt/app/oracle/cfgtoollogs
chown -R oracle:oinstall /opt/app/oracle
chmod -R 775 /opt/app/oracle

● Creating the Oracle RDBMS home directory:

To create the Oracle RDBMS Home directory, enter the following commands as the root user:

mkdir -p /opt/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /opt/app/oracle/product/11.2.0/db_1
chmod -R 775 /opt/app/oracle/product/11.2.0/db_1

● Install the following rpm packages using yum. Log goes to the /var/log/yum.log file.

binutils-2.15.92.0.2
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.97
elfutils-libelf-devel-0.97
expat-1.95.7
gcc-3.4.6
gcc-c++-3.4.6
glibc-2.3.4-2.41
glibc-2.3.4-2.41 (32 bit)
glibc-common-2.3.4
glibc-devel-2.3.4
glibc-headers-2.3.4
libaio-0.3.105
libaio-0.3.105 (32 bit)
libaio-devel-0.3.105
libaio-devel-0.3.105 (32 bit)
libgcc-3.4.6
libgcc-3.4.6 (32-bit)
libstdc++-3.4.6
libstdc++-3.4.6 (32 bit)
libstdc++-devel 3.4.6
make-3.80
pdksh-5.2.14
sysstat-5.0.5
unixODBC-2.2.11
unixODBC-2.2.11 (32 bit)
unixODBC-devel-2.2.11
unixODBC-devel-2.2.11 (32 bit)

To determine whether the required packages are installed, enter commands similar to the following:

rpm -qa | grep beginning_of_the_package_name
rpm -qa | grep elfutils

● As a root user, disable secure linux by editing the “/etc/selinux/config” file, making sure the SELINUX flag is set as follows.

SELINUX=disabled

● Unzip the oracle database zip files (1 and 2):

Installation Type:

Oracle Database (includes Oracle Database and Oracle RAC):
p10404530_112030_Linux-x86-64_1of7.zip p10404530_112030_Linux-x86-64_2of7.zip
Oracle Grid Infrastructure (includes Oracle ASM, Oracle Clusterware, and Oracle Restart):
p10404530_112030_Linux-x86-64_3of7.zip
Oracle Database Client:
p10404530_112030_Linux-x86-64_4of7.zip
Oracle Gateways:
p10404530_112030_Linux-x86-64_5of7.zip
Oracle Examples:
p10404530_112030_Linux-x86-64_6of7.zip
Deinstall:
p10404530_112030_Linux-x86-64_7of7.zip

● Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.

./runInstaller

1. Configure Security Update Screen:

2. Download Software Updates Screen:

3. Select Install Option Screen:

4. Grid Installation Option Screen:

5. Select Product Languages Screen:

6. Select Database Edition Screen:

7. Specify Installation Location Screen:

8. Create Inventory Screen:

9. Privileged Operating System Group Screen:

10. Perform Prerequisites Checks Screen:

11. Summary Screen:

12. Install Product Screen:

13. Execute Configuration Scripts Screen:

14. Root.sh Screen:

15. Finish

Listener Configuration:
● Start the Network Configuration Assistant (NETCA) by issuing the following command:

./netca

1. Listener Configuration Screen

Oracle Database installation:
● Start the Database Configuration Assistant (DBCA) by issuing the following command:

./dbca

1. Create Database Screen:

2. Database Templates Screen:

3. Database Identification Screen:

4. Configure Enterprise Manager Control Screen: You can install Enterprise Manager Control or no. In this post I will install it.

5. Database Credentials Screen:

6. Database File Locations Screen:

7. Recovery Configuration Screen:

8. Initialization Parameter Screen: Here we choose an SGA of 14GB and a PGA of 2GB.

9. Database Storage Screen:

10. Creation Options Screen:

11. Summary Screen:

12. Database Creation Progress Screen:

13. Database Creation Complete

Oracle Restart Installation:

● Unzip the oracle installation zip file 3:

Unzip p10404530_112030_Linux-x86-64_3of7.zip

● As grid user, install the grid standalone software:

-bash-3.2$ ./runInstaller -ignorePrereq -silent -responseFile /opt/11gr2Src/grid/grid/response/grid_install.rsp -invPtrLoc /etc/oraInst.loc
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 5793 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 8189 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-12-07_11-48-15AM. Please wait ...-bash-3.2$ You can find the log of this install session at:
 /opt/app/oraInventory/logs/installActions2011-12-07_11-48-15AM.log
The installation of Oracle Grid Infrastructure was successful.
Please check '/opt/app/oraInventory/logs/silentInstall2011-12-07_11-48-15AM.log' for more details.

As a root user, execute the following script(s):
        1. /opt/11.2.0/grid/root.sh

Successfully Setup Software.

-bash-3.2$

As root user; run the script:

/opt/11.2.0/grid/root.sh

● Install Oracle Restart:

[root@ut06dbmon01 ~]# id
uid=0(root) gid=0(root) groups=0(root),1(bin),2(daemon),3(sys),4(adm),6(disk),10(wheel)
[root@ut06dbmon01 ~]# /opt/11.2.0/grid/perl/bin/perl -I /opt/11.2.0/grid/perl/lib/ -I /opt/11.2.0/grid/crs/install/ /opt/11.2.0/grid/crs/install/roothas.pl
Using configuration parameter file: /opt/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node ut06dbmon01 successfully pinned.
Adding Clusterware entries to inittab

ut06dbmon01     2011/12/07 12:52:48     /opt/11.2.0/grid/cdata/ut06dbmon01/backup_20111207_125248.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server

● Add Database resources to crs:

[root@ut06dbmon01 ~]# su - oracle
-bash-3.2$ echo $ORACLE_SID
mondb01
-bash-3.2$ srvctl add database -d mondb01 -o /opt/app/oracle/product/11.2.0/db_1
-bash-3.2$ srvctl start database -d mondb01
-bash-3.2$ srvctl config database -d mondb01
Database unique name: mondb01
Database name:
Oracle home: /opt/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile:
Domain: xxxxx.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Database instance: mondb01
Disk Groups:
Services:
-bash-3.2$ srvctl add listener -l LISTENER
PRCN-2061 : Failed to add listener ora.LISTENER.lsnr
PRCN-2065 : Port(s) 1521 are not available on the nodes given
PRCN-2067 : Port 1521 is not available across node(s) "ut06dbmon01.xxx.com"
-bash-3.2$  lsnrctl stop LISTENER
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 07-DEC-2011 11:56:30

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ut06dbmon01.xxx.com)(PORT=1521)))
The command completed successfully
-bash-3.2$ su - grid
Password:
-bash-3.2$ srvctl add listener -l LISTENER
-bash-3.2$  srvctl start listener -l LISTENER
-bash-3.2$ srvctl config listener -l LISTENER
Name: LISTENER
Home: /opt/11.2.0/grid
End points: TCP:1521
-bash-3.2$ su - grid
-bash-3.2$ crsctl status res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       ut06dbmon01
ora.ons
               OFFLINE OFFLINE      ut06dbmon01
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        OFFLINE OFFLINE
ora.diskmon
      1        OFFLINE OFFLINE
ora.evmd
      1        ONLINE  ONLINE       ut06dbmon01
ora.mondb01.db
      1        ONLINE  ONLINE       ut06dbmon01              Open
-bash-3.2$ exit
logout

● Verify The Inventory xml file:

-bash-3.2$ cat /opt/app/oraInventory/ContentsXML/inventory.xml





   11.2.0.3.0
   2.1.0.6.0








-bash-3.2$

Enterprise Manager Could Control 12 Installation:

● Create the middleware home directory; execute the following commands as the root user:

[root@ut06dbmon01 /]# mkdir -p /opt/app/oracle/Middleware
[root@ut06dbmon01 /]# chown -R oracle:oinstall /opt/app/oracle/Middleware
[root@ut06dbmon01 /]# chmod -R 775 /opt/app/oracle/Middleware
[root@ut06dbmon01 /]#

● Download the Enterprise Manager Cloud 12:

http://www.oracle.com/technetwork/oem/grid-control/downloads/index.html

[root@ut06dbmon01 emc]# chown -R oracle:oinstall /opt/11gr2Src/emc

● As Oracle Software owner user: deconfigure the already installed Oracle Enterprise Manager Control:

-bash-3.2$ id
uid=502(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),506(asmdba)
-bash-3.2$  emca -deconfig dbcontrol db -repos drop -SYS_PWD wissem1234 -SYSMAN_PWD wissem1234

STARTED EMCA at Dec 8, 2011 8:13:25 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: mondb01
Listener port number: 1521

----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Dec 8, 2011 8:13:59 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /opt/app/oracle/cfgtoollogs/emca/mondb01/emca_2011_12_08_08_13_24.log.
Dec 8, 2011 8:13:59 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Dec 8, 2011 8:14:23 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Dec 8, 2011 8:15:50 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 8, 2011 8:15:52 AM
-bash-3.2$

● Adjust the database parameters; like the following, depending on your environment:

-bash-3.2$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 8 07:19:12 2011
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> ALTER SYSTEM SET processes=1000 SCOPE=SPFILE;
System altered.
SQL> ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;
System altered.
SQL> ALTER SYSTEM SET shared_pool_size=600M SCOPE=SPFILE;
System altered.
SQL> ALTER SYSTEM SET job_queue_processes=20 SCOPE=SPFILE;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 1.4965E+10 bytes
Fixed Size                  2242912 bytes
Variable Size            2046822048 bytes
Database Buffers         1.2885E+10 bytes
Redo Buffers               31297536 bytes
Database mounted.
Database opened.
SQL>
Redo log  500MB of size each member;
SQL> select GROUP#, MEMBERS, SUM(BYTES/1024/1024) AS BYTES
   from v$LOG
  GROUP BY GROUP#, MEMBERS
  ORDER BY GROUP#;
  2    3    4
    GROUP#    MEMBERS      BYTES
---------- ---------- ----------
         4          2        500
         5          2        500
         6          2        500

SQL>

Undo Tablespace Size 500M:
SQL> ALTER DATABASE DATAFILE '/opt/app/oracle/oradata/MONDB01/datafile/o1_mf_undotbs1_7fzcg0rw_.dbf' RESIZE 500M;
Database altered.
SQL>

● Enterprise Manager Installation:

As Oracle Software owner; unzip the installation files and run the installer;

-bash-3.2$ unzip em12_linux64_disk1of2.zip
-bash-3.2$ unzip em12_linux64_disk2of2.zip
-bash-3.2$ ./runInstaller

1. My Oracle Support Details Screen:

2. Software Updates Screen:

3. Prerequisites Checks:

4. Install Types; we choose Simple installation: In this screen we can install the software only and then configure the node manager later. This option is new with Enterprise Manager Cloud 12

5. Configuration Details Screen: Provide the SYSMAN password and the database connection details

6. The installer with show you a screen to disable gathering database statistics; Click on ok

7. The installer with show you a screen with a list of failing prerequisites you can click on ok to ignore them for the moment and implement the recommendations later after installation

8. Review Screen

9. Installation progress Details Screen 1

10. Installation progress Details Screen 2

11. Execute Configuration Scripts Screen

12. Finish Screen will show you the Enterprise Manager Cloud Control URL

13. Enterprise Manager 12c Welcome page

14. License Agreement Screen; click on Accept after read it or Decline

15. Enterprise Manager Summary Screen:

16. Enterprise Manager Preview Screen:

17. Enterprise Manager ALL targets Screen:

18. Enterprise Manager Target Host Screen:

References:

http://docs.oracle.com/cd/E24628_01/install.121/e22624/toc.htm

Scridb filter