ORA-27431: chain string.string has a user-managed rule set

Cause : A nattepmtw a smdaet om oidf yar uel estt hta si ontm aangde yb hteS cehdlue.r

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

Mdoiyf hter uel estd iercltyu snigt h edmbsr_uel_damp akcaeg ro rcetaea ntohre hcani iwtohu tsepcfiyniga url este.

update : 16-08-2017
ORA-27431

ORA-27431 - chain string.string has a user-managed rule set
ORA-27431 - chain string.string has a user-managed rule set

  • ora-16952 : Failed to bind this SQL statement.
  • ora-33070 : (XSAGDNGL34) In AGGMAP workspace object, all QDRs of dimension workspace object must map to the same dimension position.
  • ora-07683 : sou2os: $SETPRV reset error
  • ora-16042 : user requested cancel immediate of managed recovery operation
  • ora-32814 : propagation schedule string does not exist
  • ora-07632 : smsrcx: $DELTVA failure
  • ora-28291 : No Kerberos Principal Value found.
  • ora-13146 : could not find table substitution variable string
  • ora-06020 : NETASY: initialisation failure
  • ora-15204 : database version string is incompatible with diskgroup string
  • ora-19811 : cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
  • ora-40105 : input data incompatible with model signature
  • ora-31523 : could not find change source string for CDC change set string
  • ora-24160 : name string already exists in the name value pair list
  • ora-27365 : job has been notified to stop, but failed to do so immediately
  • ora-16746 : resource guard encountered errors during database mount
  • ora-27203 : skgfpqb: sbtpcquerybackup returned error
  • ora-29522 : authorization error for referenced name string.string
  • ora-14267 : cannot specify PARALLEL clause when adding a (Composite) Range partition
  • ora-22803 : object type contains zero attributes
  • ora-38736 : Wrong thread number string in flashback log file header.
  • ora-15093 : buffer only contains string bytes, I/O requested is string bytes
  • ora-22828 : input pattern or replacement parameters exceed 32K size limit
  • ora-31639 : unexpected data found
  • ora-14117 : partition resides in offlined tablespace
  • ora-39040 : Schema expression "string" must identify exactly one schema.
  • ora-28546 : connection initialization failed, probable Net8 admin error
  • ora-26681 : command type not supported
  • ora-13613 : The requested operation is not supported for this advisor object.
  • ora-24005 : must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables
  • 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.