ORA-13828: generated SQL profile name string already exists

Cause : A SQL profile already exists with the name generated by the system.

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

Retry the operation as the generated name is time sensitive.

update : 23-08-2017

ORA-13828 - generated SQL profile name string already exists
ORA-13828 - generated SQL profile name string already exists

  • ora-12436 : no policy options specified
  • ora-13783 : invalid tuning scope
  • ora-12041 : cannot record ROWIDs for index-organized table "string"."string"
  • ora-36850 : (XSLMGEN20) View token string is not correct
  • ora-12433 : create trigger failed, policy not applied
  • ora-10562 : Error occurred while applying redo to data block (file# string, block# string)
  • ora-15080 : synchronous I/O operation to a disk failed
  • ora-12082 : "string"."string" cannot be index organized
  • ora-00268 : specified log file does not exist 'string'
  • ora-25154 : column part of USING clause cannot have qualifier
  • ora-31526 : could not find source table string.string for CDC change table string.string
  • ora-14303 : partitions or subpartitions are not in the right order
  • ora-33458 : (ESDREAD09) Discarding compiled code for workspace object because number is now type string, whereas it was type string when the code was compiled.
  • ora-32011 : cannot restore SPFILE to location already being used by the instance
  • ora-01539 : tablespace 'string' is not online
  • ora-13444 : GeoRaster metadata SRS error
  • ora-25305 : enqueue failed, expiration must be zero for queue string.string
  • ora-01880 : the fractional seconds must be between 0 and 999999999
  • ora-16618 : response document of size "string" bytes is too large
  • ora-13333 : invalid LRS measure
  • ora-31102 : Already locked in exclusive mode. Cannot add lock.
  • ora-36816 : (XSTBLFUNC09) The workspace object dimension is of datatype string which does not support custom member upserts.
  • ora-31645 : unable to read from dump file "string"
  • ora-27151 : buffer not large enough to hold process ID string
  • ora-27460 : cannot execute disabled job "string.string"
  • ora-39779 : type "string"."string" not found or conversion to latest version is not possible
  • ora-14603 : [SUBPARTITIONS | SUBPARTITION TEMPLATE] subpartition_count syntax is valid only for range-hash tables
  • ora-09840 : soacon: Name translation failure.
  • ora-14632 : cannot specify PARALLEL clause when adding a List subpartition
  • ora-12493 : invalid MLS binary label
  • 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.