Thursday 6 December 2018

Step by Step Oracle Enterprise Manager(OEM) 13C installation


Oracle Enterprise Manger 13c installation on OEL 6


This document describes step by steps how to install Oracle Enterprise Manger 13C in OEL 6

1. Assumptions
2. Download Required Softwares
3. 12.1.0.2 Binaries Installation
4. 12.1.0.2 Database Installation using template
5. 13c OEM installation

1. Assumptions:

We assume that already installed Oracle Enterprise Linux 6 in virtual box. Please Click Here to know how to install OEL 6 in virtualbox if did not install it before.

2. Download Required Softwares

   2a. Click Here to download Oracle 12.1.0.2 software
   2b. Click Here to download Oracle 12.1.0.2 database with 13c templates.
   2c. Click Here to download Oracle Enterprise Manger 13c software.

3. 12.1.0.2 Binaries Installation

Installation Prerequisites 

We can use the Oracle provided package to install prerequisites. ( if our server has internet connection)

# yum install oracle-rdbms-server-12cR1-preinstall –y   

Otherwise we have to install prerequisites using below manual process.

1. Go to /etc/sysctl.conf and set the below parameters.

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 = 9000 65000 

2. Go to /etc/security/limits.conf and set below parameters

oracle   soft   nofile    1024
oracle   hard   nofile    65536
oracle   soft   nproc    16384
oracle   hard   nproc    16384
oracle   soft   stack    10240
oracle   hard   stack    32768     

3. Install below packages.

yum install make -y
yum install binutils -y
yum install gcc -y
yum install libaio -y
yum install glibc-common -y
yum install libstdc++ -y
yum install libXtst -y
yum install sysstat -y
yum install glibc -y
yum install glibc-devel -y
yum install glibc-devel.i686 -y

4. Disable firewall.

root@oem ~]# service iptables stop
[root@oem ~]# chkconfig iptables off

5. Users and groups creation

[root@oem ~]# groupadd orinstall
[root@oem ~]# groupadd dba
[root@oem ~]# useradd -g oinstall -G oinstall,dba oracle
[root@oem ~]# passwd oracle

6. Create directory structure for Oracle Home.

[oracle@oem ~]$ mkdir -p /u02/app/oracle/product/12.1.0.2/db_1
[root@oem database]# chown -R oracle:oinstall /u02
[root@oem database]# chown -R 775 /u02


Oracle Binaries Installation:

Step 1:
Go to downloaded software location and start runInstaller to install oracle 12.1.0.2 binaries.

[oracle@oem database]$ ./runInstaller 
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB.   Actual 7312 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 8199 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2018-12-06_11-17-45AM. Please wait ...[oracle@oem database]$ 


Uncheck "oracle updates" and click "Next"


Click "Yest" to continue 


Select "Install database software only" and click "Next"


Select "Single instance database installation" and click "Next"


Click "Next"


Select "Enterprise Edition" and click "Next"


Provide base  and home location. Click "Next"


Click "Next"


Click "Next"

Click "Next"


Click "Install"




Execute above mentioned scripts as root user and click "OK"
]

[root@oem ~]# /u02/app/oraInventory/orainstRoot.sh
Changing permissions of /u02/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u02/app/oraInventory to oinstall.
The execution of the script is complete.
[root@oem ~]# 
[root@oem ~]# /u02/app/oracle/product/12.1.0.2/db_1/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u02/app/oracle/product/12.1.0.2/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]: 
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
[root@oem ~]# 


Click on "Close"


4. 12.1.0.2 Repository Database creation using template.

Copy downloaded 12.1.0.2 database template zip file to $ORACLE_HOME/assistants/dbca/templates and unzip it.

[oracle@oem templates]$ pwd
/u02/app/oracle/product/12.1.0.2/db_1/assistants/dbca/templates

[oracle@oem templates]$ ls -ltr 12.1.0.2.0_Database_Template_for_EM13_2_0_0_0_Linux_x64.zip 
-rwxr-xr-x. 1 oracle oinstall 376876746 Dec  6 14:19 12.1.0.2.0_Database_Template_for_EM13_2_0_0_0_Linux_x64.zip

Unzip above zip file and create database using dbca.

[oracle@oem bin]$ ./dbca


Click "Next"


Select "Advanced Mode" and click "Next"


Select "12.1.0.2.0 database template for EM13.2.0.0  Large deployment" and click "Next"


Provide database name (SID) and click "Next"



Uncheck "Configure Enterprise Manager (EM) Database Express" and click "Next"


Provide password for sys and system account and click "Next"


Provide listener name, port and click "Next"


Provide datafiles location, fast recovery area location, select check box for enabling archive mode and click "Next"


Click "Next"





Click "Next"


Click "Next"


Click on "Finish"



Click on "Close"

[oracle@oem bin]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 6 15:11:18 2018

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select name,open_mode from v$database;

NAME   OPEN_MODE
--------- --------------------
GRIDDB   READ WRITE

SQL> 


5. 13c OEM installation

Go to downloaded 13c software location and start the installation by executing "em13200_linux64.bin".  We no need to unzip the downloaded zip file. Installer takes care of it as part of installation.

Note: Make sure we have minimum 10GB free space under /tmp.

Create directory structure for Middleware home and agent.

[oracle@oem ~]$ mkdir -p /u01/app/oracle/Middleware
[oracle@oem ~]$ mkdir -p /u01/app/oracle/agent

[oracle@oem 13C_EM]$ ./em13200_linux64.bin


Uncheck "Oracle updates" and click "Next"


Click "Yes" to continue


Select "Skip" and Click "Next"



Click "Next"


Click "Next"


Provide location for Middleware home, agent base and click "Next"


Provide weblogic Admin password, create database connectivity details and click on "Next"


Provide software library location, configuration location, cluster location for BI Publisher and click "Next"


Click on "Install"





Execute allroot.sh script as root user and click "OK"

[root@oem ~]# /u01/app/oracle/Middleware/allroot.sh 

Starting to execute allroot.sh ......... 

Starting to execute /u01/app/oracle/Middleware/root.sh ......
/etc exist

Creating /etc/oragchomelist file...
/u01/app/oracle/Middleware
Finished product-specific root actions.
/etc exist
Finished execution of  /u01/app/oracle/Middleware/root.sh ......

Starting to execute /u01/app/oracle/agent/agent_13.2.0.0.0/root.sh ......
Finished product-specific root actions.
/etc exist
Finished execution of  /u01/app/oracle/agent/agent_13.2.0.0.0/root.sh ......
[root@oem ~]# 



Click on "Close"


Verification:

Console login: 



Enterprise manager Login:



Login with SYSMAN user and use the password which you have given while installing.




Accept the license 






BI Publisher Login:








Thanks for your patience to view this  post..........









4 comments:

  1. Thanks for sharing this great information on Oracle APEX. Actually I was looking for the same information on internet for Oracle Apex Interview Questions and Answers and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more about Oracle APEX by attending Oracle APEX Training.

    ReplyDelete
  2. Hi Vijay,

    IS below step must in post steps of oem 13c installation. Can I Ignore this.

    Configuring Proxies for OMS and Management Agent Communication

    ReplyDelete