askMLabs

In this article, we will see 12c oem grid control installation. There are two types of installations for oem grid control, simple installation and advanced installation. We are going to see advanced installation in this article.

1. 1.Software
2. 2.OS installation
3. 3.Database Installation
4. 4.Oem 12c Prerequisites
1. a.Hardware Requirements
2. b.Operating System Requirements
3. c.Package Requirements
4. d.Kernel Parameter Requirements
5. e.Library Requirements
6. f.Operating System Groups and Users Requirements
7. g.Unique Host Name and Static IP Address Requirements
8. h.Temporary Directory Space Requirements
9. i.Central Inventory Requirements
10. j.UMASK Value Requirements
11. k.File Descriptor Requirements
12. l.Existing Database Version Requirements
13. m.Host File Requirements
14. n.Port Requirements
5. 5.Oem 12c Installation Procedure
6. 6.Verification Checks
7. 7.Starting and Stopping oem 12c Services

1. Software : 
The required software for the oem 12c cloud control are :

• CentOS 6.5 (x86_64)  Download
• Oracle Database 12c (x86_64)  Download
• Enterprise Manager Cloud Control 12c (12.1.0.3) (x86_64) Download

2. OS Installation :
We are using CentOS 6.5 for this installation. Please download the latest software and install OS. While installing the OS select the option to install database server, so the most of the required rpms will be installed by default.

3. Database Installation :
Please follow my article Database 12c Installation on CentOS 6.5 for database installation. We need to have the database installed for oem 12c installation. It is called oracle management repository. Oracle database 12c is not yet certified with the oem 12c at the time i am writing this article. But i used database 12c as OMR for oem 12c installation.
Please complete all the following pre-requisite on OMR

[oracle@fsrsrv10 oem12c]$ sqlplus '/as sysdba'
SQL*Plus: Release 12.1.0.1.0 Production on Mon Feb 24 03:04:33 2014
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> sho parameter session_cached
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
session_cached_cursors               integer     50
SQL> sho parameter shared_
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
max_shared_servers                   integer
shared_memory_address                integer     0
shared_pool_reserved_size            big integer 95630131
shared_pool_size                     big integer 0
shared_server_sessions               integer
shared_servers                       integer     1
SQL> alter system set session_cached_cursors=200 scope=both;
alter system set session_cached_cursors=200 scope=both
                 *
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this
option

SQL> desc v$log
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GROUP#                                             NUMBER
 THREAD#                                            NUMBER
 SEQUENCE#                                          NUMBER
 BYTES                                              NUMBER
 BLOCKSIZE                                          NUMBER
 MEMBERS                                            NUMBER
 ARCHIVED                                           VARCHAR2(3)
 STATUS                                             VARCHAR2(16)
 FIRST_CHANGE#                                      NUMBER
 FIRST_TIME                                         DATE
 NEXT_CHANGE#                                       NUMBER
 NEXT_TIME                                          DATE
 CON_ID                                             NUMBER
SQL> desc v$logname
ERROR:
ORA-04043: object v$logname does not exist

SQL> desc v$logfile
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GROUP#                                             NUMBER
 STATUS                                             VARCHAR2(7)
 TYPE                                               VARCHAR2(7)
 MEMBER                                             VARCHAR2(513)
 IS_RECOVERY_DEST_FILE                              VARCHAR2(3)
 CON_ID                                             NUMBER
SQL> select group#,thread#,bytes/1024/1024 from v$log;
    GROUP#    THREAD# BYTES/1024/1024
---------- ---------- ---------------
         1          1              50
         2          1              50
         3          1              50
SQL> select group#,thread#,MEMBERS,bytes/1024/1024 from v$log;
    GROUP#    THREAD#    MEMBERS BYTES/1024/1024
---------- ---------- ---------- ---------------
         1          1          1              50
         2          1          1              50
         3          1          1              50
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/home/apps/oem12c/oradata/oem12c/redo03.log
/home/apps/oem12c/oradata/oem12c/redo02.log
/home/apps/oem12c/oradata/oem12c/redo01.log
SQL> alter database add logfile thread 1 group 4 ('/home/apps/oem12c/oradata/oem12c/redo04.log') size 300M;
Database altered.
SQL> alter database add logfile thread 1 group 5 ('/home/apps/oem12c/oradata/oem12c/redo05.log') size 300M;
Database altered.
SQL> alter database add logfile thread 1 group 6 ('/home/apps/oem12c/oradata/oem12c/redo06.log') size 300M;
Database altered.
SQL> select member,status  from v$logfile;
MEMBER
--------------------------------------------------------------------------------
STATUS
-------
/home/apps/oem12c/oradata/oem12c/redo03.log

/home/apps/oem12c/oradata/oem12c/redo02.log

/home/apps/oem12c/oradata/oem12c/redo01.log


MEMBER
--------------------------------------------------------------------------------
STATUS
-------
/home/apps/oem12c/oradata/oem12c/redo04.log

/home/apps/oem12c/oradata/oem12c/redo05.log

/home/apps/oem12c/oradata/oem12c/redo06.log


6 rows selected.
SQL> select group#,thread#,MEMBERS,status,bytes/1024/1024 from v$log;
    GROUP#    THREAD#    MEMBERS STATUS           BYTES/1024/1024
---------- ---------- ---------- ---------------- ---------------
         1          1          1 INACTIVE                      50
         2          1          1 CURRENT                       50
         3          1          1 INACTIVE                      50
         4          1          1 UNUSED                       300
         5          1          1 UNUSED                       300
         6          1          1 UNUSED                       300
6 rows selected.
SQL> alter database drop logfile group 1;
Database altered.
SQL> alter database drop logfile group 3;
Database altered.
SQL> atler system switch logfile;
SP2-0734: unknown command beginning "atler syst..." - rest of line ignored.
SQL> alter system switch logfile;
System altered.
SQL> alter system checkpoint;
System altered.
SQL> select group#,thread#,MEMBERS,status,bytes/1024/1024 from v$log;
    GROUP#    THREAD#    MEMBERS STATUS           BYTES/1024/1024
---------- ---------- ---------- ---------------- ---------------
         2          1          1 INACTIVE                      50
         4          1          1 CURRENT                      300
         5          1          1 UNUSED                       300
         6          1          1 UNUSED                       300
SQL> alter database drop logfile group 2;
Database altered.
SQL> select group#,thread#,MEMBERS,status,bytes/1024/1024 from v$log;
    GROUP#    THREAD#    MEMBERS STATUS           BYTES/1024/1024
---------- ---------- ---------- ---------------- ---------------
         4          1          1 CURRENT                      300
         5          1          1 UNUSED                       300
         6          1          1 UNUSED                       300
SQL> alter system set session_cached_cursors=250 scope=spfile;
System altered.
SQL> alter system set shared_pool_size=600M scope=spfile;
System altered.
SQL>


SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1.5132E+10 bytes
Fixed Size                  3092488 bytes
Variable Size            1040191480 bytes
Database Buffers         1.4059E+10 bytes
Redo Buffers               29700096 bytes
Database mounted.
Database opened.
SQL> sho parameter session_cached_cursors
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
session_cached_cursors               integer     250
SQL> sho parameter shared_pool_size
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
shared_pool_size                     big integer 608M
SQL>

4.OEM 12c Pre-Requisites : 
4.a Hardware requirements : CPU, RAM, Heap Size, and Hard Disk Space requirements vary depending on the type of installation we are choosing. Please review the here to know the exact hardware requirements.

4.b Operating System Requirements :
Ensure that you install Enterprise Manger Cloud Control only on certified operating system as mentioned in the Enterprise Manager Certification Matrix.

4.c Package Requirements: Though we are using CentOS6.5, we will follow Linux 6.x requirement for the installation.
For OMS : 

Platform	64-Bit Packages for 64-Bit Platform
Oracle Linux 6.x (Red Hat 6 Kernel and Unbreakable Enterprise Kernel (UEK))	make-3.81 binutils-2.20.51.0.2-5.11 gcc-4.4.4 libaio-0.3.107 glibc-common-2.12-1 libstdc++-4.4.4 libXtst-1.0.99.2-3.el6.x86_64.rpm sysstat-9.0.4 glibc-devel-2.12-1.7.el6.i686 (This is a 32-bit package) glibc-devel-2.12-1.7.el6.x86_64 (This is a 64-bit package) (Applicable only for Oracle Linux 6.2, which includes RH6.2 and UEK 6.2) glibc-2.12-1.47.0.2