ORA-23448: duplicate user parameter value

Cause : The user parameter value specified by the user name, parameter name and refresh group template name already exists.

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_USER_PARMS view to query the existing user parameters.

update : 25-04-2017

ORA-23448 - duplicate user parameter value
ORA-23448 - duplicate user parameter value

  • ora-30447 : internal data for run number string is inconsistent
  • ora-13427 : invalid BLOB parameter for output
  • ora-26025 : SKIP_INDEX_MAINTENANCE option requested
  • ora-07270 : spalck: setitimer error, unable to set interval timer.
  • ora-27452 : %s is an invalid name for a database object.
  • ora-02486 : Error in writing trace file string
  • ora-39041 : Filter "string" either identifies all object types or no object types.
  • ora-12669 : Shared server: outbound protocol does not support proxies
  • ora-36992 : (XSRELGID09) A level relation is needed to produce a surrogate dimension gid.
  • ora-01968 : Only specify RESETLOGS or NORESETLOGS once
  • ora-31000 : Resource 'string' is not an XDB schema document
  • ora-19555 : invalid LOG_ARCHIVE_MIN_SUCCEED_DEST parameter value
  • ora-38505 : invalid default value for the attribute
  • ora-24068 : cannot start queue string, queue table string is being migrated
  • ora-12404 : invalid privilege string: string
  • ora-13644 : The user "string" is invalid.
  • ora-14609 : Tablespace was not specified for the previous lob segments of column string in template but is specified for string
  • ora-22922 : nonexistent LOB value
  • ora-29863 : warning in the execution of ODCIINDEXCREATE routine
  • ora-13137 : failed to generate tablespace sequence number
  • ora-01247 : database recovery through TSPITR of tablespace string
  • ora-07571 : szrfc: $FIND_HELD failure
  • ora-01935 : missing user or role name
  • ora-14623 : Value string does not exist in subpartition string
  • ora-16579 : bad Data Guard NetSlave state detected
  • ora-19619 : cannot call restoreValidate after files have been named
  • ora-23388 : replication parallel push watermark error
  • ora-12029 : LOB columns may not be used as filter columns
  • ora-16083 : LogMiner session has not been created
  • ora-07706 : error in archive text: need disk file name
  • 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.