A developer has recently shown me an interesting wrong results issue in one of our 12.1.0.2 databases. Having investigated it, I identified the root cause of that issue and constructed a simple test case that can be used to reproduce it.
Got an Oracle error ORA-38301: "can not perform DDL/DML over objects in Recycle Bin" in the alert log.
Having installed Oracle Database 12.2 on a client, I have noticed that the login.sql script, which is placed in a custom directory specified by SQLPATH, is not invoked anymore.
Got a call asking me to provide advice on the cause of ORA-3180 error on an Active Data Guard standby database instance
DBMS_METADATA.GET_SXML_DDL may produce incorrect DDL for trigger in EBR environmentI have recently discovered a case when DBMS_METADATA.GET_SXML_DDL returns incorrect DDL for a trigger in an EBR environment.
log.* files in dirbdb directoryAfter adding ENABLEMONITORING in the GLOBALS file, I noticed that the $OGG_HOME/dirbdb directory started growing.
DBMS_STREAMS_ADM.SET_TAGA couple of months ago I had to configure an Oracle GoldenGate Integrated Extract to exclude specific DDL statements from replication.
Having worked a lot with Oracle Streams, I decided to utilize DBMS_STREAMS_ADM.SET_TAG for that task.
Today I faced an interesting issue performing a GoldenGate initial load with a Direct Bulk Load to SQL*Loader. The issue was related to the incorrect handling of unused columns during such loads and can cause incorrect data getting loaded into a database under certain conditions.
This morning while applying the most recent Database Bundle Patch (DBBP) the datapatch invocation finished with an error.
I think Asynchronous Global Index Maintenance is one of the most exciting features in Oracle Database 12c. This post is about one particular case when that feature can cause performance issues.