ORA-28108: circular security policies detected

Cause : oPilicsef rot ehs ma eboejtcr fereneece ca htoeh.r

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

rDpot ehp locieis

update : 24-08-2017

ORA-28108 - circular security policies detected
ORA-28108 - circular security policies detected

  • ora-13146 : could not find table substitution variable string
  • ora-02238 : filename lists have different numbers of files
  • ora-16024 : parameter string cannot be parsed
  • ora-00741 : logfile size of (string) blocks exceeds maximum logfile size
  • ora-31605 : the following was returned from string in routine string: LPX-number: string
  • ora-09824 : Unable to enable allowmacaccess privilege.
  • ora-14519 : Conflicting tablespace blocksizes for string string: Tablespace string block size string [string] conflicts with previously specified/implied tablespace string block size string [string]
  • ora-12805 : parallel query server died unexpectedly
  • ora-30151 : File already exists
  • ora-27472 : invalid metadata attribute string
  • ora-24273 : translation text is required if translation type is T or S
  • ora-02463 : Duplicate HASH IS option specified
  • ora-36814 : (XSTBLFUNC07) The datatype of the column used in the ROW2CELL clause of a LIMITMAP must be RAW(16).
  • ora-29953 : cannot issue DDL on a domain index partition marked as FAILED
  • ora-18010 : command missing mandatory CATEGORY keyword
  • ora-08230 : smscre: failed to allocate SGA
  • ora-01372 : Insufficient processes for specified LogMiner operation
  • ora-24907 : invalid pair of callback and recepient protocol attributes
  • ora-19591 : backup aborted because job time exceeded duration time
  • ora-02067 : transaction or savepoint rollback required
  • ora-02423 : schema name does not match schema authorization identifier
  • ora-24323 : value not allowed
  • ora-09272 : remote os logon is not allowed
  • ora-30756 : cannot create column or table of type that contains a supertype attribute
  • ora-28278 : No domain policy registered for password based GLOBAL users.
  • ora-19580 : %s conversation not active
  • ora-24020 : Internal error in DBMS_AQ_IMPORT_INTERNAL, string
  • ora-30019 : Illegal rollback Segment operation in Automatic Undo mode
  • ora-28270 : Malformed user nickname for password authenticated global user.
  • ora-17509 : Attempt to do i/o beyond block1 offset
  • 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.