Guenadi N Jilevski's Oracle BLOG

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

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

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

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

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
    Continue reading

November 14, 2012 Posted by | oracle | 1 Comment

Using Oracle GoldenGate (OGG) 11gR2 for Conflict Detection and Resolution (CDR) based on balance and timestamp in a bidirectional active-active configuration – Download

Using Oracle GoldenGate (OGG) 11gR2 for Conflict Detection and Resolution (CDR) based on balance and timestamp in a bidirectional active-active configuration – Download

In the article you will have a look at an example for CDR implementation based on a balance and timestamp column in a bidirectional active-active OGG setup. I will build an active-active bidirectional OGG replication between two sites (RACD, RACDB) each having identical tables (test5.account, test5.seat_assignment). I will emphasize on the requirements for CDR implementation and will outline CDR concepts and illustrate a step-by step CDR implementation, testing and troubleshooting. I will cover two cases

  • Use delta method for account balance CDR – An initial balance of 1000 will be simultaneously credited 200 on site B and debited 100 on site A. The result will be 1100 on both site A and site B.
  • Use USEMIN timestamp method for seat booking CDR – a seat ’2A’ will be booked 1st by John Smith on site A and at about the same time will be booked by Pier Cardin on site B. The result will be the first user on both site A and site B.

Starting with OGG 11gR2 there are build in options in the MAP replicat parameter, such as COMPARECOLS, RESOLVECONFLICT, and in the TABLE extract parameter, such as GETBEFORECOLS, allowing easy, automatic and OGG driven CDR compared to the methods involving SQL or PLSQL code invoked from SQLEXEC used for CDR in versions of OGG prior to 11gR2.

Read online from here or download Using Oracle GoldenGate (OGG) 11gR2 for Conflict Detection and Resolution (CDR) based on balance and timestamp in a bidirectional active-active configuration

November 8, 2012 Posted by | oracle | 2 Comments

Follow

Get every new post delivered to your Inbox.

Join 614 other followers