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 »

Do not set job_queue_processes at PDB level in 12.1.0.2

MOS Doc ID 2175443.1 goes into more detail, including the following quote: It is possible to set job_queue_processes at pdb level on 12.1.0.2 multitenant database, but it does not work correctly. I have managed to reproduce the actual behavior. Of particular concern is that this allows a local user on one PDB to disrupt things …

Do not set job_queue_processes at PDB level in 12.1.0.2 Read More »

Oracle Connection Manager (cman) registration_invited_nodes and registration_excluded_nodes

We make use Oracle Connection Manager to control client access to our database servers, it’s pretty cool technology that I’m always surprised how few people are aware of its existence. Our installed version is 12.1, and this is unable to communicate with our newly upgraded 12.2 instance, so I have been working through installing the …

Oracle Connection Manager (cman) registration_invited_nodes and registration_excluded_nodes 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 »

Transfer Tasks failing with ORA-28040 after Upgrading AWR Warehouse to 12cR2

Checking the AWR warehouse health after we upgraded the repository database from 12cR1 to 12cR2 I noticed that for some source databases the transfer task had been failing. Performing “Upload Snapshots Now” I was also able to reproduce the problem and identify the error message “ORA-28040: No matching authentication protocol”. This was initially puzzling as …

Transfer Tasks failing with ORA-28040 after Upgrading AWR Warehouse to 12cR2 Read More »