12cR2

Index WRH$_SGASTAT_U has status UNUSABLE after upgrade to 12.2

Update 2016-04-26: this is new bug 25954054 – WRH$_SGASTAT_U BECOMING UNUSABLE STATE IN UPGRADED DB. After upgrading our OMR and AWRW instances from 12.1 to 12.2, our monitoring revealed that index SYS.WRH$_SGASTAT_U was becoming unusable at regular intervals. The first couple of times, we just rebuilt it in the hope that the problem would just …

Index WRH$_SGASTAT_U has status UNUSABLE after upgrade to 12.2 Read More »

TNS-12599: TNS:cryptographic checksum mismatch

Checking the alert log of some of one of the instances we have recently upgraded to 12.2 I noticed the following error message occurring frequently: NI cryptographic checksum mismatch error: 12599. VERSION INFORMATION: TNS for Linux: Version 12.2.0.1.0 – Production Oracle Bequeath NT Protocol Adapter for Linux: Version 12.2.0.1.0 – Production TCP/IP NT Protocol Adapter …

TNS-12599: TNS:cryptographic checksum mismatch Read More »

Upgrade Recovery Catalog to 12cR2 fails and leaves catalog an unusable state

After upgrading our AWR Warehouse instance to 12.2 our standard RMAN scripts were failing because the Recovery Catalog required upgrading. Attempting the upgrade failed, and left the Recovery Catalog unable. Fortunately we were able to restore the catalog from weekly export. I was able to reproduce the problem by importing into a new schema, below …

Upgrade Recovery Catalog to 12cR2 fails and leaves catalog an unusable state Read More »