Страницы

▼
вторник, 30 ноября 2021 г.

Setting database session to read only in 21c

›
Oracle introduced a new parameter read_only in 21c which is not documented in Database Reference yet at the time of this writing. [oracl...
пятница, 12 ноября 2021 г.

ORA-7445 kpdbfSourceFileSearch with NFSv3 without noac option

›
Creating a pluggable database (PDB) by plugging an unplugged PDB in 19.12 can fail with the ORA-7445 kpdbfSourceFileSearch error. Somehow t...
суббота, 30 октября 2021 г.

Workaround for ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion

›
Oracle versions 9i and 10.1 have a bug in a LOB to CHAR conversion. When the value is larger than 4000 bytes, it is silently truncated witho...
среда, 22 сентября 2021 г.

Finding cause of kernel: blk_update_request: I/O error, dev fd0, sector 0

›
There was a Linux server that got periodic kernel: blk_update_request: I/O error, dev fd0, sector 0 errors in /var/log/messages : Sep 21 ...
вторник, 31 августа 2021 г.

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

›
It's a test 21c cluster that wasn't shutdown properly yesterday. While mounting a DATA disk group, the following errors are encounte...
среда, 30 июня 2021 г.

Making DBMS_SCHEDULER.CREATE_JOB Transactional

›
It is known that DBMS_SCHEDULER.CREATE_JOB is non-transactional as opposed to the old DBMS_JOB . There is even an Oracle idea to provide a ...
пятница, 23 апреля 2021 г.

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. AWS Prerequisites I created a queue called T...