Enterprise Manager Generic (MOSC)

MOSC Banner

Resolving "ORA-06550: line 1, column 22: PLS-00302: component 'GET_UPGRADABLE_AGENTS_COUNT'"

edited Feb 1, 2013 10:00AM in Enterprise Manager Generic (MOSC) 2 comments
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center