Guenadi N Jilevski's Oracle BLOG

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

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

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

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.

Continue reading

May 25, 2014 Posted by | oracle | 1 Comment

Oracle Certified Master 11g – OCM 11g

Oracle Certified Master 11g – OCM 11g

I recently sat for the Oracle Database 11g: Oracle Certified Master Upgrade (OCM). Today, I was pleasantly surprised receiving a notification that I have successfully completed the practicum.

As I signed an NDA with Oracle Corporation I will not be able to provide you with any comments or answers related to the OCM practicum, but I can assure you that the information provided by Oracle for the scope and instructions for preparation are sufficient for you to prepare and successfully complete the OCM practicum test.

Good luck with your Oracle certifications.

    

May 7, 2014 Posted by | oracle | 3 Comments

Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c

PACKT provide me an e-copy of ‘Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c‘ and asked me to write a review of the book. I enjoyed learning the new Cloud management and monitoring functionality offering of Oracle Enterprise Manager Cloud Control 12c ( OEM CC 12c) and how successfully integrates and manages existing technologies.

If you are either an Oracle DBA new to the cloud and interested in learning the new functionality of OEM CC 12c for Cloud management and administration or a Cloud administrator tasked with Cloud management and monitoring using OEM CC 12c or an user of a self service provisioning systems offered by OEM CC 12c than ‘Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c‘ is an ideal starting point that will provide you with guidelines and step-by step examples how to deploy, manage and monitor IaaS and DBaas using OEM CC 12c.

Chapter 1 provides an overview of OEM CC 12c setup and highlights some important points that will help the reader move into the next chapters.

Chapter 2 reviews the IaaS configuration options and components existing in OEM CC 12c such as Oracle VM Manager setup and registration, Networking, Configuring storage servers, Creating and configuring virtual server pools, Monitoring and administering IaaS, Setting up the IaaS self-service portal to name a few.

Chapter 3 provides an overview of PaaS, Saas and DBaas and focuses on OEM CC 12c functionalities for self-service provisioning of virtualized databases and building DBaaS cloud computing architecture. The chapter provides an insight into the following topics: Setting up the PaaS infrastructure, Provisioning the database, Managing storage servers, Creating database pools, Setting up quotas and provisioning profiles, Setting up service templates and chargebacks using OEM CC 12c as integration, management and monitoring platform.

Chapter 4 provides an overview of the wealth of robust and automated enterprise monitoring functionalities existing in OEM CC 12c focusing on the following topics: Monitoring concepts, Basic setup, Notifications, Incident management – events, incidents, and problems to name a few.

Chapter 5 provides an overview to the Cloud APIs as a way to establish a fine-grained control over the Cloud infrastructure with a focus on Using Enterprise Manager Cloud APIs and CLIs, Enterprise Manager IaaS APIs, Enterprise Manager DBaaS APIs, Chargeback EMCLIs.

 

 

 

 

 

February 10, 2014 Posted by | oracle | Leave a comment

Installing VMware Workstation 9.0.1 on Windows and creating OEL 6.3 x86_64 guest VM – Download

Installing VMware Workstation 9.0.1 on Windows and creating OEL 6.3 x86_64 guest VM – Download

In the article you will have a look at the steps to install VMware Workstation 9.0.1 on MS Windows and create an OEL 6.3 x86_64 guest VM. The following software will e used:

  • Oracle Enterprise Linux 6.3 x86_64 : download from edelivery.oracle.com
  • VMware® Workstation 9.0.1: Download trial from VMware.

The article will cover:

  1. VMware® Workstation 9.0.1 installation
  2. Creating OEL 6.3 VM

In the article I will install the latest version of VMware workstation for windows and will create a guest VM running OEL 6.3 x86_64.

Read online from here or download Installing VMware Workstation 9.0.1 on Windows and creating OEL 6.3 guest VM

December 18, 2012 Posted by | oracle | Leave a comment

Installing VMware Workstation 9.0.1 on Windows and creating OEL 6.3 x86_64 guest VM

Installing VMware Workstation 9.0.1 on Windows and creating OEL 6.3 x86_64 guest VM

In the article you will have a look at the steps to install VMware Workstation 9.0.1 on MS Windows and create an OEL 6.3 x86_64 guest VM. The following software will e used:

  • Oracle Enterprise Linux 6.3 x86_64 : download from edelivery.oracle.com
  • VMware® Workstation 9.0.1: Download trial from VMware.

The article will cover:

  1. VMware® Workstation 9.0.1 installation
  2. Creating OEL 6.3 VM

In the article I will install the latest version of VMware workstation for windows and will create a guest VM running OEL 6.3 x86_64.
Continue reading

December 18, 2012 Posted by | oracle | 1 Comment

Using Oracle GoldenGate 11gR2 reverse utility to undo changes from OGG replication – Download

Using Oracle GoldenGate 11gR2 reverse utility to undo changes from OGG replication – Download

In the article you will have a look at an example of using the Oracle GoldenGate (OGG) 11gR2 reverse utility to back out changes replicated from the source database to the target database. In certain cases you need to back out the changes on the target database. For example:

  • undo replication changes committed on the target database
  • rollback an erroneous or accidently issued transaction replicated to the target
  • restore the target data to a state before the replication

Although you can use flashback features, in case of a target Oracle database, or simple backup and restore, OGG 11gR2 provides a generic reverse utility that helps you performing the back out. For you to implement a change back out you need to perform the following steps:

  1. Determine the start and end time for the transactions to be backed out
  2. Configure and start online extract to capture the changes from the source database for this period including the before images and use a trail format that does not compress deletes.
  3. Use the reverse utility to process the trail
  4. Configure and start replicat to apply the change records from the reversed trails and undo the changes that were already applied.

Read online from here or download Using OGG 11gr2 reverse utility to undo changes from OGG replication

November 24, 2012 Posted by | oracle | Leave a comment

Using Oracle GoldenGate 11gR2 reverse utility to undo changes from OGG replication

Using Oracle GoldenGate 11gR2 reverse utility to undo changes from OGG replication

In the article you will have a look at an example of using the Oracle GoldenGate (OGG) 11gR2 reverse utility to back out changes replicated from the source database to the target database. In certain cases you need to back out the changes on the target database. For example:

  • undo replication changes committed on the target database
  • rollback an erroneous or accidently issued transaction replicated to the target
  • restore the target data to a state before the replication

Although you can use flashback features, in case of a target Oracle database, or simple backup and restore, OGG 11gR2 provides a generic reverse utility that helps you performing the back out. For you to implement a change back out you need to perform the following steps:

  1. Determine the start and end time for the transactions to be backed out
  2. Configure and start online extract to capture the changes from the source database for this period including the before images and use a trail format that does not compress deletes.
  3. Use the reverse utility to process the trail
  4. Configure and start replicat to apply the change records from the reversed trails and undo the changes that were already applied.
    Continue reading

November 24, 2012 Posted by | oracle | 1 Comment

Deploy Oracle GoldenGate Veridata Version 3.0 for comparison between Oracle RDBMS databases replicated using OGG 11gR2 – Download

Deploy Oracle GoldenGate Veridata Version 3.0 for comparison between Oracle RDBMS databases replicated using OGG 11gR2 – Download

In the article you will have a look at the steps to install, configure and deploy OGG Veridata 3.0 for data comparison between two Oracle 11gR2 databases configured with OGG 11gR2 for data replication. The OGG 11gR2 setup that will be used for replication and subsequent verification with Veridata comparison is described here. The article will briefly cover the following topics

  • Brief overview of OGG Veridata concepts and architecture
  • OGG Veridata Server and OGG Veridata Web installation and management
  • OGG Veridata Agent for Oracle installation
  • Example of using OGG Veridata for comparison between running Oracle databases in active-active OGG 11gR2 configuration
  • Using OGG vericom

Read online from here or download Deploy Oracle GoldenGate Veridata Version 3

November 18, 2012 Posted by | oracle | Leave a comment

Deploy Oracle GoldenGate Veridata Version 3.0 for comparison between Oracle RDBMS databases replicated using OGG 11gR2

Deploy Oracle GoldenGate Veridata Version 3.0 for comparison between Oracle RDBMS databases replicated using OGG 11gR2

In the article you will have a look at the steps to install, configure and deploy OGG Veridata 3.0 for data comparison between two Oracle 11gR2 databases configured with OGG 11gR2 for data replication. The OGG 11gR2 setup that will be used for replication and subsequent verification with Veridata comparison is described here. The article will briefly cover the following topics

  • Brief overview of OGG Veridata concepts and architecture
  • OGG Veridata Server and OGG Veridata Web installation and management
  • OGG Veridata Agent for Oracle installation
  • Example of using OGG Veridata for comparison between running Oracle databases in active-active OGG 11gR2 configuration
  • Using OGG vericom
    Continue reading

November 18, 2012 Posted by | oracle | 3 Comments

Oracle GoldenGate Director 11gR2 (Server, Administrator, Client and Web) 11.2.1 installation and deployment – Download

Oracle GoldenGate Director 11gR2 (Server, Administrator, Client and Web) 11.2.1 installation and deployment – Download

In the article you will look at the steps for deploying Oracle Goldengate (OGG) Director on OEL 5.X using Oracle RDBMS as a repository. OGG Director consists of the following components:

  • OGG Director Server
  • OGG Director Admin
  • OGG Director Client
  • OGG Director Web

All of the above components will be installed and configured for you to monitor and manage the OGG environment.

The following software will be used.

  • OGG Director 11gR2 11.2.1.0 Server – download from here. OGG Director Client comes with the OGG Director Server and can be downloaded from the OGG Server or installed separately.
  • Oracle WebLogic Server (OWLS) 12c 12.1.1 – download from here
  • JDK 1.6.0_20 or later – download from here

Read online from here or download Oracle GoldenGate Director 11.2.1 installation and deployment

November 14, 2012 Posted by | oracle | Leave a comment