Featured
The Latest
-
GoldenGate Add Extract – (Part 3 Rest API Series)
Let’s add and start an Extract with REST API, note that I am not starting at creation: — Add Extractcurl… READ MORE
-
SGA free and usage
SQL> compute sum of bytes on pool SQL> break on pool skip 1 SQL> SELECT pool, name, bytes from v$sgastat… READ MORE
-
GoldenGate Add Schematrandata (Part 2- Rest API Series)
The WEB UI is quite easy to manually add schematrandata to your replication, but if you want to automate the… READ MORE
-
GoldenGate Add Credentialstore with REST API (Part 1- REST API Series)
In this next series of REST API for GoldenGate Microservices, I will demonstrate how we can perform most general activities,… READ MORE
-
|
GoldenGate OCI Enterprise Solutions
I came across this picture today in one of the GoldenGate presentations and It’s really amazing how far the GoldenGate… READ MORE
-
Stop/Start GoldenGate Microservices DistPath with REST API
Here is an example how to stop and start the Distribution Services in GoldenGate Microservices using a REST API. READ MORE
-
SQL Developer fixed for MacOS Big Sur 11.4
Oracle released the new version of SQL Developer (21.2.0.187) today and I am glad to see that the issue with… READ MORE
-
Oracle Release Roadmap
Release Patching End Date Notes and Exceptions 21cInnovation Release June 30, 2023 Error Correction / Patching is… READ MORE
-
Postgres – how to find JDBC driver version
$ java -cp postgresql-9.4.1208.jar org.postgresql.util.PSQLDriverVersion PostgreSQL 9.4.1208Found in: jar:file:/tmp/postgresql-9.4.1208.jar!/org/postgresql/Driver.class READ MORE
-
OGG-01264 cm_mbuf_hdrs_copyout()
Extract ABENDED with the following error in many different tables. 2021-02-24T11:20:07.771-0500 ERROR OGG-01264 Oracle GoldenGate Capture for Oracle, EMMD.prm: The… READ MORE
-
|
Oracle Database 19c EE on Docker
On April 25, 2019 Oracle Released Database version 19c for Linux and I took the time to build a Docker… READ MORE
-
|
ORA-12754: Feature PDB SNAPSHOT CAROUSEL is disabled due to missing capability
When trying to create PDB snapshots in 18c I ran into the ORA-12754 and below is how I resolved by… READ MORE
-
Generic GGSCI Command for GoldenGate
INFO INFO MANAGER Provides details of the Manager process INFO MGR Also provides details of the Manager process STATUS MANAGER… READ MORE
-
Database Release and Support Timelines 12c, 18c, 19c….
This is going to get very interesting.. READ MORE
-
DBMS_GOLDENGATE_ADM Package
Quickly enable active/active replication while ensuring consistent conflict-detection-resolution (CDR) without modifying application or database structure. With auto CDR we can… READ MORE
-
Read Only Partitions 12.2
In 12.2 a partition or sub-partition can be marked as READ ONLY at the time of creation (CREATE TABLE) or… READ MORE
-
12.2 Data Guard Password Sync
My 12.2 New Features Series 12.2 Automatic Password Propagation to Standby: Changing SYS password Versions 12.1 and earlier Change… READ MORE
-
|
18c Installed on Premises
On July 23rd, 2k18 Oracle released 18c database to install on premises and I’ve installed and created a VirtualBox appliance… READ MORE
-
What’s up with the new Oracle releases names
Just thought to touch basis on some information i’ve been reading about the new release of Oracle Database releases starting… READ MORE
-
Docker Installation of Oracle Database 12c on Mac
I have been working with Virtual machines for quite a while, most of my testing and demo environments are on… READ MORE
-
GoldenGate – RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process.
1- One of the obsolete integrated extract was causing Rman not to delete expired archive logs. orcl:/u02/DBA/scripts ->./delete_arch.sh The Oracle… READ MORE
-
Run SQLcl commands from SQL Developer
SQLcl has many new little tricks that can help us on a daily basis, below is an example how we… READ MORE
-
12c DISPLAY_NAME column in v$event_name view
in 12c Oracle has introduced and new field in the v$event_name view called DISPLAY_NAME. After review the contents on more… 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
- Leadership
- Linux
- Listener
- LOB
- Lock
- Log Miner
- mac
- Microservices
- Monitor
- Motocycling
- MySQL
- NetApp for Oracle
- networking
- OCI
- OEM – Grid Control
- 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 