ORA-13827: null or zero length attribute specified in SQL profile collection

Cause : One of the attributes within the SQL profile was not properly specified.

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

Retry with a fully specified SQL profile.

update : 26-05-2017
ORA-13827

ORA-13827 - null or zero length attribute specified in SQL profile collection
ORA-13827 - null or zero length attribute specified in SQL profile collection

  • ora-02729 : osncon: driver not in osntab
  • ora-30152 : File does not exist
  • ora-01249 : archiving not allowed in a clone database
  • ora-29502 : NAMED keyword required in CREATE JAVA RESOURCE
  • ora-27473 : argument string does not exist
  • ora-22978 : only simple attribute name is allowed in the WITH OBJECT OID clause
  • ora-29336 : Internal error [string] [string] from DBMS_PLUGTS
  • ora-06919 : CMX: error during write request (unknown event)
  • ora-24407 : connection pool already exists
  • ora-16065 : remote archival disabled at standby destination
  • ora-32144 : Cannot perform operation on a null interval
  • ora-09706 : slsget: get_process_stats error.
  • ora-02246 : missing EVENTS text
  • ora-26526 : materialized view sql ddl parse/expansion failed for string.string
  • ora-13353 : ELEM_INFO_ARRAY not grouped in threes
  • ora-13753 : "SQL Tuning Set" "string" already exists for user "string".
  • ora-08190 : restore point string is from a different incarnation of the database
  • ora-07497 : sdpri: cannot create trace file 'string'; errno = string.
  • ora-31428 : no publication contains all the specified columns
  • ora-01904 : DATAFILE keyword expected
  • ora-01095 : DML statement processed zero rows
  • ora-12463 : undefined group string for policy string
  • ora-16156 : LGWR archive log dependency not allowed if database is standby protected
  • ora-00821 : Specified value of sga_target stringM is too small, needs to be at least stringM
  • ora-19609 : %s is from different backup set: stamp string count string
  • ora-00336 : log file size string blocks is less than minimum string blocks
  • ora-07481 : snlmatt: cannot attach to lock manager instance.
  • ora-27484 : Argument names are not supported for jobs without a program.
  • ora-34361 : (MXDSS12) number other user reading
  • ora-00314 : log string of thread string, expected sequence# string doesn't match string
  • 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.