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 (more...)

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 (more...)

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 (more...)

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 (more...)

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 (more...)

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 (more...)

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 (more...)

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 (more...)

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 (more...)

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