Troubleshoot: a non-regular solution for “ORA-01502 index is in unusable state”

How an error caused by running analyze to a table with unusable indexes is solved with regular expressions and dbms_stats.

How to add and drop disks efficiently in ASM?

Are you about to add, drop or replace disks in ASM? You may not be doing it in the most efficient way. Learn how.

Schrödinger’s Fast Recovery Area

What to do when Oracle reports an incorrect value for the space used in Fast Recovery Area.

DataGuard switchover with wallet: ORA-01017

Learn how to resolve and avoid the ORA-01017 error when you have Oracle Data Guard with wallet implemented.

Troubleshoot: enq: TX – row lock contention

Learn how to identify the row involved in the occurrence of the wait even “enq: TX – row lock contention”

Troubleshoot: CRS-2304 GPnP profile signature verification failed.

Learn how to resolve the CRS-2304 GPnP profile signature verification failed error when starting an 11.2 database on a 19c cluster.

Oracle Home permissions corrupted? Solve it in a jiffy!

Learn how to fix corrupted permissions on an Oracle Home, either Oracle Grid or Oracle Database Server.

Nothing to hide

Learn how to improve the security of your applications using Oracle Wallet / Secure External Password Store.

Password change, zero impact!

Learn how to change the password of an Oracle user, without interrupting the applications service.

Learn to patch the way God intended (S1E3)

Third post of a series dedicated to the art of Oracle patching. We continue with out-of-place patching, simplified using Gold Image.