Wednesday, January 25, 2017

Oracle 12c and SYSAUX Tablespace Growing Rapidly

Problem:
You recently upgraded to Oracle 12c and your SYSAUX tablespace continues to grow in size. This may be happening because there is a default Unified Audit policy called ORA_SECURECONFIG.

Wednesday, September 21, 2016

Thursday, April 23, 2015

DBA_REGISTRY_HISTORY is not updated during upgrade to 12.1.0.2

Problem:
DBA_REGISTRY_HISTORY is not updated during upgrade to 12.1.0.2 or completly blank in Oracle 12.1.0.2.

The upgrade to Oracle 12.1.0.2 hangs and fails with ORA-00600:[KGHFRE3]

Problem:
The  upgrade to Oracle 12.1.0.2  hangs and then eventyally fails with
ORA-00600: internal error code, arguments: [KGHFRE3], [0x7F5098FC6F48]

Monday, January 19, 2015

Diagnose RAC Problems

Common problems:
  • Check RAC network configuration and Network Time Protocol (NTP) synchronization..
  • Incorrect shared storage configuration can cause RAC to fail.
  • All prerequisites must be installed before starting installation of an Oracle RAC.
  • Make sure that you have sufficient disk space, RAM, CPU, and so on.

Saturday, December 27, 2014

Applying PSU 11.2.0.4.4 to Grid Infrastructure and DB Home

Applying PSU 11.2.0.4.4 is a pretty simple task. This article explain the steps on how to patch Oracle 11g r2 RAC  installation. 

Please note, the GI PSU patch includes updates for both the Clusterware home and Database home that can be applied in a rolling fashion.

OS Version: CentOS release 6.6 (Final)
DB Version: 11.2.0.4.0 - 64bit