ORA-23437: template authorization already exists for user

Cause : The specified user already has been authorized to use the specified refresh group template.

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

Check the values for user name and refresh template name or query the DBA_REPCAT_USER_AUTHORIZATIONS view to ensure that the correct values were passed as parameters.

update : 26-04-2017
ORA-23437

ORA-23437 - template authorization already exists for user
ORA-23437 - template authorization already exists for user

  • ora-02245 : invalid ROLLBACK SEGMENT name
  • ora-36404 : (XSSPROP04) Property string cannot be applied to an undimensioned (scalar) TEMPORARY variable.
  • ora-01500 : failure in getting date/time
  • ora-15127 : ASM file name 'string' cannot use templates
  • ora-08101 : index key does not exist file string: (root string, node string) blocks (string)
  • ora-39774 : parse of metadata stream failed with the following error: string
  • ora-19106 : invalid XQueryX: expected string - got string
  • ora-02227 : invalid cluster name
  • ora-07821 : sspsdn: SYS$DELLNM failure
  • ora-13156 : table to be registered string.string is not empty
  • ora-13039 : failed to update spatial index for element string.string.string
  • ora-09284 : sllfop: cannot allocate read buffer
  • ora-16214 : apply stalled for apply delay
  • ora-01116 : error in opening database file string
  • ora-19323 : Invalid url string
  • ora-12412 : policy package string is not installed
  • ora-32594 : invalid object category for COMMENT command
  • ora-16654 : Fast-Start Failover is enabled
  • ora-15009 : ASM disk "string" does not exist
  • ora-24270 : a row already exists in the string table for these parameters
  • ora-16166 : LGWR network server failed to send remote message
  • ora-30370 : set operators are not supported in this context
  • ora-40001 : value for string must be greater than zero
  • ora-12715 : invalid character set specified
  • ora-29254 : Invalid lower_bound argument passed to procedure dbms_sql.define_array
  • ora-16055 : FAL request rejected
  • ora-22984 : view query cannot contain references to a super view
  • ora-07655 : slsprom:$TRNLOG failure
  • ora-25336 : Cannot contact instance string during Streams AQ operation
  • ora-13149 : failed to generate next sequence number for spatial table 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.