Blog Archive

Hide column contents
Implement the masking of column contents, dynamically and without having to modify your applications.
Register ACFS file system fails
Learn how to register an ACFS filesystem after migrating the Disk Group containing it to a new Oracle Cluster.
Setting incremental statistics for partitioned tables
If you implemented incremental statistics in releases prior to Oracle 12.2, you may not be taking full advantage of them. Learn how to do it!
if there is an unusable index when analyze is executed, expect ORA-1502
How an error caused by running analyze to a table with unusable indexes is solved with regular expressions and dbms_stats.
We need to add new disks to Disk Group
Are you about to add, drop or replace disks in ASM? You may not be doing it in the most efficient way. Learn how.
Case sensitive comparison
Did you know that AutoUpgrade fails if the server names are not in lowercase and you are working with a RAC One Node database.
OEM shows incorrect value for used space
What to do when Oracle reports an incorrect value for the space used in Fast Recovery Area.
DG broker using wallet
Learn how to resolve and avoid the ORA-01017 error when you have Oracle Data Guard with wallet implemented.
enq: TX - row lock contention
Learn how to identify the row involved in the occurrence of the wait even "enq: TX - row lock contention"
Oracle uses sha512 since RU 19.16
Learn how to resolve the CRS-2304 GPnP profile signature verification failed error when starting an 11.2 database on a 19c cluster.
The OH in one node of a Cluster has wrong owner and group
Learn how to fix corrupted permissions on an Oracle Home, either Oracle Grid or Oracle Database Server.
Secure connection using a wallet
Learn how to improve the security of your applications using Oracle Wallet / Secure External Password Store.

Need Help?

Fill in these details and I will be in touch as soon as possible.