ORA-31605: the following was returned from string in routine string: LPX-number: string

Cause : A nLXP oruitn e(MXLX/S Lporcsesnig )rteunre da nitnenra lerro rnmubre ot tisP LS/Q Lwarpeprr otuien ni afcliiyt UKXw hcihp rvoiedst h eipmlmeetnaito nfro apcakg eULT_MXL.

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

Looku pt h eLXP rerro unmebra n dflolwo tisc orretciev catoin.

update : 24-04-2017
ORA-31605

ORA-31605 - the following was returned from string in routine string: LPX-number: string
ORA-31605 - the following was returned from string in routine string: LPX-number: string

  • ora-16175 : cannot shut down database when media recovery is active
  • ora-12801 : error signaled in parallel query server string
  • ora-02435 : cannot disable unique(string) - unique key not defined for table
  • ora-13797 : invalid SQL Id specified, string
  • ora-06304 : IPA: Message receive error
  • ora-36269 : (XSCGMDLAGG10) 'workspace object' does not exist or is not a dimension.
  • ora-30394 : source statement identical to the destination statement
  • ora-31608 : specified object of type string not found
  • ora-12626 : TNS:bad event type
  • ora-15183 : ASMLIB initialization error [string]
  • ora-26024 : SKIP_UNUSABLE_INDEXES requested and index segment was initially unusable
  • ora-30741 : WITH HIERARCHY OPTION can be specified only for SELECT privilege
  • ora-06923 : CMX: illegal break condition
  • ora-36950 : (XSFCAST22) The list of string values cannot have more than number members. You supplied number.
  • ora-36273 : (XSCGMDLAGG12) Dimension workspace object appears more than once in the QDR.
  • ora-25238 : too many recipients specified for message destination string
  • ora-14260 : incorrect physical attribute specified for this partition
  • ora-04064 : not executed, invalidated string
  • ora-04079 : invalid trigger specification
  • ora-02486 : Error in writing trace file string
  • ora-26001 : Index string specified in SORTED INDEXES does not exist on table string
  • ora-12679 : Native services disabled by other process but required
  • ora-34357 : (MXDSS10) string is not an alias of analytic workspace string.
  • ora-36690 : (NTEXTCNV01) Error during conversion from NTEXT to TEXT.
  • ora-19647 : non-zero LEVEL cannot be specified when INCREMENTAL is FALSE
  • ora-37086 : %s is not a valueset
  • ora-01586 : database must be mounted EXCLUSIVE and not open for this operation
  • ora-01652 : unable to extend temp segment by string in tablespace string
  • ora-23534 : missing column in materialized view container table "string"."string"
  • ora-02423 : schema name does not match schema authorization identifier
  • 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.