ORA-12420: required procedures and functions not in policy package "string"

Cause : The policy package did not contain all of the procedures and functions necessary to enforce the policy.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Consult the label framework documentation for a list of required procedures and functions for a policy package.

update : 26-09-2017
ORA-12420

ORA-12420 - required procedures and functions not in policy package "string"
ORA-12420 - required procedures and functions not in policy package "string"

  • ora-02296 : cannot enable (string.string) - null values found
  • ora-25149 : Columns of UROWID type may not be indexed
  • ora-07458 : cannot set the RESOURCE_MANAGER_PLAN parameter
  • ora-29316 : datafile string been imported twice
  • ora-28650 : Primary index on an IOT cannot be rebuilt
  • ora-32314 : REFRESH FAST of "string"."string" unsupported after deletes/updates
  • ora-31700 : Very long string supplied for AUDIT_SYSLOG_LEVEL parameter
  • ora-37121 : AW Spreadsheet invalidated
  • ora-16510 : messaging error using ksrwait
  • ora-23393 : the user is already the propagator
  • ora-22328 : object "string"."string" has errors. string
  • ora-39048 : Unable to start all workers; only string worker(s) available.
  • ora-01606 : gc_files_to_locks not identical to that of another mounted instance
  • ora-25107 : duplicate TABLESPACE option specification
  • ora-13195 : failed to generate maximum tile value
  • ora-10361 : check buffer change vector count consistency
  • ora-15008 : cannot drop system template
  • ora-03241 : Invalid unit size
  • ora-36874 : (XSTFDSC04) Expression string cannot be used to define a column in a LIMITMAP.
  • ora-12675 : External user name not available yet
  • ora-32640 : FOR LIKE loops are not allowed for multi-byte character types
  • ora-29861 : domain index is marked LOADING/FAILED/UNUSABLE
  • ora-19881 : Corrupted space bitmap for datafile string, block string backup aborted
  • ora-01345 : must be a LogMiner coordinator process
  • ora-02189 : ON required
  • ora-04062 : %s of string has been changed
  • ora-39134 : Cannot include "string" tablespace as a Transportable Tablespace
  • ora-00305 : log string of thread string inconsistent; belongs to another database
  • ora-24409 : client cannot understand the object
  • ora-31226 : DBMS_LDAP: MOD_ARRAY size limit exceeded
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.