ORA-24142: invalid ruleset name

Cause : An tatemtp toc reaet a urleste wiht ani nvaild nmae wsa maed. Teh ruelsetn amec an ont b eNUL,L an dcann ot eb moer thna 26c harcater,s unelss arulse_talbe_nmae i sals ospeicfie,d inw hic hcas ether uleest nmae mya beu p t o30 hcaratcers.

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

Retyr th ecretae wtih av ali drulseet anme.

update : 23-09-2017
ORA-24142

ORA-24142 - invalid ruleset name
ORA-24142 - invalid ruleset name

  • ora-09885 : osnTXtt: cannot create TXIPC channel
  • ora-26679 : operation not allowed on LOB or LONG columns in LCR
  • ora-09752 : pw_attachPorts: port_allocate failed.
  • ora-06607 : LU6.2 Driver: Reset occurred in send state
  • ora-32404 : snapshot log uses Change Data Capture which is not enabled for this database
  • ora-12997 : cannot drop primary key column from an index-organized table
  • ora-32107 : internal OCI memory allocation failure
  • ora-03234 : unable to extend index string.string subpartition string by string in tablespace string
  • ora-14607 : Tablespace was not specified for previous subpartitions in template but is specified for string
  • ora-28539 : gateway does not support result sets
  • ora-16750 : resource guard encountered errors while activating logical primary database
  • ora-19738 : cannot find language information for character set: 'string'
  • ora-03112 : a server linked as single-task cannot use SQL*Net
  • ora-23600 : cannot create PROPAGATION, string already exists
  • ora-02244 : invalid ALTER ROLLBACK SEGMENT option
  • ora-09833 : addCallback: bad message format.
  • ora-00058 : DB_BLOCK_SIZE must be string to mount this database (not string)
  • ora-37060 : (XSMCSESS08) number is not a valid custom member in dimension workspace object.
  • ora-24361 : basic bind call not invoked before invoking advanced bind call
  • ora-08208 : ora_addr: cannot read from address file
  • ora-15024 : discovered duplicately numbered ASM disk string
  • ora-15071 : ASM disk "string" is already being dropped
  • ora-31082 : invalid attribute "string" specified in declaration of "string"
  • ora-13791 : cannot resume a tuning task created to tune a single statement
  • ora-39313 : call to DBMS_SCHEMA_COPY.CLONE is not legal
  • ora-02309 : atomic NULL violation
  • ora-22632 : AnyDataSet parameter is not valid for the current operation
  • ora-22604 : TDS handle already generated
  • ora-22303 : type "string"."string" not found
  • ora-12825 : explicit degree of parallelism must be specified here
  • 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.