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 »

Upgraded database broken in Enterprise Manager: No such metadata

This past week I have been having fun upgrading our AWR Warehouse instance from 12.1 to 12.2.  I thought this would be a good chance to get some exposure to 12.2 on a real-life system without affecting anything critical.  I have run into quite a few issues. First was that after I upgraded the instance, …

Upgraded database broken in Enterprise Manager: No such metadata Read More »