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 : 24-05-2017
ORA-13831

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

  • ora-37175 : column string is not a column of source data
  • ora-16514 : the request was not found
  • ora-01033 : ORACLE initialization or shutdown in progress
  • ora-10262 : Don't check for memory leaks
  • ora-36636 : (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension.
  • ora-09953 : scggc: unexpected return of a lock convert
  • ora-39778 : the parallel load option is not allowed when loading lob columns
  • ora-13231 : failed to create index table [string] during R-tree creation
  • ora-12152 : TNS:unable to send break message
  • ora-06416 : NETCMN: error on test
  • ora-00074 : no process has been specified
  • ora-36802 : (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP.
  • ora-32407 : cannot exclude new values when materialized view log includes new values
  • ora-31637 : cannot create job string for user string
  • ora-16802 : downgrading redo transport mode from SYNC disallowed
  • ora-02379 : profile string already exists
  • ora-29504 : invalid or missing schema name
  • ora-07639 : smscre: SGA pad area not large enough (string bytes required)
  • ora-23335 : priority group string already exists
  • ora-31486 : cannot support column string in this configuration
  • ora-27083 : waiting for async I/Os failed
  • ora-31694 : master table string failed to load/unload
  • ora-13705 : There was a instance shutdown/startup between the snapshots in the range [string, string].
  • ora-31479 : could not create LogMiner session
  • ora-31650 : timeout waiting for master process response
  • ora-31456 : error executing a procedure in the DBMS_CDC_UTILITY package
  • ora-04028 : cannot generate diana for object stringstringstringstringstring
  • ora-29963 : missing BINDING keyword
  • ora-07745 : slemcl: $CLOSE failure
  • ora-03206 : maximum file size of (string) blocks in AUTOEXTEND clause is out of range
  • 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.