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.

Fighting against the clock

What to do when we find that the database returns the time advanced or delayed for no apparent reason.

Missing archivelog? Don’t rebuild your Standby (12c style)

Link to article published in Toad World, about how to overcome the lack of archivelogs to synchronize a standby database in Oracle.

Troubleshoot: losing control

The enq: CF – contention event could be resolved with controlfile maintenance if the controlfile contains a large number of archived log records.

Troubleshoot: confused optimizer

If the Oracle optimizer chooses inefficient execution plans on queries that use MAX or MIN, it is possible that this is bug 5611962.

Troubleshoot: ora-600[kcrf_resilver_log_1] & ora-600[4193]

What to do if you encounter the ORA-600 [kcrf_resilver_log_1] or ORA-600 [4193] error in an Oracle database.

The paradoxes of time

How in AIX the use of Olson instead of Posix for the timezone can cause slowness and how to solve it.

Dynamic service registration and ora-12514

How to properly configure the database and the listener when using a port other than 1521, to avoid the ORA-12514 error.

Imminent danger, God help us!

A very serious vulnerability associated with the DBMS_JVM_EXP_PERMS package has been made public, which opens the door to unpredictable damage.