ORA-13830: SQL profile with category string already exists for this SQL statement

Cause : A SQL profile already exists for the given SQL statement and category.

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

Drop or update the existing SQL profile.

update : 30-04-2017

ORA-13830 - SQL profile with category string already exists for this SQL statement
ORA-13830 - SQL profile with category string already exists for this SQL statement

  • ora-32837 : invalid configuration state string
  • ora-08309 : sllfop: Cannot fstat file
  • ora-06317 : IPA: Local maximum number of users exceeded
  • ora-19923 : the session for row with id string is not active
  • ora-23321 : Pipename may not be null
  • ora-36950 : (XSFCAST22) The list of string values cannot have more than number members. You supplied number.
  • ora-13459 : GeoRaster metadata SRS error
  • ora-32100 : operation invalid on transient object
  • ora-01875 : time zone minute must be between -59 and 59
  • ora-36640 : (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.
  • ora-12645 : Parameter does not exist.
  • ora-31069 : Cannot apply typed changes to non-schema-based XMLType nodes
  • ora-19568 : a device is already allocated to this session
  • ora-01946 : DEFAULT TABLESPACE already specified
  • ora-19769 : missing FILE keyword
  • ora-12544 : TNS:contexts have different wait/test functions
  • ora-24153 : rule set string.string already exists
  • ora-02436 : date or system variable wrongly specified in CHECK constraint
  • ora-16646 : Fast-Start Failover is disabled
  • ora-01040 : invalid character in password; logon denied
  • ora-21560 : argument string is null, invalid, or out of range
  • ora-08197 : Flashback Table operation is not supported on clustered tables
  • ora-25966 : join index cannot be based on an index organized table
  • ora-31153 : Cannot create schema URL with reserved prefix "http://xmlns.oracle.com/xdb/schemas/"
  • ora-40287 : invalid data for model - cosine distance out of bounds
  • ora-25310 : Subscriber is Notification only; dequeue not supported
  • ora-13387 : sdo_batch_size for array inserts should be in the range [number,number]
  • ora-01677 : standby file name convert parameters differ from other instance
  • ora-25437 : duplicate table value for table alias: string
  • ora-12071 : definition query of "string"."string" is invalid for offline instantiation
  • 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.