ORA-23436: missing template authorization for user

Cause : The specified template authorization does not exist.

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

Check the values for user name and refresh template name to ensure a valid row exists in the DBA_REPCAT_USER_AUTHORIZATIONS view.

update : 30-04-2017

ORA-23436 - missing template authorization for user
ORA-23436 - missing template authorization for user

  • ora-13864 : Statistics aggregation for service (module/action) string is already enabled
  • ora-01249 : archiving not allowed in a clone database
  • ora-33282 : (DBERR11) Cannot wait for analytic workspace string to become available since doing so would cause a deadlock.
  • ora-16586 : could not edit database property through instance
  • ora-16209 : Logical standby dictionary build failed to complete.
  • ora-22880 : invalid REF
  • ora-25263 : no message in queue string.string with message ID string
  • ora-30971 : illegal operation on the Path Table
  • ora-39169 : Local version of string cannot work with remote version of string.
  • ora-31476 : a change table data column is missing from the source table
  • ora-13467 : unsupported GeoRaster metadata specification: string
  • ora-23609 : unable to find directory object for directory string
  • ora-06105 : NETTCP: remote host is unknown
  • ora-27376 : event condition cannot be NULL
  • ora-31192 : Resource string has not been checked out
  • ora-16064 : remote archival is disabled by another instance
  • ora-24004 : invalid column name string in SORT_LIST, should be ENQ_TIME or PRIORITY
  • ora-24148 : cannot drop rule string.string with dependents
  • ora-01880 : the fractional seconds must be between 0 and 999999999
  • ora-06762 : TLI Driver: error reading orderly release
  • ora-06954 : Illegal file name
  • ora-07563 : sldext: $PARSE failure
  • ora-01653 : unable to extend table string.string by string in tablespace string
  • ora-23502 : valid directory for offline instatiation is not specified
  • ora-28605 : bitmap indexes cannot be reversed
  • ora-30074 : GLOBAL partitioned index on TIME/TIMESTAMP WITH TIME ZONE not allowed
  • ora-30729 : maximum number of columns exceeded
  • ora-16765 : Redo Apply is unexpectedly online
  • ora-36710 : (XSMXALLOC01) TARGETLOG variable workspace object must be dimensioned identically to TARGET variable workspace object.
  • ora-07406 : slbtpd: invalid number.
  • 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.