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 : 29-06-2017

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

  • ora-00567 : Requested processor group string is too large (maximum string)
  • ora-04941 : required operating system patch needs to be applied
  • ora-03123 : operation would block
  • ora-06579 : Bind variable not big enough to hold the output value
  • ora-15177 : cannot operate on system aliases
  • ora-14099 : all rows in table do not qualify for specified partition
  • ora-16056 : backup control file archival requires proper syntax
  • ora-26701 : STREAMS process string does not exist
  • ora-30571 : invalid SEGMENT SPACE MANAGEMENT clause
  • ora-25403 : could not reconnect
  • ora-24185 : transformation string.string does not exist
  • ora-02205 : only SELECT and ALTER privileges are valid for sequences
  • ora-24332 : invalid object type
  • ora-25244 : dequeue index key not found, QUEUE string, rowid string
  • ora-25270 : sender info does not match with the actual sender of the message
  • ora-00059 : maximum number of DB_FILES exceeded
  • ora-23332 : group string is in use; cannot drop
  • ora-15048 : ASM internal files cannot be deleted
  • ora-12989 : invalid value for checkpoint interval
  • ora-03281 : invalid ALLOCATE EXTENT option
  • ora-00437 : ORACLE feature is not licensed. Contact Oracle Corp. for assistance
  • ora-10573 : Test recovery tested redo from change string to string
  • ora-19715 : invalid format string for generated name
  • ora-24233 : argument passed to DBMS_UTILITY.VALIDATE is not legal
  • ora-16637 : an instance failed to access the Data Guard broker configuration
  • ora-12833 : Coordinator's instance not a member of parallel_instance_group
  • ora-25954 : missing primary key or unique constraint on dimension
  • ora-00452 : foreground process unexpectedly terminated with error string
  • ora-14003 : GLOBAL clause contradicts previosly specified LOCAL clause
  • ora-38409 : invalid name or option for the attribute set: string
  • 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.