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-04-2017
ORA-13831

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

  • ora-19806 : cannot make duplex backups in recovery area
  • ora-13061 : topology with the name string does not exist
  • ora-29250 : Invalid index specifed in call to dbms_sql.bind_array
  • ora-22801 : invalid object row variable
  • ora-22877 : invalid option specified for a HASH partition or subpartition of a LOB column
  • ora-29504 : invalid or missing schema name
  • ora-01942 : IDENTIFIED BY and EXTERNALLY cannot both be specified
  • ora-02756 : osnfsmnam: name translation failure
  • ora-01202 : wrong incarnation of this file - wrong creation time
  • ora-39961 : message specified was not found
  • ora-39043 : Object type string is not supported for string.
  • ora-19123 : fn:zero-or-one() called with a sequence containing more than one item
  • ora-29296 : invalid encoded string
  • ora-00051 : timeout occurred while waiting for a resource
  • ora-02484 : Invalid _trace_buffers parameter specification (string)
  • ora-06017 : NETASY: message receive failure
  • ora-33068 : (XSAGDNGL33) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must specify a positive dimension offset.
  • ora-12701 : CREATE DATABASE character set is not known
  • ora-16795 : database resource guard detects that database re-creation is required
  • ora-27472 : invalid metadata attribute string
  • ora-27044 : unable to write the header block of file
  • ora-23482 : column string of "string"."string": object types not allowed.
  • ora-00344 : unable to re-create online log 'string'
  • ora-12007 : materialized view reuse parameters are inconsistent
  • ora-06550 : line string, column string: string
  • ora-10244 : make tranids in error msgs print as 0.0.0 (for testing)
  • ora-09266 : spawn: error starting an Oracle process
  • ora-19922 : there is no parent row with id string and level string
  • ora-27088 : unable to get file status
  • ora-31675 : worker process interrupt for unexpected death of master process
  • 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.