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 : 26-09-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-02781 : Invalid value given for the timing wanted flag
  • ora-29918 : cannot create domain indexes on temporary tables
  • ora-30119 : unable to obtain a valid value for 'string'
  • ora-16659 : failover operation in progress
  • ora-24434 : OCIStmtRelease called before OCIStmtPrepare2.
  • ora-22343 : Compilation error for type invalidated by ALTER TYPE
  • ora-32305 : RepAPI materialized views with user-defined types are not supported
  • ora-07261 : spdde: kill error, unable to send signal to process.
  • ora-02172 : The PUBLIC keyword is not appropriate for a disable thread
  • ora-16611 : operation aborted at user request
  • ora-19007 : Schema string does not match expected string.
  • ora-12515 : TNS:listener could not find a handler for this presentation
  • ora-21615 : an OTS (named or simple) instance failed
  • ora-01539 : tablespace 'string' is not online
  • ora-30361 : unrecognized string type
  • ora-01681 : max # extents (string) reached in LOB segment in tablespace string
  • ora-31020 : The operation is not allowed, Reason: string
  • ora-14081 : new partition name must differ from the old partition name
  • ora-19041 : Comment data cannot contain two consecutive '-'s
  • ora-23345 : table "string"."string" not registered to collect statistics
  • ora-24901 : handles belonging to different environments passed into an OCI call
  • ora-30463 : 'string' is not a detail table of any summary
  • ora-06810 : TLI Driver: could not set the IPX ethernet SAP at init
  • ora-01140 : cannot end online backup - all files are offline or readonly
  • ora-06778 : TLI Driver: error sending ccode
  • ora-32642 : non-unique cell values from the ORDER BY clause
  • ora-02213 : duplicate PCTUSED option specification
  • ora-19951 : cannot modify control file until DBNEWID is completed
  • ora-00443 : background process "string" did not start
  • ora-12823 : default degree of parallelism may not 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.