Tuesday, July 12, 2016

Install Oracle Enterprise Manager 12c Cloud control

7:22 AM Posted by Dilli Raj Maharjan No comments

Oracle Enterprise Manager is central management platform for testing, deploying, operating, monitoring, diagnosing, and resolving problems on Oracle applications, databases, middleware, hardware and engineered systems. Following is the step by step installation guide for OEM 12c Cloud control on CentOS 6.4.


Environment: 

OS: CentOS 6.4
RAM: 16GB
CPU: Intel Core i5
HDD: 200GB

Hardware Requirement:


OEM SizeSMALLMEDIUMLARGE
CPU Cores248
RAM GB6816
HDDGB181818

Package required:

  • make
  • binutils
  • gcc
  • libaio
  • glibc-common
  • libstdc++
  • libXtst
  • sysstat
  • glibc-devel 32bit and 64 bit
  • glibc

rpm -q make binutils gcc libaio glibc-common libstdc++ libXtst sysstat glibc glibc-devel








Kernel parameters

kernel.shmmax=4294967295
net.ipv4.ip_local_port_range = 11000 65000


User requirement

The Oracle Inventory Group (typically, oinstall)
The Oracle Software Owner User (typically, oracle)
Creating user

/usr/sbin/groupadd oinstall
/usr/sbin/useradd -g oinstall oracle
passwd oracle


Create directory to store OMR software

mkdir -p /ssd/oracle/Middleware
chown -R oracle:oinstall /ssd/oracle/Middleware


Create directory to store software library

mkdir -p /ssd/oracle/swlib
chown -R oracle:oinstall /ssd/oracle/swlib



Extract compressed EM source files.

unzip em12105_linux64_disk1.zip
unzip em12105_linux64_disk2.zip
unzip em12105_linux64_disk3.zip


Oracle Management Repository (OMR) database 

Oracle Management Repository (OMR) database should be installed prior to installing Oracle Enterprise Manager 12c Cloud Control. Install Oracle database 11g R2 as OMR database and note down SYSMAN password, hostname, port and Database SID. We need to provide these details on the installation wizard.
In my case I have installed OMR(Oracle Management Repository) database and OMS(Oracle Management Server) on same host so following is the detail of OMR database:

Database Host name: core.localdomain
Port: 1521
Service/SID: omrdb 
Sysman password: **********


Verify ORACLE_HOME, ORACLE_SID AND PATH Environment variables.





Unset ORACLE_HOME, ORACLE_SID AND PATH Environment variables.


Execute Installer with ./runInstaller executables




As runInstaller executable file is get executed support details page will be displayed.


Uncheck "I wish to receive security updates via My Oracle Support". Click on Next to continue.
Warning message will be displayed regarding the security issue. Click on Yes to continue.


Select Skip in the case of Software Updates and Click on Next to continue.


Make sure All the Prerequisite are Succeeded. If there is any failure the fix it and re-run. Click on Next to continue.


Select the installation type. Select simple in case of Typical installation. We may select Advance for more options. Click on Next after selecting Simple.

Select Middleware Home Location, Agent Base Directory and Host Name. Click on Next to continue.


Type Administrator password for the Weblogic server. Please note this down for future upgradation and webLogic management. Type OMR database hostname, port, service/sid and SYS password.


Some fixable pre-requisite has failed. These pre-requisite can be fixed by installed. Simple Click Yes to fix issue automatically and continue.

More fixable warnings. Click on OK to continue


Review Window will be displayed. Click on Install to begin installation.





Oracle Enterprise Manager 12c Cloud Control installation in progress. #####
Oracle Enterprise Manager 12c Cloud Control installation in progress. ##########

Execute Configuration scripts window will be displayed. Execute listed script as user root and Click OK once script executed successfully.


Finally Installation Completed Window will be displayed . Click on Close to complete installation.

Now we can login to OEM 12c Cloud control with URL and credentials below:
URL: https://core.localdomain:7802/em
Username: sysaux
Password:  



Saturday, July 9, 2016

Install Oracle Database 12c on Linux

9:20 PM Posted by Dilli Raj Maharjan No comments

Hardware Requirments

Disk Space Requirements on Linux x86-64


Database EditionDisk Space
Enterprise Edition6.4 GB
Standard Edition6.1 GB
Standard Edition One6.1 GB
Standard Edition 26.1 GB


Memory Requirement


RAMSwap Space
Between 1 GB and 2 GB1.5 times the size of the RAM
Between 2 GB and 16 GBEqual to the size of the RAM
More than 16 GB16 GB

OS Requirement

  • Oracle Linux 7, Red Hat Enterprise Linux 7 Distributions Kernel 3.10.0-54.0.1.el7.x86_64 or later
  • Oracle Linux 6, Red Hat Enterprise Linux 6 Distributions Kernel 2.6.32-71.el6.x86_64 or later
  • Oracle Linux 5 Update 6, Red Hat Enterprise Linux 5 Distributions Update 6 with Kernel 2.6.18-238.0.0.0.1.el5 or later
  • SUSE Distributions for x86-64
  • SUSE Linux Enterprise Server 11 SP2: 3.0.13-0.27 or later
  • SUSE Linux Enterprise Server 12 SP1: 3.12.49-11 or later


Package for RHEL 7

  • binutils-2.23.52.0.1-12.el7.x86_64
  • compat-libcap1-1.10-3.el7.x86_64
  • compat-libstdc++-33-3.2.3-71.el7.i686
  • compat-libstdc++-33-3.2.3-71.el7.x86_64
  • gcc-4.8.2-3.el7.x86_64
  • gcc-c++-4.8.2-3.el7.x86_64
  • glibc-2.17-36.el7.i686
  • glibc-2.17-36.el7.x86_64
  • glibc-devel-2.17-36.el7.i686
  • glibc-devel-2.17-36.el7.x86_64
  • ksh
  • libaio-0.3.109-9.el7.i686
  • libaio-0.3.109-9.el7.x86_64
  • libaio-devel-0.3.109-9.el7.i686
  • libaio-devel-0.3.109-9.el7.x86_64
  • libgcc-4.8.2-3.el7.i686
  • libgcc-4.8.2-3.el7.x86_64
  • libstdc++-4.8.2-3.el7.i686
  • libstdc++-4.8.2-3.el7.x86_64
  • libstdc++-devel-4.8.2-3.el7.i686
  • libstdc++-devel-4.8.2-3.el7.x86_64
  • libXi-1.7.2-1.el7.i686
  • libXi-1.7.2-1.el7.x86_64
  • libXtst-1.2.2-1.el7.i686
  • libXtst-1.2.2-1.el7.x86_64
  • make-3.82-19.el7.x86_64
  • sysstat-10.1.5-1.el7.x86_64


Package for RHEL 6

  • binutils-2.20.51.0.2-5.11.el6 (x86_64)
  • compat-libcap1-1.10-1 (x86_64)
  • compat-libstdc++-33-3.2.3-69.el6 (x86_64)
  • compat-libstdc++-33-3.2.3-69.el6 (i686)
  • gcc-4.4.4-13.el6 (x86_64)
  • gcc-c++-4.4.4-13.el6 (x86_64)
  • glibc-2.12-1.7.el6 (i686)
  • glibc-2.12-1.7.el6 (x86_64)
  • glibc-devel-2.12-1.7.el6 (x86_64)
  • glibc-devel-2.12-1.7.el6 (i686)
  • ksh
  • libgcc-4.4.4-13.el6 (i686)
  • libgcc-4.4.4-13.el6 (x86_64)
  • libstdc++-4.4.4-13.el6 (x86_64)
  • libstdc++-4.4.4-13.el6 (i686)
  • libstdc++-devel-4.4.4-13.el6 (x86_64)
  • libstdc++-devel-4.4.4-13.el6 (i686)
  • libaio-0.3.107-10.el6 (x86_64)
  • libaio-0.3.107-10.el6 (i686)
  • libaio-devel-0.3.107-10.el6 (x86_64)
  • libaio-devel-0.3.107-10.el6 (i686)
  • libXext-1.1 (x86_64)
  • libXext-1.1 (i686)
  • libXtst-1.0.99.2 (x86_64)
  • libXtst-1.0.99.2 (i686)
  • libX11-1.3 (x86_64)
  • libX11-1.3 (i686)
  • libXau-1.0.5 (x86_64)
  • libXau-1.0.5 (i686)
  • libxcb-1.5 (x86_64)
  • libxcb-1.5 (i686)
  • libXi-1.3 (x86_64)
  • libXi-1.3 (i686)
  • make-3.81-19.el6
  • sysstat-9.0.4-11.el6 (x86_64)


Use Command below to verify rpm installed or not.

rpm -q binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libgcc libstdc++ libstdc++-devel libaio libaio-devel libXext libXtst libX11 libXau libxcb libXi make sysstat


List all the i686 packages installed

rpm -qa --queryformat '%{NAME} %{ARCH}\n' | grep 'i[6543]86' | cut -d' ' -f1

List of the i686 packages required

  • compat-libstdc++-33
  • glibc
  • glibc-devel
  • libgcc
  • libstdc++
  • libstdc++-devel
  • libaio
  • libaio-devel
  • libXext
  • libXtst
  • libX11
  • libXau
  • libxcb
  • libXi



Use command below to install required i686 packages

rpm -ivh glibc-devel-2.12-1.80.el6.i686.rpm libstdc++-4.4.6-4.el6.i686.rpm libstdc++-devel-4.4.6-4.el6.i686.rpm libaio-0.3.107-10.el6.i686.rpm libaio-devel-0.3.107-10.el6.i686.rpm libXext-1.1-3.el6.i686.rpm libXtst-1.0.99.2-3.el6.i686.rpm libX11-1.3-2.el6.i686.rpm libXau-1.0.5-1.el6.i686.rpm libxcb-1.5-1.el6.i686.rpm libXi-1.3-3.el6.i686.rpm


Package for RHEL 5

  • binutils-2.17.50.0.6
  • compat-libstdc++-33-3.2.3
  • compat-libstdc++-33-3.2.3 (32 bit)
  • coreutils-5.97-23.el5_4.1
  • gcc-4.1.2
  • gcc-c++-4.1.2
  • glibc-2.5-58
  • glibc-2.5-58 (32 bit)
  • glibc-devel-2.5-58
  • glibc-devel-2.5-58 (32 bit)
  • ksh
  • libaio-0.3.106
  • libaio-0.3.106 (32 bit)
  • libaio-devel-0.3.106
  • libaio-devel-0.3.106 (32 bit)
  • libgcc-4.1.2
  • libgcc-4.1.2 (32 bit)
  • libstdc++-4.1.2
  • libstdc++-4.1.2 (32 bit)
  • libstdc++-devel 4.1.2
  • libXext-1.0.1
  • libXext-1.0.1 (32 bit)
  • libXtst-1.0.1
  • libXtst-1.0.1 (32 bit)
  • libX11-1.0.3
  • libX11-1.0.3 (32 bit)
  • libXau-1.0.1
  • libXau-1.0.1 (32 bit)
  • libXi-1.0.1
  • libXi-1.0.1 (32 bit)
  • make-3.81
  • sysstat-7.0.2


Package for SUSE 11

  • binutils-2.21.1-0.7.25
  • gcc-4.3-62.198
  • gcc-c++-4.3-62.198
  • glibc-2.11.3-17.31.1
  • glibc-devel-2.11.3-17.31.1
  • ksh-93u-0.6.1
  • libaio-0.3.109-0.1.46
  • libaio-devel-0.3.109-0.1.46
  • libcap1-1.10-6.10
  • libstdc++33-3.3.3-11.9
  • libstdc++33-32bit-3.3.3-11.9
  • libstdc++43-devel-4.3.4_20091019-0.22.17
  • libstdc++46-4.6.1_20110701-0.13.9
  • libgcc46-4.6.1_20110701-0.13.9
  • make-3.81
  • sysstat-8.1.5-7.32.1
  • xorg-x11-libs-32bit-7.4
  • xorg-x11-libs-7.4
  • xorg-x11-libX11-32bit-7.4
  • xorg-x11-libX11-7.4
  • xorg-x11-libXau-32bit-7.4
  • xorg-x11-libXau-7.4
  • xorg-x11-libxcb-32bit-7.4
  • xorg-x11-libxcb-7.4
  • xorg-x11-libXext-32bit-7.4
  • xorg-x11-libXext-7.4


Package for SUSE12

  • binutils-2.25.0-13.1
  • gcc-4.8-6.189
  • gcc48-4.8.5-24.1
  • glibc-2.19-31.9
  • glibc-32bit-2.19-31.9
  • glibc-devel-2.19-31.9.x86_64
  • glibc-devel-32bit-2.19-31.9.x86_64
  • mksh-50-2.13
  • libaio1-0.3.109-17.15
  • libaio-devel-0.3.109-17.15
  • libcap1-1.10-59.61
  • libstdc++48-devel-4.8.5-24.1.x86_64
  • libstdc++48-devel-32bit-4.8.5-24.1.x86_64
  • libstdc++6-5.2.1+r226025-4.1.x86_64
  • libstdc++6-32bit-5.2.1+r226025-4.1.x86_64
  • libstdc++-devel-4.8-6.189.x86_64
  • libstdc++-devel-32bit-4.8-6.189.x86_64
  • libgcc_s1-5.2.1+r226025-4.1.x86_64
  • libgcc_s1-32bit-5.2.1+r226025-4.1.x86_64
  • make-4.0-4.1.x86_64
  • sysstat-10.2.1-3.1.x86_64
  • xorg-x11-driver-video-7.6_1-14.30.x86_64
  • xorg-x11-server-7.6_1.15.2-36.21.x86_64
  • xorg-x11-essentials-7.6_1-14.17.noarch
  • xorg-x11-Xvnc-1.4.3-7.2.x86_64
  • xorg-x11-fonts-core-7.6-29.45.noarch
  • xorg-x11-7.6_1-14.17.noarch
  • xorg-x11-server-extra-7.6_1.15.2-36.21.x86_64
  • xorg-x11-libs-7.6-45.14.noarch
  • xorg-x11-fonts-7.6-29.45.noarch


Configure host file

/etc/hosts


Kernel parameters required.

kernel.sem = 250 32000 100 128
kernel.shmall = 3355443
kernel.shmmax = 3986726912
kernel.shmmni = 4096
kernel.panic_on_oops = 1
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 11000 65000
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

Execute command below to get new kernel setting in effect.

sysctl -p


Change Linux kernel setting on runtime

echo 11000 65500 > /proc/sys/net/ipv4/ip_local_port_range

Creating required Operating System Group and Users

Create Oracle Inverntory group
/usr/sbin/groupadd -g 1000 oinstall
Create Oracle dba group
/usr/sbin/groupadd -g 1001 dba
Create Oracle operator group
/usr/sbin/groupadd -g 1002 oper

Create Oracle software owner user

useradd -u 1000 -g oinstall -G oinstall,dba,oper oracle
passwd oracle


Checking Resource limits for Oracle software Installation user.

/etc/security/limits.conf
oracle   soft   nofile    1024
oracle   hard   nofile    65536
oracle   soft   nproc    2047
oracle   hard   nproc    16384
oracle   soft   stack    10240
oracle   hard   stack    32768

Set secure linux to permissive by editing /etc/selinux/config

SELINUX=permissive

Once modification is completed execute following command to set secure linux to Permissive

setenforce Permissive

Disable iptables firewall

/etc/init.d/iptables stop
chkconfig iptables off 345

Create Oracle Home directory

mkdir -p /u01/app/oracle/product/12.1.0.2/db_1
chown -R oracle:oinstall /u01/app

Configure oracle environment
Add following lines on .bash_profile file on /home/oracle

export ORACLE_HOSTNAME=oem13c.localdomain
export ORACLE_UNQNAME=oemrep
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0.2/db_1
export ORACLE_SID=oemrep

export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

Login as user oracle
Change directory to oracle staging
Execute runInstaller






























After executing runInstaller executable above window will be displayed.































Uncheck I wish to receive security updates via My Oracle Support and Click on Next to continue















Warning window will be displayed. Click on Yes to continue.































I am planning to install database later manually. Installing database later enables selecting template for OEM database. So selecting Install database software only option.































Select Single Instance database installation and click on Next to continue.































Select language and click on Next to continue.































Select database edition option and click on Next to continue.































Select oracle base and Software location. Click on Next to continue.































Select Inventory Directory and oraInventory group Name. Click on Next to continue.































Select OS groups for OSDBA, OSOPER, OSBACKUPDBA, OSDGDBA, OSKMDBA. Click on Next to continue.































Click on Save Response File to save the summary.
























Selection the location and file name click on save to save response file.































Click on Install to begin installation.































Installation on progress ####################































Installation on progress ########################################























































Execute above scripts as user root and click on OK.


























Click on OK to continue.































Finally Click on Close to finish the installation.
                                   
Oracle 12c network Configuration

Oracle 12c Network Configuration

9:19 PM Posted by Dilli Raj Maharjan No comments
Oracle Net is a software component that resides on the client and on the Oracle database server. It establishes and maintains the connection between the client application and the server, and exchanges messages between them using industry standard protocols.

The Oracle Net listener (the listener), is a process that listens for client connection requests. 
It receives incoming client connection requests and manages the traffic of these requests to the database server. The configuration file listener.ora stores the detail information about the listener. The file contains the protocol, port and host information. Following is the sample listener configuration.

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db.localdomain) (PORT=1521)))

Net service name is the connect descriptor that contains the protocol, hostname of the server,
port of the listener and the service that we are willing to connect. Following is the sample 
net service name.
DESCRIPTION=
   (ADDRESS=(PROTOCOL=tcp)(HOST=db.localdomain) PORT=1521))
   (CONNECT_DATA=
      (SERVICE_NAME=orcl))

Execute netca command from the $ORACLE_HOME/bin location.



Select Listener configuration and Click on Next to continue.



Select Add and Click on Next to continue.



Enter the name of the listener. It may be any name. It is recommended to create Listener with name LISTENER for the first one. Later on we can create multiple listeners with different names as LIST_BATCH, LIST_ACC for batch processing and account departments.



Select the required protocols. Click on Next to continue.



Select required port. 1521 is oracle's default port. We can use different ports in case of multiple listeners. Click on Next to continue.



Finally listener configuration is completed. Click on Next to continue.



Select Local Net Service Name configuration for creating Net service Name. Click on Next to continue.



Select Add and Click on Next.



Select net service Name. Service name is generally the global database name. Click on Next to continue.



Select protocol and Click on Next.



Select host name. Click on Next to continue.



Select No, do not test. Click on Next to continue.



Type net service name. Click on Next to continue.



Click on No and Click on Next.



Click on Next on the Net service name configuration Complete message window. Click on Next to continue.




Finally Click on Finish to end the Local Net service name configuration.

<< install oracle database 12c on linux

oracle 12c Create database with dbca >>