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 : 18-08-2017

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

  • ora-00964 : table name not in FROM list
  • ora-02331 : cannot create constraint on column of datatype string
  • ora-30397 : multiple JOIN KEY clauses specified for the same child level
  • ora-15052 : ASM file name 'string' is not in diskgroup "string"
  • ora-19765 : mount id string does not match mount id string in control file
  • ora-39102 : Timeout before master process string finished initialization. Master error:
  • ora-30375 : materialized view cannot be considered fresh
  • ora-29829 : implementation type does not exist
  • ora-12607 : TNS: Connect timeout occurred
  • ora-14107 : partition specification is required for a partitioned object
  • ora-12652 : String truncated
  • ora-06445 : ssvpstevrg: Incorrect parameters passed to function call
  • ora-02298 : cannot validate (string.string) - parent keys not found
  • ora-07745 : slemcl: $CLOSE failure
  • ora-30341 : dropped level has references
  • ora-30367 : a JOIN KEY clause is required
  • ora-02142 : missing or invalid ALTER TABLESPACE option
  • ora-13278 : failure to convert SRID to native format
  • ora-00356 : inconsistent lengths in change description
  • ora-19591 : backup aborted because job time exceeded duration time
  • ora-39006 : internal error
  • ora-25156 : old style outer join (+) cannot be used with ANSI joins
  • ora-37136 : (XSCCOMP11) Cannot ROLLUP dimension workspace object which is a base of COMPRESSED COMPOSITE workspace object, use AGGREGATE instead.
  • ora-30383 : specified dimension level does not exist in the attribute
  • ora-09888 : osnTXtt: txipc channel creation failed
  • ora-30962 : inconsistent ODCI input arguments
  • ora-39142 : incompatible version number string in dump file "string"
  • ora-01220 : file based sort illegal before database is open
  • ora-16810 : multiple errors or warnings detected for the database
  • 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.