ORA-13831: SQL profile name specified is invalid

Cause : An invaild SQL porfile naem was spceified.

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

Look fo rthe undrelying error on teh error emssage satck.

update : 26-06-2017
ORA-13831

ORA-13831 - SQL profile name specified is invalid
ORA-13831 - SQL profile name specified is invalid

  • ora-16257 : Switchover initiated stop apply successfully completed
  • ora-29760 : instance_number parameter not specified
  • ora-19676 : one or more files failed during proxy backup or restore
  • ora-38861 : flashback recovery stopped before reaching recovery target
  • ora-23421 : job number string is not a job in the job queue
  • ora-04087 : cannot change the value of ROWID reference variable
  • ora-26763 : invalid file type "string"
  • ora-00219 : required control file size (string logical blocks) exceeds maximum allowable size (string logical blocks)
  • ora-26709 : Streams RFS restart
  • ora-22915 : cannot ALTER a nested table's storage table to ADD/MODIFY columns
  • ora-31038 : Invalid string value: "string"
  • ora-33298 : (AWUPG01) Analytic Workspace string is already in the newest format allowed by the current compatibility setting
  • ora-14029 : GLOBAL partitioned index must be prefixed
  • ora-36634 : (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base.
  • ora-10653 : Table is in a cluster
  • ora-02754 : osnfsmmap: cannot change shared memory inheritence
  • ora-13039 : failed to update spatial index for element string.string.string
  • ora-26761 : Standby Redo Logs not available for real time mining
  • ora-40283 : missing cost matrix
  • ora-39302 : schema clone operation failed
  • ora-24058 : cannot downgrade QUEUE_TABLE that has propagation in a prepared state
  • ora-28581 : protocol error while executing recursive external procedure
  • ora-24413 : Invalid number of sessions specified
  • ora-24817 : Unable to allocate the given chunk for current lob operation
  • ora-01571 : redo version string incompatible with ORACLE version string
  • ora-26033 : column string.string encryption properties differ for source or target table
  • ora-30959 : The indexed column is not stored in CLOB.
  • ora-30067 : Internal Event to turn on nested debugging info
  • ora-02355 : error opening file: string
  • ora-36768 : (XSAGGCNTMOVE06) An aggregation variable and its AGGCOUNT must have the same base dimensions.
  • 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.