Wednesday, November 3, 2021

Oracle Exadata x8m and the PMEMCache and PMEMLog

›
Oracle Exadata x8m provides Optane persistent memory (PMEM) and in 2 ways PMEMCache and PMEMLog which is configured automatically with insta...
Wednesday, January 6, 2021

View Transactions from MySQL Binlogs to Resolve Replication Issues

›
Summary Sometimes Replication abends need investigation and the first step is to determine the transaction that is failing.  So we can deter...
Tuesday, January 5, 2021

Group Replication will not rejoin group due to connection issue

›
  Summary Group replication left as a member of the group and will not rejoin. Track down reason why it will not rejoin group, example h...
Monday, June 22, 2020

Restore Single Table from MySQL Dump

›
Summary There are times when you need to restore a table and what you have is a MySQL dump of the entire database.   We want to be able ...
Tuesday, May 5, 2020

Change Oracle Group UUID for ORACLE_HOME

›
** NOTE: This procedure while has been tested on on an Oracle Linux server and has shown to allow the change of the UUID for the HOME This ...

Update to New 18c Patch Level using New ORACLE_HOME

›
** Procedure Assumes new ORACLE_HOME at updated patch level. 1. shutdown any golden gate processes when Golden Gate in Use. 2. for each...

Rollback 18 Patch back to Prior Patch Level with Change ORACLE_HOME

›
** Procedure assumes ORACLE_HOME rolling back to is already in place at patch level you want to rollback. 1. Stop any golden gate processe...