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.

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]

How to get the first N rows with Oracle

Problem:

You want to get the first ten rows of the result set in Oracle.

ORA-28040: No matching authentication protocol

You are getting ORA-28040  (ORA-28040):  No matching authentication protocol.

Oracle database version: 12.1.0.1

Oracle client version: 11.2.0.3

Oracle Data Redaction (DBMS_REDACT)

Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by applications. You can redact column data by using one of the following methods:

• Full redaction
• Random redaction
• Partial redaction
• Regular expressions

[INS-30131] Initial setup required for execution of installer validation failed.

Problem:

Oracle 12c client installation on Windows fails with [INS-30131].

OS: Windows 2008 R2 64bit

Oracle Client: 12.1.0.1

Oracle 12c Installation Fails with [INS-13001] Environment does not meet minimum requirements.

Problem:

Oracle database/client 12c installation on Linux 6 fails with “[INS-13001] Environment does not meet minimum requirements”.

Post install steps of 12.1.0.1.1 PSU fails with ORA-20001: Latest xml inventory is not loaded into table, ORA-06512