Migrate Oracle GoldenGate Classic to MicroServices
ALL DBA
by dbasamad
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
Visit website
A Guide to OGG Microservices Architecture (OGG MA) Log File Paths
ALL DBA
by dbasamad
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
Visit website
Using AdminClient for Command Line Utility for OGG MA
ALL DBA
by dbasamad
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
Visit website
Step-by-Step Installation of Oracle GolgenGate (OGG) 21c Microservices
ALL DBA
by dbasamad
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
Visit website
Initial Load for GoldenGate Replication Setup
ALL DBA
by dbasamad
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
Visit website
Enable DDL Replication in GoldenGate
ALL DBA
by dbasamad
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
Visit website
Create a User ALIAS for GoldenGate Credential using CREDENTIALSTORE
ALL DBA
by dbasamad
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
Visit website
Configure GolgeGate Replication with19c
ALL DBA
by dbasamad
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
Visit website
Oracle GolgeGate
ALL DBA
by dbasamad
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
Visit website
Create a filesystem on Linux
ALL DBA
by dbasamad
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
Visit website

Follow ALL DBA on FeedSpot

Continue with Google
Continue with Apple
OR