Tags

,

The Symptom
After you apply the January 2013 PSU patch to your OMS system you get the following error any time you load an Agent-related screen in your 12c Release2 console:

ORA-06550: line 1, column 22: PLS-00302: component ‘GET_UPGRADABLE_AGENTS_COUNT’ must be declared ORA-06550: line 1, column 7: PL/SQL:

The Cause

Incomplete application of the patch — you forgot to run post_deploy.sh from the patch directory.

Resolution
  1. Shutdown all Oracle management services in your environment.  Leave the repository database up.
  2. Run ‘opatch rollback -id 14840279 on all OMS servers
  3. On the primary OMS server only, execute ‘ $PATCHDIR/post_rollback.sh
    1. You may have to ‘chmod 700 post_rollback.sh‘ to make it executable
    2. You will be prompted for patch location and the password for SYSMAN
    3. Run a ‘tail -f’ on the logfile in another terminal window (opatch gives you the fully-qualified file name)
  4. Run ‘‘opatch apply’ on all your OMS servers
    1. Do not start them yet
  5. Run post_deploy.sh from the same directory as post_rollback.sh
    1. You may have to ‘chmod 700 post_deploy.sh to make it executable
    2. You will be prompted for patch location and the password for SYSMAN
    3. Run a ‘tail -f’ on the logfile in another terminal window (opatch gives you the fully-qualified file name)
  6. Check your repository for invalid objects with SELECT * FROM dba_objects WHERE status=’INVALID’;
  7. Start all your OMS servers with ‘emctl start oms
  8. Open the console and return to the page that flustered you before and PRESTO you’re fixed!

Likely elapsed time:  Less than 30 minutes