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 : 29-04-2017

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

  • ora-29347 : Tablespace name validation failed - failed to match tablespace 'string'
  • ora-22887 : type of REF column is not the same as that of its scoped table
  • ora-19577 : file string is MISSING
  • ora-02730 : osnrnf: cannot find user logon directory
  • ora-30024 : Invalid specification for CREATE UNDO TABLESPACE
  • ora-16058 : standby database instance is not mounted
  • ora-00325 : archived log for thread string, wrong thread # string in header
  • ora-37077 : (XSMCSESS05) Object workspace object is specified more than once.
  • ora-13048 : recursive SQL fetch error
  • ora-30943 : XML Schema 'string' is dependent on XML schema 'string'
  • ora-08412 : error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message
  • ora-22285 : non-existent directory or file for string operation
  • ora-09709 : soacon: failed to accept a connection.
  • ora-28048 : database is a member of multiple enterprise domains in OID
  • ora-29540 : class string does not exist
  • ora-22062 : invalid input string [string]
  • ora-01323 : Invalid state
  • ora-16607 : one or more databases have failed
  • ora-09802 : Conversion of binary label to string failed.
  • ora-13344 : an arcpolygon geometry has fewer than five coordinates
  • ora-00265 : instance recovery required, cannot set ARCHIVELOG mode
  • ora-25006 : cannot specify this column in UPDATE OF clause
  • ora-13033 : Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object
  • ora-27212 : some entrypoints in Media Management Library are missing
  • ora-13705 : There was a instance shutdown/startup between the snapshots in the range [string, string].
  • ora-25126 : Invalid name specified for BUFFER_POOL
  • ora-23450 : flavor already contains object "string"."string"
  • ora-12652 : String truncated
  • ora-38733 : Physical size string less than needed string.
  • ora-16652 : Fast-Start Failover target standby database is disabled
  • 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.