ORA-23447: missing user parameter value

Cause : The user parameter value specified by the user name, parameter 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_USER_PARMS view to query the existing user parameters.

update : 20-08-2017

ORA-23447 - missing user parameter value
ORA-23447 - missing user parameter value

  • ora-25201 : invalid value, VISIBILITY should be ON_COMMIT or IMMEDIATE
  • ora-00911 : invalid character
  • ora-19708 : log destination exceeds maximum length of string characters
  • ora-28664 : a partitioned table may not be coalesced as a whole
  • ora-07275 : unable to send signal to process
  • ora-08440 : raw buffer is too short to hold converted data
  • ora-29374 : resource plan string in top-plan string has no plan directives
  • ora-07759 : slemtr: invalid destination
  • ora-23369 : value of "string" argument cannot be null
  • ora-32109 : invalid column or parameter position
  • ora-01135 : file string accessed for DML/query is offline
  • ora-22303 : type "string"."string" not found
  • ora-23380 : propagation mode "string" is not valid
  • ora-25301 : Cannot enqueue or dequeue user buffered messages to a database with version lower than 10.2
  • ora-01687 : specified logging attribute for tablespace 'string' is same as the existing
  • ora-03275 : duplicate DEALLOCATE option specification
  • ora-00972 : identifier is too long
  • ora-13267 : error reading data from layer table string
  • ora-19584 : file string already in use
  • ora-30061 : Internal Event for Savepoint Tracing
  • ora-09844 : soacon: Archmon unable to open named pipe.
  • ora-31202 : DBMS_LDAP: LDAP client/server error: string
  • ora-25222 : enqueue failed, complete sender info. not provided for a queue supporting non-repudiation
  • ora-10854 : Sets poll count used for AQ listen code under RAC
  • ora-30111 : no closing quote for value 'string'
  • ora-24051 : cannot propagate object type payloads that have a REF attribute
  • ora-26013 : List allocated may not be big enough
  • ora-19587 : error occurred reading string bytes at block number string
  • ora-36924 : (XSVPMVTOPART05) workspace object is not in a COMPOSITE.
  • ora-31403 : change table string already contains a column 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.