ORA-16605: unable to delete template, template is in use

Cause : The Data Guard broker was unable to delete the template because the template is still being used by one or more resources.

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

Delete all resources using the template before deleting the template. You cannot delete the database template.

update : 24-05-2017

ORA-16605 - unable to delete template, template is in use
ORA-16605 - unable to delete template, template is in use

  • ora-25186 : INCLUDING clause specified for index-organized table without OVERFLOW
  • ora-01123 : cannot start online backup; media recovery not enabled
  • ora-29806 : specified binding does not exist
  • ora-29865 : indextype is invalid
  • ora-13798 : Parameter string cannot be NULL.
  • ora-31515 : CDC change source string already exists
  • ora-12028 : materialized view type is not supported by master site string
  • ora-01578 : ORACLE data block corrupted (file # string, block # string)
  • ora-02192 : PCTINCREASE not allowed for rollback segment storage clauses
  • ora-16088 : archive log has not been completely archived
  • ora-14039 : partitioning columns must form a subset of key columns of a UNIQUE index
  • ora-34802 : (OCI11) OLAP OCI operation caused ROLLBACK past an UPDATE of an attached analytic workspace. Current operation canceled.
  • ora-22288 : file or LOB operation string failed string
  • ora-09319 : slgtd: unable to obtain the current date and time
  • ora-14131 : enabled UNIQUE constraint exists on one of the tables
  • ora-13481 : the destination type is not supported
  • ora-19804 : cannot reclaim string bytes disk space from string limit
  • ora-04092 : cannot string in a trigger
  • ora-37120 : MDX string is null
  • ora-30575 : ConText Option not installed
  • ora-30183 : invalid field width specifier
  • ora-12654 : Authentication conversion failed
  • ora-33270 : (DBERR05) Analytic workspace string already exists.
  • ora-36679 : (XSDPART17) workspace object contains a leaf (workspace object) that is not part of the partition dimension workspace object.
  • ora-29544 : invalid type
  • ora-38723 : Invalid SCN expression.
  • ora-39704 : permission to modify component registry entry denied
  • ora-09911 : Incorrect user password.
  • ora-29313 : tablespace 'string' cannot be imported twice
  • ora-19207 : scalar parameter string of XMLELEMENT cannot have an alias.
  • 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.