Guenadi N Jilevski's Oracle BLOG

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

The best deals from Packt Publishing

This month marks 10 years since Packt Publishing embarked on its mission to deliver effective learning and information services to IT professionals.

To celebrate this huge milestone, Packt is offering all of its eBooks and Videos at just $10 each for 10 days – this promotion covers every title and customers can stock up on as many copies as they like until July 5th. Please visit Packt Publishing here.

July 1, 2014 Posted by | oracle | 2 Comments

Upgrade OEM Cloud Control 12cR1 no BP1 on OEL 6.1 to OEM Cloud Control 12cR4 on OEL 6.5 – Download

Upgrade OEM Cloud Control 12cR1 no BP1 on OEL 6.1 to OEM Cloud Control 12cR4 on OEL 6.5 – Download

In the article you will have a look at the steps and guidelines for upgrading OEM Cloud Control 12cR1 no BP1 on OEL 6.1 to OEM Cloud Control 12cR4 on OEL 6.5. This initial configuration is described here. The OMR is Oracle 11.2.0.3 database. Looking at the certification matrix on MOS you will notice that platforms are certified and supported.

You can read online from here or download Upgrade OEM CC 12cR1 on OEL 6.1 to OEM CC 12cR4 on OEL 6.5

June 25, 2014 Posted by | oracle | 1 Comment

Upgrade OEM Cloud Control 12cR1 no BP1 on OEL 6.1 to OEM Cloud Control 12cR4 on OEL 6.5

Upgrade OEM Cloud Control 12cR1 no BP1 on OEL 6.1 to OEM Cloud Control 12cR4 on OEL 6.5

In the article you will have a look at the steps and guidelines for upgrading OEM Cloud Control 12cR1 no BP1 on OEL 6.1 to OEM Cloud Control 12cR4 on OEL 6.5. This initial configuration is described here. The OMR is Oracle 11.2.0.3 database. Looking at the certification matrix on MOS you will notice that platforms are certified and supported.
Continue reading

June 25, 2014 Posted by | oracle | 1 Comment

Install Oracle Enterprise Manager Cloud control 12cR4 on OEL 6.5 – Download

Install Oracle Enterprise Manager Cloud control 12cR4 on OEL 6.5 – Download

In the article you will have a look at the guidelines and steps to install OEM Cloud Control 12cR4 on Oracle Linux 6.5 X86_64. You will have a glimpse at how to configure OEL 6.5 for OEM CC 12cR4 installation. Oracle 12.1.0.1 database is used as an Oracle Management Repository (OMR) database. I will provide pointers to MOS or Oracle Documentation for the supported OS and Repository database versions.

The environment I use is an Oracle VM VirtualBox running on a MS Windows host OS with OEL 6.5 x86_64 guest OS. I am not going to describe neither details of configuring the Oracle VM VirtualBox nor details on installing OEL 6.5 and installing Oracle RDBMS binaries 12.1.0.1 and databases. More information about the latter can be found here. I would like to point out that you need to pay attention for the hardware and software requirements described here. My VM running the guest OS is configured with 8GB RAM and 80GB of disk space. The latter is to accommodate the disk footprint for Oracle binaries, stage area and Oracle databases. If you need to add disk space to already configured VM look at here.

You can read online from here or download Install Oracle Enterprise Manager Cloud control 12cR4 on OEL 6_5

June 23, 2014 Posted by | oracle | 1 Comment

Install Oracle Enterprise Manager Cloud control 12cR4 on OEL 6.5

Install Oracle Enterprise Manager Cloud control 12cR4 on OEL 6.5

In the article you will have a look at the guidelines and steps to install OEM Cloud Control 12cR4 on Oracle Linux 6.5 X86_64. You will have a glimpse at how to configure OEL 6.5 for OEM CC 12cR4 installation. Oracle 12.1.0.1 database is used as an Oracle Management Repository (OMR) database. I will provide pointers to MOS or Oracle Documentation for the supported OS and Repository database versions.

The environment I use is an Oracle VM VirtualBox running on a MS Windows host OS with OEL 6.5 x86_64 guest OS. I am not going to describe neither details of configuring the Oracle VM VirtualBox nor details on installing OEL 6.5 and installing Oracle RDBMS binaries 12.1.0.1 and databases. More information about the latter can be found here. I would like to point out that you need to pay attention for the hardware and software requirements described here. My VM running the guest OS is configured with 8GB RAM and 80GB of disk space. The latter is to accommodate the disk footprint for Oracle binaries, stage area and Oracle databases. If you need to add disk space to already configured VM look at here.
Continue reading

June 23, 2014 Posted by | oracle | 1 Comment

Install Oracle Enterprise Manager Cloud control 12cR3 on OEL 6.5 – Download

Install Oracle Enterprise Manager Cloud control 12cR3 on OEL 6.5 – Download

In the article you will have a look at the guidelines and steps to install OEM Cloud Control 12cR3 on Oracle Linux 6.5 X86_64. You will have a glimpse at how to configure OEL 6.5 for OEM CC 12cR3 installation. Oracle 11.2.0.4 database is used as an Oracle Management Repository database. I will provide pointers to MOS or Oracle Documentation for the supported OS and Repository database versions.

The environment I use is an Oracle VM VirtualBox running on a MS Windows host OS with OEL 6.5 x86_64 guest OS. I am not going to describe details of configuring the Oracle VM VirtualBox nor on installing OEL 6.5 nor installing Oracle RDBMS binaries 11.2.0.4 and 12.1.0.1 and databases. More information about the latter can be found here. I would like to point out that you need to pay attention for the hardware and software requirements described here. My VM running the guest OS is configured with 8GB and 80GB of disk space. The latter is to accommodate the disk footprint for Oracle binaries, stage area and Oracle databases. If you need to add disk space to already configured VM look at here.

You can read online from here or download Install Oracle Enterprise Manager Cloud control 12cR3 on OEL 6_5

June 23, 2014 Posted by | oracle | Leave a comment

Install Oracle Enterprise Manager Cloud control 12cR3 on OEL 6.5

Install Oracle Enterprise Manager Cloud control 12cR3 on OEL 6.5

In the article you will have a look at the guidelines and steps to install OEM Cloud Control 12cR3 on Oracle Linux 6.5 X86_64. You will have a glimpse at how to configure OEL 6.5 for OEM CC 12cR3 installation. Oracle 11.2.0.4 database is used as an Oracle Management Repository database. I will provide pointers to MOS or Oracle Documentation for the supported OS and Repository database versions.

The environment I use is an Oracle VM VirtualBox running on a MS Windows host OS with OEL 6.5 x86_64 guest OS. I am not going to describe details of configuring the Oracle VM VirtualBox nor on installing OEL 6.5 nor installing Oracle RDBMS binaries 11.2.0.4 and 12.1.0.1 and databases. More information about the latter can be found here. I would like to point out that you need to pay attention for the hardware and software requirements described here. My VM running the guest OS is configured with 8GB and 80GB of disk space. The latter is to accommodate the disk footprint for Oracle binaries, stage area and Oracle databases. If you need to add disk space to already configured VM look at here.
Continue reading

June 23, 2014 Posted by | oracle | 1 Comment

Build two node Oracle RAC 12c (12.1.0.1) cluster on OEL 6.5 using Oracle VM Virtual Box – Download

Build two node Oracle RAC 12c (12.1.0.1) cluster on OEL 6.5 using Oracle VM Virtual Box – Download

In the article you will have a look at how to use some Oracle Virtual Box features to build two node Oracle 12c (12.1.0.1) RAC system on Oracle Enterprise Linux (OEL 6.5). The setup will implement a role separation with different users for Oracle RDBMS and Oracle GI that is, user oracle and grid are used respectively in order to split the responsibilities between DBAs and storage administrators.

An overview to Oracle Virtualization solutions can be seen here. You can see how to use Oracle VM Virtual Box to build a two node 11gR2 RAC cluster on Solaris 10 and Solaris 11. For information related to building a RAC 11gR2 cluster on OEL 5.X/6.X without GNS click here and here. For information how to build a two node Oracle RAC 11gR2 11.2.0.3 with GNS (DNS, DHCP) and HAIP look here. For information how to upgrade Oracle RAC cluster 11.2.0.3 on OEL 6.1 to Oracle RAC cluster 12c on OEL6.5 look here.

In the article you will see how to configure Linux in an Oracle VM Virtual Box Virtual machines, install Oracle GI, Oracle RDBMS and will create a RAC enabled Multitenant Container Database (CDB).

The following software will be used:

  1. Oracle VM Virtual Box 4.3.12 – download from here.
  2. Oracle 12c (database, grid, examples) – download from OTN here.
  3. Oracle OEL 6.5 – download from Oracle Software Delivery Cloud (former Edelivery) here.

Two virtual machines will be created and used.

  1. OEL65A for RAC node oel65a
  2. OEL65B for RAC node oel65b

The OEL65A/OEL65B Virtual Machines will be configured for RAC nodes each with:

You can read online from here or download Build two node Oracle RAC 12c (12.1.0.1) on OEL 6

May 26, 2014 Posted by | oracle | Leave a comment

Build two node Oracle RAC 12c (12.1.0.1) cluster on OEL 6.5 using Oracle VM Virtual Box

Build two node Oracle RAC 12c (12.1.0.1) cluster on OEL 6.5 using Oracle VM Virtual Box

In the article you will have a look at how to use some Oracle Virtual Box features to build two node Oracle 12c (12.1.0.1) RAC system on Oracle Enterprise Linux (OEL 6.5). The setup will implement a role separation with different users for Oracle RDBMS and Oracle GI that is, user oracle and grid are used respectively in order to split the responsibilities between DBAs and storage administrators.

An overview to Oracle Virtualization solutions can be seen here. You can see how to use Oracle VM Virtual Box to build a two node 11gR2 RAC cluster on Solaris 10 and Solaris 11. For information related to building a RAC 11gR2 cluster on OEL 5.X/6.X without GNS click here and here. For information how to build a two node Oracle RAC 11gR2 11.2.0.3 with GNS (DNS, DHCP) and HAIP look here. For information how to upgrade Oracle RAC cluster 11.2.0.3 on OEL 6.1 to Oracle RAC cluster 12c on OEL6.5 look here.

In the article you will see how to configure Linux in an Oracle VM Virtual Box Virtual machines, install Oracle GI, Oracle RDBMS and will create a RAC enabled Multitenant Container Database (CDB).

The following software will be used:

  1. Oracle VM Virtual Box 4.3.12 – download from here.
  2. Oracle 12c (database, grid, examples) – download from OTN here.
  3. Oracle OEL 6.5 – download from Oracle Software Delivery Cloud (former Edelivery) here.

Two virtual machines will be created and used.

  1. OEL65A for RAC node oel65a
  2. OEL65B for RAC node oel65b

The OEL65A/OEL65B Virtual Machines will be configured for RAC nodes each with:
Continue reading

May 26, 2014 Posted by | oracle | 6 Comments

Upgrade Oracle RAC cluster 11.2.0.3 on OEL 6.1 to Oracle RAC cluster 12c on OEL6.5 – Download

Upgrade Oracle RAC cluster 11.2.0.3 on OEL 6.1 to Oracle RAC cluster 12c on OEL6.5 – Download

In the article you will have a look at the guidelines and steps to upgrade an Oracle RAC cluster 11.2.0.3 on OEL 6.1 to Oracle RAC cluster 12c on OEL 6.5. The initial cluster configuration (Oracle 11.2.0.3 on OEL 6.1) is described here. The upgrade comprises the following steps:

  1. Rolling upgrade of the Virtual Box machines (OEL61A and OEL61B) from OEL 6.1 to OEL 6.5 with UEKR3 (kernel 3.8.13-35.el6uek.x86_64)
  2. Upgrade from Oracle 11gR2 11.2.0.3 to Oracle 12c 12.1.0.1 for both GI/RDBMS software. The database upgrade involves a downtime during the upgrade.

The following software will be used:

  1. Oracle VM Virtual Box 4.3.12 – download from here.
  2. Oracle 12c (database, grid, examples) – download from OTN here.
  3. Oracle OEL 6.5 – download from Oracle Software Delivery Cloud (former Edelivery) here.

I upgraded the Oracle VM Virtual Box software, used in the setup here, to the latest version available at the time of writing the article. Thus, henceforth, I will not discuss the Oracle VM Virtual Box software upgrade in the article.

I will use the existing VMs (OEL61A and OEL61B) without any change from the original configuration for the upgrade to OEL65 and Oracle 12c. The only changes are to enable internet access for the duration of the OEL upgrade

Overall, I must admit, I was quite impressed by how easy and smooth the upgrade was compared to similar Oracle RAC upgrades from 9i->10g->11g where I had to spend longer time on MOS (former Metalink) working around upgrade issues.

Read online from here or download Upgrade Oracle RAC cluster 11.2.0.3 on OEL 6.1 to Oracle RAC cluster 12c on OEL6

May 25, 2014 Posted by | oracle | 3 Comments

Follow

Get every new post delivered to your Inbox.

Join 782 other followers