Workaround for ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion
ORA-22835 was encountered following a database upgrade.
This post explains why it happened and provides an undocumented workaround.
Oracle¶
ASM disk group fails to mount with ORA-15017 ORA-15066 errors offlining disk "RACQ$LUN3" in group "DATA" may result in a data loss
Encountered an ORA-15066 preventing an ASM disk group mount.
This post shows how the issue was analyzed and a workaround found.
Making DBMS_SCHEDULER.CREATE_JOB Transactional
Let us investigate how to make DBMS_SCHEDULER.CREATE_JOB support transactions.
How to Send Messages to AWS SQS from PL/SQL Using UTL_HTTP
This blog post provides a complete example showing how to send messages to an AWS SQS queue.
Patching with OPatch Failed with Undefined Reference to __libc_csu_fini __libc_csu_init due to Wrong Libc Library
Patching an Oracle Home failed on one cluster node with the error undefined reference to __libc_csu_fini.
Direct Path Read Write Temp while Selecting CLOB from GV$ in RAC
I was intestigating why a simple SELECT * FROM GV$SQL started working much slower in 19c compared to 11.2.0.4.
It turns out Oracle introduced some changes there in 18c.
This blog post is written to demonstrate the new behavior.
Strict Redaction Semantics
A DBMS_REDACT issue has recently popped up on SQL.RU.
This post analyzes the issue and shows a possible workaround.
Oracle to PostgreSQL Replication: Numbers Truncated to 6 Decimal Places
I configured an initial load from Oracle to PostgreSQL, and found that some numbers were truncated after the load, e.g. Oracle number 123.0123456789 happened to be 123.012346 in PostgreSQL.
Let us find out how to avoid this.
Create Standby Skip Pluggable Database
This post demonstrates how to create a standby database excluding some pluggable databases of the primary database.
CHA Alert CHA_DBWR_CKPT_IO_COMPLETE in OEM
A customer was getting the CHA_DBWR_CKPT_IO_COMPLETE alerts from Oracle Enterprise Manager (OEM).
This post investigates the root cause.