Installation of Oracle GoldenGate v11.2.1.0.1 for Oracle 11g on Linux x86-64

This document details the installation and configuration of Oracle GoldenGate v11.2.1.0.1 for Oracle 11g on Linux x86-64. Configuration of the GoldenGate instance and other processes will be detailed in upcoming posts. These initial steps need to be done on both the source and target system.

This document assumes that the Oracle 11g Database software is installed on the source and target server and that source and target databases exist. It is further assumed that network connectivity between the target and source is in place.

Perl related issues when running ./rootcrs.pl to deconfigure the node

Today while deconfiguring one failed node from the clusterware I faced some Perl related issues that blocked me to run ./rootcrs.pl command. After installing few required packages I was able to deconfigure the node. Check the steps and let me know if it helped you and if you had different errors

[root@oratest02 install]$ ./rootcrs.pl -deconfig -force -verbose
-bash: ./rootcrs.pl: /usr/bin/perl: bad interpreter: No such file or directory

Download and install Oracle Database 18c – NOW!

Most of you already have seen that Oracle Database 18c has been already released. If you haven’t downloaded and installed it yet, let’s do it!

First of all, check the following address and download the installation of Oracle Database 18c:

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-linux-180000-5022980.html

If you want to download it from the host itself, you can use wget by providing username, password and the installation zip file as follows:

Oracle Active Database Duplication (using RMAN): ORA-00201: control file version incompatible Oracle 11.2.0.4

During active database duplication for standby database creation I faced below error, which is related to compatible on 11.2.0.4 on RHEL-6.5 x64.

Error :

ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE version 11.2.0.0.0

Diffrence Between Big Endian Vs Little Endian

Little Endian means that the low-order byte of the number is stored in memory at the lowest address, and the high-order byte at the highest address. (The little end comes first.) For example, a 4 byte Long Int

Byte3 Byte2 Byte1 Byte0

will be arranged in memory as follows:
Base Address+0 Byte0
Base Address+1 Byte1
Base Address+2 Byte2
Base Address+3 Byte3

Linux, Windows use "Little Endian" byte order.

ORACLE 12C RELEASE 2 (12.2.0.1.0) GRID INFRASTRUCTURE UPGRADE

I recently performed an upgrade of an Oracle 12c Release 1 (12.1.0.2) Grid Infrastructure environment hosted on a RAC Virtual Box environment on my laptop to the latest release 12c Release 2 12.2.0.1.0 version.
Here are some points to be noted related to the upgrade process:

• The Grid Infrastructure 12c Release 2 (12.2) software is now available as a single image file for direct download and installation. This greatly simplifies and enables a much quicker installation of the Grid Infrastructure software.

How to use STANDBYS Clause to Disable recovery for Specific PDBs

Starting with Oracle Database 12.1.0.2 we have a new clause called "STANDBYS" in the sentence "CREATE PLUGGABLE DATABASE". This new clause is useful to specify if a new PDB will be recovered in the Standby Databases. This way you can have a Primary Container Database that have some PDBs where redo is not applied in the Standby Container Database.

This doesn't mean that the PDB will not exist in the Standby Container Database. The PDB exists, but only the general structure of that PDB is created in the Standby CDB, All its datafiles are not created in Standby CDB. Its datafiles are marked as UNNAMED and that PDB will have Recovery disabled and of course that PDB will not receive redo to get recovered. The PDB also cannot be open but will not impact the others PDBs in the Standby Container.