ORA-01934: circular role grant detected

Cause : Role scannto be rgante dcircluarly .Also ,a roel canont beg rantde to tiself.

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

Do nto perofrm teh gratn.

update : 23-06-2017
ORA-01934

ORA-01934 - circular role grant detected
ORA-01934 - circular role grant detected

  • ora-09217 : sfsfs: failed to resize file
  • ora-16003 : standby database is restricted to read-only access
  • ora-29514 : class name contains illegal character
  • ora-24295 : max key length (string) for sorted hash cluster exceeded
  • ora-06317 : IPA: Local maximum number of users exceeded
  • ora-00741 : logfile size of (string) blocks exceeds maximum logfile size
  • ora-07740 : slemop: incorrect handle size (programming error)
  • ora-24280 : invalid input value for parameter string
  • ora-36639 : (XSDUNION18) UNIQUE cannot be applied to this concat dimension because leaves workspace object and workspace object share the value number.
  • ora-00261 : log string of thread string is being archived or modified
  • ora-08313 : sllfop: could not allocate buffers
  • ora-14189 : this physical attribute may not be specified for an index subpartition
  • ora-24302 : host connection in use by another thread
  • ora-01492 : LIST option not valid
  • ora-31227 : DBMS_LDAP: invalid LDAP MESSAGE handle
  • ora-04004 : MINVALUE must be less than MAXVALUE
  • ora-01716 : NOSORT may not be used with a cluster index
  • ora-09706 : slsget: get_process_stats error.
  • ora-09317 : szprv: insufficient privileges
  • ora-19724 : snapshot too old: snapshot time is before file string plug-in time
  • ora-27023 : skgfqsbi: media manager protocol error
  • ora-15190 : Internal ASM testing event number 15190
  • ora-38736 : Wrong thread number string in flashback log file header.
  • ora-00071 : process number must be between 1 and string
  • ora-06951 : Operating system call error
  • ora-39141 : dump file "string" is a duplicate of dump file "string"
  • ora-13351 : two or more rings of a complex polygon overlap
  • ora-27373 : unknown or illegal event source queue
  • ora-24183 : invalid transformation
  • ora-32848 : foreign queue DOMAIN required for JMS unified connections
  • 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.