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 : 23-06-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-31088 : object "string"."string" depends on the schema
  • ora-12025 : materialized view log on "string"."string" already has primary keys
  • ora-02733 : osnsnf: database string too long
  • ora-19696 : control file not found in backup set
  • ora-28166 : duplicate rolename in list
  • ora-06421 : NETCMN: Error detected in the read-in data
  • ora-19705 : tag value exceeds maximum length of string characters
  • ora-30202 : NULL pointer to OCIMsgh was passed to OCIMsg function
  • ora-25133 : duplicate SINGLE TABLE option specified
  • ora-28106 : input value for argument #string is not valid
  • ora-02364 : error writing to file: string
  • ora-08319 : sllfsk: Error reading file
  • ora-29528 : invalid Java call in trigger string
  • ora-12047 : PCT FAST REFRESH cannot be used for materialized view "string"."string"
  • ora-36648 : (XSDUNION09) Concat dimension workspace object is already defined as UNIQUE.
  • ora-07303 : ksmcsg: illegal database buffer size.
  • ora-31605 : the following was returned from string in routine string: LPX-number: string
  • ora-03001 : unimplemented feature
  • ora-25310 : Subscriber is Notification only; dequeue not supported
  • ora-01655 : unable to extend cluster string.string by string in tablespace string
  • ora-30448 : internal data of the advisor repository is inconsistent
  • ora-12449 : Labels specified for user must be of type USER
  • ora-08184 : attempting to re-enable Flashback while in Flashback mode
  • ora-16734 : error executing dbms_logstdby.skip_error procedure
  • ora-30500 : database open triggers and server error triggers cannot have BEFORE type
  • ora-32507 : expecting string but found string
  • ora-00231 : snapshot control file has not been named
  • ora-09828 : SCLFR: atomic latch return error.
  • ora-02432 : cannot enable primary key - primary key not defined for table
  • ora-12685 : Native service required remotely but disabled locally
  • 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.