ORA-12480: specified clearance labels not within the effective clearance

Cause : You specified a clearance range that was not within your authorized clearance; you can only specify clearance ranges that are within your clearance.

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

Specify clearance labels that are within your own clearance range.

update : 28-06-2017

ORA-12480 - specified clearance labels not within the effective clearance
ORA-12480 - specified clearance labels not within the effective clearance

  • ora-30676 : socket read or write failed
  • ora-08465 : input mask contains more than 32 characters
  • ora-12334 : database (link name string) is still open
  • ora-07440 : WMON process terminated with error
  • ora-23365 : site string does not exist
  • ora-38748 : cannot flashback data file string - file is in use or recovery
  • ora-01568 : cannot set space quota on PUBLIC
  • ora-29360 : retry operation. Too much concurrent activity
  • ora-12646 : Invalid value specified for boolean parameter
  • ora-29931 : specified association does not exist
  • ora-00486 : ASMB process terminated with error
  • ora-19999 : skip_row procedure was called
  • ora-27002 : function called with invalid device structure
  • ora-15075 : disk(s) are not visible cluster-wide
  • ora-19880 : Corrupted space header for datafile string, block string backup aborted
  • ora-29254 : Invalid lower_bound argument passed to procedure dbms_sql.define_array
  • ora-29280 : invalid directory path
  • ora-02456 : The HASH IS column specification must be NUMBER(*,0)
  • ora-16021 : session string destination cannot be the same as session string destination
  • ora-06933 : CMX: error during attach
  • ora-03215 : File Size specified for resize is too small
  • ora-31201 : DBMS_LDAP: generic error: string
  • ora-08457 : syntax error in SEPARATE CHARACTER option of SIGN clause
  • ora-26692 : invalid value string, string should be in string format
  • ora-30735 : cannot create multiple subtables of the same type under a supertable
  • ora-13376 : invalid type name specified for layer_gtype parameter
  • ora-34514 : (MXOPERR) You cannot string string data in the expression that begins with 'string'.
  • ora-01755 : Must specify an extent number or block number
  • ora-12638 : Credential retrieval failed
  • ora-06444 : ssvpstev: Failed with unexpected error number.
  • 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.