ORA-23445: missing template site

Cause : The template site specified by the site name, user name and refresh group template name does not exist.

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

Correct the invalid parameter and execute the procedure again. Use the DBA_REPCAT_TEMPLATE_SITES view to query the existing template sites.

update : 22-07-2017

ORA-23445 - missing template site
ORA-23445 - missing template site

  • ora-02298 : cannot validate (string.string) - parent keys not found
  • ora-13183 : unsupported geometric type for geometry string.string
  • ora-36392 : (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must supply an AGGMAP.
  • ora-22976 : incorrect number of arguments to MAKE_REF
  • ora-24774 : cannot switch to specified transaction
  • ora-07303 : ksmcsg: illegal database buffer size.
  • ora-19726 : cannot plug data [string] at level string into database running at compatibility level string
  • ora-12468 : max write level does not equal max read level
  • ora-13511 : invalid INTERVAL string, must be in the range (string, string)
  • ora-33218 : (CINSERT04) %K is not a valid value for the workspace object dimension. Values for this dimension can have at most number significant digits after rounding to number decimal places.
  • ora-19851 : OS error while managing auxiliary database string
  • ora-31038 : Invalid string value: "string"
  • ora-00351 : recover-to time invalid
  • ora-31157 : Invalid Content-Type charset
  • ora-01621 : cannot rename member of current log if database is open
  • ora-26050 : Direct path load of domain index is not supported for this column type.
  • ora-01586 : database must be mounted EXCLUSIVE and not open for this operation
  • ora-33086 : (XSAGINIT01) AGGMAP workspace object cannot be dimensioned by a conjoint dimension.
  • ora-19633 : control file record string is out of sync with recovery catalog
  • ora-12218 : TNS:unacceptable network configuration data
  • ora-14522 : Partition-level default tablespace string block size [string] for string string does not match existing string block size [string]
  • ora-32735 : DIAG process is not running in the instance
  • ora-32024 : invalid directory specified for audit_file_dest parameter
  • ora-25208 : RELATIVE_MSGID must be specified if SEQUENCE_DEVIATION is BEFORE
  • ora-12801 : error signaled in parallel query server string
  • ora-24019 : identifier for string too long, should not be greater than string characters
  • ora-16555 : the Data Guard database is not active
  • ora-19560 : %s is not a valid device limit
  • ora-13012 : an invalid window type was specified
  • ora-31070 : Invalid database user ID string
  • 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.