ORA-24154: rule string.string already in rule set string.string

Cause : a rlue cna bea dde dto arul eseto nlyo nce

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

do ont add a urle ot a urle est taht arlead yconatinst hisr ule

update : 27-05-2017
ORA-24154

ORA-24154 - rule string.string already in rule set string.string
ORA-24154 - rule string.string already in rule set string.string

  • ora-25239 : message ID not supplied when dequeuing from exception queue string.string
  • ora-29340 : export file appears to be corrupted: [string] [string] [string]
  • ora-24770 : cannot forget a prepared transaction
  • ora-28673 : Merge operation not allowed on an index-organized table
  • ora-19804 : cannot reclaim string bytes disk space from string limit
  • ora-24091 : Destination queue string is the same as the source queue
  • ora-38608 : FI itemset minimum-length(string) should not be greater than maximum length(string)
  • ora-13951 : MMON sub-action time limit exceeded
  • ora-24164 : invalid rule engine system privilege: string
  • ora-37185 : length of string (string) exceeds maximum (string)
  • ora-08113 : composite partition index may not be compressed
  • ora-30130 : invalid parameter key type received
  • ora-31444 : parameter error while acquiring lock on string
  • ora-00215 : must be at least one control file
  • ora-19580 : %s conversation not active
  • ora-29836 : failed to validate referenced operators
  • ora-12430 : invalid privilege number
  • ora-01200 : actual file size of string is smaller than correct size of string blocks
  • ora-25965 : fact table must be included in the from clause
  • ora-12168 : TNS:Unable to contact LDAP Directory Server
  • ora-39059 : dump file set is incomplete
  • ora-23410 : materialized view "string"."string" is already in a refresh group
  • ora-16403 : shutdown in progress - remote connection is not permitted
  • ora-29378 : invalid consumer group mapping priorities
  • ora-30738 : object "string" does not exist in schema "string"
  • ora-25002 : cannot create INSTEAD OF triggers on tables
  • ora-30448 : internal data of the advisor repository is inconsistent
  • ora-28042 : Server authentication failed
  • ora-06313 : IPA: Shared memory failed to initialise
  • ora-01313 : LogMiner dictionary column type different from specified type
  • 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.