Compilation Error in 19.14 datapatch
datapatch is failing when migrating from Solaris to Linux Continue Reading
Oracle
ORA-12269: client uses weak encryption/crypto-checksumming version when creating CDB catalog
Oracle internals analysis with pintools; workaround provided Continue Reading
Unexpected Optimizer Statistics Collection
Column usage in predicates can trigger statistics collection even when statistics aren’t stale. The problem got worse in 21c. Continue Reading
ORA-65092 when Updating to Oracle 19.13
Datapatch fails when converting a 19.12 (or lower) non-CDB to 19.13 PDB. Continue Reading
Troubleshooting ORDS-22001 After Migration to Oracle 21c
We run multiple database Apex instances configurations on a single Tomcat. After migrating from Apex 18c to 21c we couldn’t access Apex anymore. The error was misleading: https://server/ords21/DBNAME 404 Not Found 2021-10-29T17:12:42.556Z | HyrcATg4C7e87ph3eRaCig | ORDS-22001 The procedure named DBNAME… Continue Reading
Troubleshooting a Networking Issue from the Database Perspective
Identifying a networking issue with Oracle and OS tools Continue Reading
Apex/Data Redaction Conflict
Reports containing SQL expressions with redacted columns will break in versions 18c higher. Worth checking before Apex upgrade. Continue Reading
Warnings When Linking Oracle Software
Obsolete entries in oracle.map generate warnings that can be safely ignored. Continue Reading
Minimum sga_target
Database won’t start after a hardware/OS change or a database upgrade?
You can monitor critical conditions and prevent unpleasant surprises. Continue Reading
Flashback Data Archive DDL Bottleneck
Undocumented flashback data archive internals Continue Reading