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:
- VMware® Workstation 9.0.1 installation
- 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
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:
- VMware® Workstation 9.0.1 installation
- 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
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
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
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
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
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
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
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
Using Oracle GoldenGate (OGG) 11gR2 for Conflict Detection and Resolution (CDR) based on balance and timestamp in a bidirectional active-active configuration
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