Featured
The Latest
-
Why a Little Selfishness Is Good for You
When we hear the word “selfish,” it often carries a negative connotation as if caring for yourself automatically means neglecting… READ MORE
-
Clone GoldenGate User
I put together a handy script that reproduces the Data Definition Language (DDL) for an existing GoldenGate user. This friendly… READ MORE
-
Why You Should Build the LogMiner Dictionary Periodically for Oracle GoldenGate
When using Oracle GoldenGate in Integrated Extract mode, one of the most overlooked but essential steps is ensuring that the… READ MORE
-
Query V$DIAG_ALERT_EXT from Oracle Using SQL Panel in Grafana
I was testing the process of retrieving the Alert Log and other diagnostic features from the Oracle Database and GoldenGate… READ MORE
-
Why do we need Checkpoint table?
Configuring a checkpoint table for the Replicat process is highly recommended whenever possible. While support for checkpoint tables varies across Oracle GoldenGate (OGG) and database… READ MORE
-
Script to ADD Schematrandata to 1000s of Schemas
Occasionally, we meet customers with thousands of schemas, a challenge that can seem overwhelming to add schematrandata, for example. However,… READ MORE
-
What is “Authorization: Basic” in the cURL API calls
The -H ‘Authorization: Basic …’ flag in a curl command sets the HTTP Authorization header using Basic Authentication. Basic authentication… READ MORE
-
Is an IT Certification Worth It? Pros and Cons You Should Know
In today’s fast-moving tech landscape, professionals constantly ask: “Do I need a certification to succeed in IT?” Whether you’re a… READ MORE
-
The “cup half full” vs. “cup half empty” – optimistic or pessimistic
Considering yourself realistic instead of optimistic or pessimistic is not bad; in fact, it’s often a strength. The “cup half… READ MORE
-
Veridata REST API
Did you know that with Veridata 23ai, you can now manage your compares through the APIs? Check out the documentation:… READ MORE
-
GoldenGate 23.8 Released
I’m excited to share that GoldenGate version 23.8 has officially been released and is now available for download through the… READ MORE
-
Oracle GoldenGate Core Product Patch Sets
This document is a comprehensive reference for the available patch sets related to the Oracle GoldenGate (OGG) core product. It… READ MORE
-
Patch 37752710: Oracle GoldenGate 23.7.2.25.03 for Oracle (Complete Install)
Patch 37752710: Oracle GoldenGate 23.7.2.25.03 for Oracle (Complete Install) Patch 37752708: Oracle GoldenGate 23.7.2.25.03 for Oracle READ MORE
-
Optimizing Oracle GoldenGate for Active-Active DDL Replication
Oracle GoldenGate effectively supports active-active DDL replication between two systems. To achieve bidirectional replication in an active-active setup, it is… READ MORE
-
|
Microsoft AI Tour in Houston-TX
If you are local in Texas, join us for a free in-person event at the #MicrosoftAITour in Houston on March… READ MORE
-
Patch 37614889: Oracle GoldenGate 23.7.1.25.02 for Oracle (Complete Install)
Oracle GoldenGate 23.7.1.25.02 patch set is available to download. Patch 37614889 (For Oracle Database) includes important updates for GoldenGate. Applying… READ MORE
-
dbms_goldengate_auth.grant_admin_privilege ‘CONTAINER’ must be declared in 19.19
In Oracle DB Version 19.19.0.0.0, “Current” PDB throws an error when running the package dbms_goldengate_auth.grant_admin_privilege : Solution: Specify the PDB… READ MORE
-
Understanding SID_NAME in a PDB Setup
In an Oracle Multitenant configuration, the SID_NAME in a Pluggable Database (PDB) setup differs from traditional standalone databases. Here’s how… READ MORE
-
What is OpenTelemetry?
OpenTelemetry (OTel) is an open-source observability framework that enables monitoring and management of cloud-native applications. It provides tools for tracing,… READ MORE
-
Configuring Oracle GoldenGate with TLS to Securely Connect to the Oracle Database
Transport Layer Security (TLS) helps keep your connections secure between an Oracle Database client and server by encrypting data. You… READ MORE
-
GoldenGate @STRRTRIM function example
Here’s a complex example of using the STRRTRIM function in Oracle GoldenGate. This example demonstrates removing multiple different trailing characters,… READ MORE
-
Cultivate a Growing Mindset
Developing a growth mindset is essential for personal and professional development. It’s about believing in your ability to learn and… READ MORE
-
Cultive uma Mentalidade de Crescimento
Desenvolver uma mentalidade de crescimento é essencial para o desenvolvimento pessoal e profissional. Trata-se de acreditar na sua capacidade de… READ MORE
-
Deprecated and Desupported Features in GoldenGate 23ai
As Oracle GoldenGate is constantly improving, and with the exciting release of version 23ai, some features are being phased out… READ MORE
-
Oracle GoldenGate: Ensuring Data Safety in Transit and At Rest
In today’s world, where data security is a top priority, protecting information as it moves between databases and applications is… READ MORE
Recent posts
Quote of the week
“Control what I can control”
~ Alex Lima
Categories
- 18c
- 19c
- AIX
- Archivelog
- Auditing
- AWR
- Backup
- Backup & Recovery
- Batch
- Big Data
- Built-in stored procedures
- Connections
- Control file
- Cursor
- Database
- Dataguard
- Dataguard
- Datatypes
- Date
- Docker
- events
- exp
- Export
- Flashback
- General DBA
- Globalization
- GoldenGate
- Grant
- Initialization
- install
- Internal
- JDBC
- Jobs
- kubernetes
- Leadership
- Linux
- Listener
- LOB
- Lock
- Log Miner
- mac
- Microservices
- Monitor
- Motocycling
- MySQL
- NetApp for Oracle
- networking
- OCI
- OEM – Grid Control
- Open Shift
- OpenWorld 2010
- ORA Errors
- Oracle RAC
- oradebug
- OS
- osql
- Parameters
- partition
- Password
- performance
- PL/SQL
- postgres
- Power Shell
- Primavera
- Product Management
- Profiler
- Project Management
- Python
- REST API
- RMAN
- role
- Scheduler
- Scripts
- Security
- sga
- Shared Pool
- Shell
- snapshot
- SQL – DDL
- SQL Developer
- SQL Server
- SQL*Plus
- SQLcl
- startup
- Statistics
- Statspack
- Table
- tablespace
- trace
- Transaction
- Tuning
- Tuning
- Undo
- Unix
- Upgrade
- vi
- windows
Alex Lima 