Oracle Golden Gate method for initial load : 1.File to Replicat: Here, extract writes to trail file in canonical format and is replicated via SQL. 2.File to Database Utility: Here, extract writes to a formatted text file and is replicated via database utility. 3.Direct Load: Direct load replicat directly to the target server. 4.Direct Bulk […]
Category: GOLDENGATE
Commit Sequence Number in Golden Gate
Commit Sequence Number [CSN] We know that all database management system maintains some kind of unique auto incremental number of its own at the completion of each transaction like we have SCN number in Oracle database. With that number, we can uniquely identify that transaction. With reference to the above description, We can say that […]
Golden Gate Process Group
In previous article we have seen components or oracle golden gate . Oracle Golden Gate Components Today , we will see Process Groups in Oracle Golden Gate . We may have a different level of replication running in our environment like consolidating topology of oracle golden gate where we are having multiple replicate processor having […]
Editing Configuration Parameters
With my previous articles on Golden Gate, you must have got idea Golden Gate configuration is done with its parameter files for each process. Architecture of Extract Trails and Files Today we will see configuring parameters in more detail. Oracle Golden Gate uses two types of parameter files. Parameter files [run time]: Parameters which are […]
Using GGSCI [Golden Gate Software Command Interface ]
GGSCI stands for Golden Gate Software Command Interface. YES..! It is a command interface that executes Oracle golden gate commands. To work with GGSCI interface first go to your Golden Gate installation directory [oracle@localhost oracle]$cd /u02/ggate Now, open ggsci prompt using ./ggsci command : [oracle@localhost ggate]$ ./ggsci ./ggsci: error while loading shared libraries: libnnz12.so: cannot […]
Encryption in Oracle Golden Gate
We can use Oracle Golden Gate encryption at 3 levels. Message File Database Password Message The transmission over TCP/IP network is encrypted. Data is automatically decrypted by server process before saving the data to trail files at replicat server. AES128, AES192,AES256 is used for encryption and decryption. Step 1: Generate a key using keygen utility […]
./ggsci: error while loading shared libraries: libnnz12.so: cannot open shared object file: No such file or directory
[oracle@localhost ggate]$ ./ggsci./ggsci: error while loading shared libraries: libnnz12.so: cannot open shared object file: No such file or directory [oracle@localhost ggate]$ echo $ORACLE_HOME /u01/oracle/product/12.2.0/db_1 [oracle@localhost ggate]$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib [oracle@localhost ggate]$ ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 12.3.0.1.4 OGGCORE_12.3.0.1.0_PLATFORMS_180415.0359_FBO Linux, x64, 64bit (optimized), Oracle 12c on Apr 16 2018 00:53:30 Operating system character set […]
Oracle Golden Gate Microservice Architecture Installation
In Previous article we have seen detail of components of Oracle Golden Gate Microservice Architecture. Oracle Golden Gate Microservice Architecture Components In this article we will see installation of Oracle Golden Gate Microservice and create one deployment using oggca. You can download Oracle Golden Gate Microservices for oracle from https://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html After downloading upload setup on your […]
Oracle Golden Gate Microservice Architecture Components
Till date we have seen all articles on Golden Gate with classic architecture and worked on golden gate software command line interface[ggsci] prompt. With Oracle Golden Gate 12C release 2 [12.3] a new architecture came into picture that is Oracle Golden Gate Microservice Architecture. Image Source Let us see each component in detail : Service […]
Configuring Change Delivery
In previous articles, we have seen the configuration of change capture. Oracle Golden Gate architecture is mainly a collection of two main process Extract and Replicat. Extract process runs as source side from which you want to capture data and Replicat process runs at Destination side where you want run replication process. Each trail file […]