-
Copy Audit and unified audit across databases
The client had a special request: copy the audit data to another database – once -, for compliance reasons. The Audit data does not let it copy so easily. Before was usually in SYS schema, now it belongs to a special AUDSYS user. None allows to export data by default. To copy the audit data…
-
OEM 13.5 – Failed to allocate OCIEnv from Perl corrective actions
At a client, since Enterprise Manager 13.5 Release 1 Update 30 (RU 30) – the April June 2026 update -, that Corrective Action to extend tablespaces stopped to work. They got two production application completely frozen due to this! The symptoms were that the Perl script triggered by OEM Agent could not anymore connect to…
-
Make Oracle tablespace management easier – make sure to have autoextend on and maxsize unlimited
On several customers where databases exists since many years, it is common to find datafile and tablespace management to be inconsistent, mainly due to historical reasons and the DBA preferences at the time. It is common to see a mix of these patterns in a typical 8192 block size database using smallsize tablespaces: I try…
-
On DB 19.31, ORA-600 [kaf lob buffer overwrite]
After Oracle support did not accepted that there is bug with huge LOB segments and High IO due space manager KTSJ, this time it worked faster. The move of the Table and LOB to a new Tablespace went ok, but soon we started seeing ORA-600 [kaf lob buffer overwrite] on the alertlog. These happened either…
-
High IO due space manager (W00x process) doing db sequential read all the time – KTSJ Slave bug?
On a client DB, after migrating it to OL8, the application started to complaint the DB seems slower. Checking the OEM, there is not much done by the application, but I see a good blue stripe from W00x processes doing sequential reads. Nonstop. This is a 19.31 single-instance database. After tracing these sessions, they are…
-
Database specific password wallet with 26ai client: the new SEPS_WALLET_LOCATION parameter
One inconvenient I had in the past with the usage of password wallets for Oracle users was their maintenance. With the years, there was just a lot of old entries. At the end you would do a script that would test all credentials and delete the ones which did not work or there was no…
