Create Materialized View is Failing in Oracle 19.13
ORA-00904: invalid identifier when creating materialized view in 19.13 and 19.14. The problem is fixed in 21c. Continue Reading
Author: Nenad Noveljic
Compilation Error in 19.14 datapatch
datapatch is failing when migrating from Solaris to Linux Continue Reading
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
Converting Offsets in Disassembled Code to Hexadecimal Notation
Perl one-liner for converting offsets in gdb output to hex 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