Installing Oracle GoldenGate for Oracle 12c


Oracle GoldenGate features can be demonstrated using a single computer and a single database instance. In this case, Oracle GoldenGate replication occurs between two different database schemas running on the same database instance. To make this arrangement possible, the Oracle GoldenGate software must be installed twice on the same computer/VM, in different directories, one dedicated to the Oracle GoldenGate instance simulating the replication source and one dedicated to the Oracle GoldenGate instance simulating the replication target. The replication source instance manager will use the TCP/IP network port 7809, while the  replication target instance manager will use the TCP/IP network port 7909.
In summary, the environment is:
Host NameOSUserMgr Port SourceInstall Directory
host01Linux 64-bitoracle7809/u01/app/oracle/product/ogg_src
host01Linux 64-bitoracle7909/u01/app/oracle/product/ogg_trg
When two hosts are configured, the /u01/app/oracle/product directory on host01 will contain the directories 12.1.0 and ogg_src. The /u01/app/oracle/product directory on host02 will contain the directories 12.1.0 and ogg_trg.
Software
    • Oracle Database 12c on Oracle, Linux-64, version 12.1.0.2.
    • Oracle GoldenGate on Oracle, Linux-64 ( Oracle Software Delivery Cloud ), version 12.1.2.0.0, part number V40146-01. This is the part number for 64-bit Linux.

Expanding the Oracle GoldenGate software

The Oracle GoldenGate software bundle is delivered as a zip file (V40146-01.zip ) You must expand the zip file using the unzip command before you can install the software.
Open a terminal window. Use the oracle user (the default user) to change directory to the /stage directory. Unzip the Oracle GoldenGate software bundle:

Installing the Oracle GoldenGate software for the source

Same steps need to be done for installing goldengate on destination side.
In the next article we install oracle goldengate with silent method.

Comentarios

Publicar un comentario

Entradas populares de este blog

Migrate non-ASM to ASM in 12c

There are many approaches can convert file system to ASM, such as RMAn copy database image, as of 12c, you can move datafiles online, that feature enables you minimize the downtime. 1. Abstract My CDB named ora12c contain one PDB named pdb1 with local file system datafiles. I have my GI standalone installed with diffenert owner GRID contains two asm disk groups, I need to migrate the whole CDB to ASM. Below is the current environment before migration. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 #GI already installed with 2 disk groups [grid@linora:/home/grid]$ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -----------------------------------------------------------------------------...
Leer más

How To Move AUD$ Table To Another Tablespace Using DBMS_AUDIT_MGMT

Auditing is always about accountability, and is frequently done to protect and preserve privacy for the information stored in databases. Concern about privacy policies and practices has been rising steadily with the ubiquitous use of databases in businesses and on the Internet. Oracle Database provides a depth of auditing that readily enables system administrators to implement enhanced protections, early detection of suspicious activities, and finely-tuned security responses. If your  AUD$  table is in  SYSTEM  and  SYSTEM  tablespace, Then it is advised to move the  AUD$ to a dedicated tablespace. Use steps to move AUD$. 1 2 3 4 5 select owner , segment_name , segment_type , tablespace_name , bytes / 1024 / 1024 from dba_segments where segment_name = 'AUD$'   OWNER   SEGMENT_NAME     SEGMENT_TYPE   TABLESPACE_NAME   BYTES / 1024 / 1024 -- -- -- - -- -- -- -- -- --...
Leer más