
ALL DBA
22 FOLLOWERS
The blog for Oracle Database Administration Including Data Guard, RAC, Exadata & GoldenGate.
ALL DBA
5M ago
Migration Utility: (download the Migration Utility from MOS) Prerequisites for the Migration Utility: Before running the migration utility, ensure the following: Migration Utility Restrictions: The migration utility cannot handle processes with the following limitations ..read more
ALL DBA
5M ago
In this article, we’ll explore the log file paths for the key components of Oracle GoldenGate Microservices Architecture (OGG MA), helping administrators quickly locate and analyze logs for efficient issue resolution. Parameter Files Location: Report File Location: Admin Client Log: Service Manager Log: All Services Log: (Administration / Distribution / Receiver / Performance Metrics ..read more
ALL DBA
5M ago
To use the command line interface with Oracle GoldenGate Microservices Architecture (OGG MA), you need to utilize the AdminClient utility. Unlike the traditional Classic Architecture, where you use ggsci for most administrative tasks, OGG MA provides the AdminClient command-line interface for interacting with OGG processes. Set the OGG Environment Variable: Below Commands are for Administration ..read more
ALL DBA
5M ago
Oracle GoldenGate Microservices Architecture (MA): Oracle GoldenGate Microservices Architecture (MA) is a modern, web-based framework designed to manage data replication in a more flexible, scalable, and cloud-friendly way compared to the traditional Oracle GoldenGate Classic Architecture. Introduced in Oracle GoldenGate 12c, the Microservices Architecture offers an improved user experience through RESTful APIs and web-based user ..read more
ALL DBA
1y ago
Extract and Replicat processes take care the data from the point of setup of the processes. To setup a replication using Goldengate, We need to make sure that existing data are properly copied from Source to Target and this is called Initial Load.
There are different types of Initial Load available in Oracle GoldenGate as well as a few possible methods outside the GoldenGate for performing data synchronization between Source and Target databases.
Initial Load:
Using RMAN
Oracle Export and Import (Data PUMP)
Oracle Transportable Tablespace
ETL Tools
SQL Loader – Useful for heterogeneous enviro ..read more
ALL DBA
1y ago
In this article, I will show how to enable DDL replication for a table or schema which is the part of goldengate replication.
To enable the DDL, first need to execute below mentioned scripts on source database.
1. Scripts Execute.
marker_setup
ddl_setup
role_setup.sql
ddl_enable.sql
2. Update Extract and PUMP parameter to include DDL (DDL INCLUDE ALL)
3. Validation
4. Enable DDL at Table Level
Execute marker_setup script:
SQL> @marker_setup.sql
Marker setup script
You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: The schema must ..read more
ALL DBA
1y ago
CREDENTIALSTORE: Creates a credentials store (wallet) that stores encrypted database user credentials. The CREDENTIALSTORE is a new feature in Oracle GoldenGate 12c and the default location of the credential store is “$GG_HOME/dircrd”.
Existing Setup:
GGSCI (orclprd.localdomain) 2> INFO CREDENTIALSTORE
Reading from credential store:
ERROR: Unable to open credential store.
GGSCI (orclprd.localdomain) 3> ADD CREDENTIALSTORE
Credential store created.
GGSCI (orclprd.localdomain) 4> INFO CREDENTIALSTORE
Reading from credential store:
No information found in credential store.
Step ..read more
ALL DBA
1y ago
To configure Oracle GoldenGate replication, we need to create below processes. In this article, I will use Oracle Database as source and target.
High level steps:
Install Oracle GoldenGate on source and target databases.
Setup prerequisites.
Setup connectivity.
Create an user Credential.
Configure Manager process on source and target databases.
Initial Load.
Configure Extract process on source database.
Configure Pump process on source database.
Configure Replicat process on target database.
Source DB Details:
Host Name: orcl19c.localdomain
IP: 192.168.56.10
Database Name: orclprd
Database ..read more
ALL DBA
1y ago
Oracle GoldenGate is a comprehensive software solution provided by Oracle for real-time data integration and replication in heterogeneous IT environments. It enables the exchange and manipulation of data at the transaction level among multiple, diverse platforms across the enterprise
Use of GoldenGate:
Data Replication:
GoldenGate is often used to replicate data between different databases in real-time. This is valuable for maintaining consistent and up-to-date information across multiple systems.
Data Migration:
During system upgrades or migrations, GoldenGate can be employed to ensure a ..read more
ALL DBA
1y ago
In this article, I will show how to create a filesystem and mount it on Linux.
Existing filesystem:
[root@orclprd Packages]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_orclprd-lv_root
13G 4.7G 7.4G 39% /
tmpfs 2.8G 76K 2.8G 1% /dev/shm
/dev/sda1 477M 67M 381M 15% /boot
/dev/sr0 3.6G 3.6G 0 100% /media/OL6.6 x86_64 Disc 1 20141018
[root@orclprd ~]# cd /dev
[root@orclprd dev]# ls sd*
sda sda1 sda2 sdb
Create a logical partition:
[root@orclprd dev]# fdisk sdb
Device contains n ..read more