Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Install Oracle Enterprise Manager (OEM) Cloud Control 12c on OEL 6.1

Install Oracle Enterprise Manager (OEM) Cloud Control 12c on OEL 6.1

Oracle announced recently at OOW 2011 the release of the brand new re-engineered OEM Cloud Control 12c (c stands for the cloud). This is the first product from the 12c family of products intended for the cloud. At present, as of the time of the writing of the article, OEM 12c is only available for download for Linux x86 (32bit) and Linux x86-64 (64bit) from OTN.

In the article you will have a look at  how to prepare the OEL 6.1 and subsequently install OEM 12c on OEL 6.1. OEM 12c requires a repository database. In the article Oracle 11.2.0.3 database is used a repository. I will provide pointers to MOS or Oracle documentation for supported OS and repository database versions.

Select a supported OS and install supported Oracle database for repository. MOS maintains a list of certified platforms and products for a product. For OEM 12c you will be interested in

  1. Certified OS for installation
  2. Certified Oracle database for repository
  3. Certified targets


Always check the certification matrix as it is updated as new supported OS are added and new inter-operability database patches are added.





Oracle® Enterprise Manager Cloud Control Basic Installation Guide
12c Release 1 (12.1.0.1) also
contains a list of prerequisites for
OEL and repository database. The complete set of OEM 12c documentation is available here.

In the article the following software products will be used.

  1. Oracle 11gR2 (11.2.0.3) for Linux (x86-64). Patch 10404530. Download from MOS here.
  2. Oracle Enterprise Linux OEL 6.1(x86-64). Download from here.
  3. Oracle VM VirtualBox 4.1.4. Download from here.
  4. Enterprise Manager Cloud Control 12c Release 1 (12.1.0.1). Download from here.

In the article I will reuse the OEL61 VM created here to install OEM 12c and will outline the steps to follow if you start from a new OEL 6.1 installation. Proceed for OS configuration and OEM 12c installation once you are on supported OS and have a supported Oracle RDBMS database for an OEM repository.

Installation of OEL 6.1 and Oracle 11.2.0.3 GI and RDBMS and creating RAC database is covered here.

A complete prerequisite check list can be found here. In the article an assumption is made that an Oracle RDBMS is created for a repository prior to OEM 12c installation. The database in this article is RAC 11.2.0.3.
Continue reading

October 9, 2011 Posted by | oracle | 85 Comments

Build two node Oracle RAC 11gR2 11.2.0.3 with GNS (DNS, DHCP) and HAIP

Build two node Oracle RAC 11gR2 11.2.0.3 with GNS (DNS, DHCP) and HAIP

Revision 1.0 : 19th April 2012 : DISABLE SELINUX in order to successfully create ASM disks using ASMlib: See Annex 1

In the article you will have a look at how to use some Oracle VirtualBox features to build two node Oracle 11gR2 (11.2.0.3) RAC system on Oracle Enterprise Linux (OEL 6.1). The setup will implement a role separation with different users for Oracle RDBMS and Oracle GI that is, user oracle and grid respectively in order to split the responsibilities between DBAs and storage administrators. The article will show you how to configure DHCP and a sample DNS setup for GNS deployment. You will have a glimpse at deploying HAIP feature allowing up to four private interconnect interfaces.

An overview to Oracle Virtualization solutions can be seen here. You can see how to use Oracle VM VirtualBox to build a two node Solaris cluster here. For information related to building a RAC 11gR2 cluster on OEL without GNS click here.

In the article you will see how to configure Linux in an Oracle VM VirtualBox Virtual machines, install Oracle GI, Oracle RDBMS and will create a policy managed database and service.

The following software will be used:

  1. Oracle 11gR2 (11.2.0.3) for Linux (x86-64). Patch 10404530. Download from MOS here.
  2. Oracle Enterprise Linux OEL 6.1(x86-64). Download from here.
  3. Oracle VM VirtualBox 4.1.2. Download from here.

Three virtual machines will be created and used.

  1. OEL61A for RAC node oel61a
  2. OEL61B for RAC node oel61b
  3. OEL61 for DNS and DHCP server

Ideally a DNS server should be on a dedicated physical server not a part of the cluster. Due to limited resources in this article DNS server will be configured to meet the prerequisites for GI and RDBMS installation for later node addition.

Two virtual machines, OEL61A and OEL61B, will be configured for RAC nodes each with:

  • 4GB RAM
  • 300GB bootable disk (Disk space will be dynamically allocated not a fixed size pre-allocation)
  • NIC – bridged for public interface in RAC with address 192.168.2.21/22 (first IP 192.168.2.21 on oel61a and second IP 192.168.2.22 on node oel61b). These are public interface in RAC.
  • NIC – bridged for private interface in RAC with address 10.10.2.21/22 (first IP 10.10.2.21 on oel61a and second IP 10.10.2.22 on node oel61b). These are private interface in RAC.
  • NIC – bridged for private interface in RAC with address 10.10.5.21/22 (first IP 10.10.5.21 on oel61a and second IP 10.10.5.22 on node oel61b). These are private interface in RAC.
  • NIC – bridged for private interface in RAC with address 10.10.10.21/22 (first IP 10.10.10.21 on oel61a and second IP 10.10.10.22 on node oel61b). These are private interface in RAC.
  • 5 10GB attached shared disks for the ASM storage. (Normal Redundancy ASM disk groups will be deployed).

Virtual machine OEL61 will be configured as follows (I will use it for add node later on):

  • 4GB RAM
  • 300GB bootable disk (Disk space will be dynamically allocated not a fixed size pre-allocation)
  • NIC – bridged for public interface in RAC with address 192.168.2.11
  • NIC – bridged for private interface in RAC with address 10.10.2.11
  • NIC – bridged for private interface in RAC with address 10.10.5.11
  • NIC – bridged for private interface in RAC with address 10.10.10.11

The interfaces’ IP addresses will be as show in the table 1 below.

OEL61 – DNS server and for later add node process. OEL61A RAC node oel61a OEL61B RAC node oel61a
eth0 10.10.2.11 10.10.2.21 10.10.2.22
eth1 192.168.2.11 192.168.2.21 192.168.2.22
eth2 10.10.10.11 10.10.10.21 10.10.10.22
eth3 10.10.5.11 10.10.5.21 10.10.5.22

The following MOS notes were used:

  1. 11gR2 Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haip [ID 1210883.1]
  1. DNS and DHCP Setup Example for Grid Infrastructure GNS [ID 946452.1]

The article will cover the following topics

  1. Create an OEL61A VM with OEL 6.1 as guest OS for node oel61a.
  2. Configure the OEL61A VM to meet the prerequisites for GI and RAC 11.2.0.3 deployment.
  3. Clone OEL61A to OEL61B.
  4. Clone OEL61A to OEL61.
  5. Set up DNS and DHCP server on OEL61.
  6. Install GI 11.2.0.3 on oel61a and oel61b.
  7. Install RAC RDBMS 11.2.0.3 on oel61a and oel61b.
  8. Create a policy managed database RACDB oel61a and oel61b.
  9. Verify database creation and create a service.

To continue reading download the article from here or read from here.

October 5, 2011 Posted by | oracle | 31 Comments

Virtualization using Oracle VM VirtualBox for building two node Oracle RAC 11gR2 (11.2.0.3) cluster on OEL 6.1 using GNS (based on DNS and DHCP) with multiple private interconnects deploying HAIP feature

Virtualization using Oracle VM VirtualBox for building two node Oracle RAC 11gR2 (11.2.0.3) cluster on OEL 6.1 using GNS (based on DNS and DHCP) with multiple private interconnects deploying HAIP feature

Revision 1.0 : 19th April 2012 : DISABLE SELINUX in order to create successfully ASM disks using ASMlib: See Annex 1

In the article you will have a look at how to use some Oracle VirtualBox features to build two node Oracle 11gR2 (11.2.0.3) RAC system on Oracle Enterprise Linux (OEL 6.1). The setup will implement a role separation with different users for Oracle RDBMS and Oracle GI that is, user oracle and grid respectively in order to split the responsibilities between DBAs and storage administrators. The article will show you how to configure DHCP and a sample DNS setup for GNS deployment. You will have a glimpse at deploying HAIP feature allowing up to four private interconnect interfaces.

An overview to Oracle Virtualization solutions can be seen here. You can see how to use Oracle VM VirtualBox to build a two node Solaris cluster here. For information related to building a RAC 11gR2 cluster on OEL without GNS click here.

In the article you will see how to configure Linux in an Oracle VM VirtualBox Virtual machines, install Oracle GI, Oracle RDBMS and will create a policy managed database and service.

The following software will be used:

  1. Oracle 11gR2 (11.2.0.3) for Linux (x86-64). Patch 10404530. Download from MOS here.
  2. Oracle Enterprise Linux OEL 6.1(x86-64). Download from here.
  3. Oracle VM VirtualBox 4.1.2. Download from here.

Continue reading

October 4, 2011 Posted by | oracle | 56 Comments