ORA-23532: tables with different synchronization mechanisms are in the same group

ORA-23532: tables with different synchronization mechanisms are in the same group

Cause: Tables belonging to the same replication group were specified to be cached with different synchronization mechanisms.

Action: Do not specify different synchronization mechanisms while caching tables belonging to the same replication group.

ORA-23531: site owner already exists in the template.

ORA-23531: site owner already exists in the template.

Cause: Site owner for the template already exists.

Action: Do not create multiple siteowners for this template.

ORA-23515: materialized views and or or their indices exist in the tablespace

ORA-23515: materialized views and or or their indices exist in the tablespace

Cause: An attempt was made to drop a tablespace which contains materialized views and or or their indices.

Action: Drop the materialized views in this tablespace. Also, find indices belonging to materialized views in this tablespace and drop then. Then try dropping the tablespace.

ORA-23514: invalid or incorrect number of arguments

ORA-23514: invalid or incorrect number of arguments

Cause: The arguments passed to the online redefinition API were invalid or missing.

Action: Call the online redefinition API with the right number of valid arguments.

ORA-23505: Object string . string is missing.

ORA-23505: Object string . string is missing.

Cause: The specified object does not exist.

Action: Check that the specified object is correct.

ORA-23504: columns added to table do not match list of columns to be added

ORA-23504: columns added to table do not match list of columns to be added

Cause: The list of columns passed as a parameter does not match the columns to be added to the table.

Action: Correct the DDL string or list of columns and rexecute.

ORA-23503: error occurred during IAS instantiation

ORA-23503: error occurred during IAS instantiation

Cause: An attempt was made to instantiate a IAS site. Error occurred during IAS instantiation.

Action: See other errors on the error stack to look for the source of the problem. If the error still persists, contact Oracle Support.

ORA-23502: valid directory for offline instatiation is not specified

ORA-23502: valid directory for offline instatiation is not specified

Cause: An attempt was made to offline instantiate to a directory which is not specified or null.

Action: There are two ways to specify the directory: o As a parm offline_dirpath to the API o As an init.ora parm named utl_file_dir Make sure you have specified an appropriate directory in which the offline file can be created.

ORA-23501: refresh template cannot be instantiated for database with compatibilty equal to or less than 8.0

ORA-23501: refresh template cannot be instantiated for database with compatibilty equal to or less than 8.0

Cause: Instantiation of a refresh template is not supported for database compatibility 8.0 or less.

Action: Be sure the database compatibility is 8.1 or above.

ORA-23500: cannot switch master for a multi-tier materialized view repgroup string. string

ORA-23500: cannot switch master for a multi-tier materialized view repgroup string. string

Cause: An attempt was made to switch master for a materialized view repgroup when its parent repgroup is also a materialized view repgroup. This is not allowed.

Action: Drop and recreate the materialized view repgroup based on a proper parent repgroup.

ORA-23498: repgroups specified must have the same masters

ORA-23498: repgroups specified must have the same masters

Cause: The Repgroup names specified do not have the same masters.

Action: Ensure that the Repgroup names specified have the same masters.

ORA-23497: repgroup name cannot be null

ORA-23497: repgroup name cannot be null

Cause: The array of Repgroup names contains a null value.

Action: Ensure that the array of Repgroup names is dense and is not null terminated.

ORA-23496: can not change disabled status for string and string

ORA-23496: can not change disabled status for string and string

Cause: The disabled status for this site is set internally for synchronization during adding a new master without quiescing.

Action: Ensure adding a new master without quiescing finished before invoking this procedure.

ORA-23495: serial propagation can not be used for string

ORA-23495: serial propagation can not be used for string

Cause: The sites involved may be in the process of adding a new site without quiescing.

Action: Check the def$_destination table for this destination and try parallel propagation.

ORA-23494: too many rows for destination string

ORA-23494: too many rows for destination string

Cause: The specified destination has too many rows in system.def$_destination table.

Action: Ensure the specified destination has at most two valid rows before retrying this operation.

ORA-23493: string is not a new site for extension request string

ORA-23493: string is not a new site for extension request string

Cause: The specified extension request does not include the specified site as a new site.

Action: Ensure the specified site is a new site for this extension request before retrying this operation.

ORA-23492: no new sites for extension request string

ORA-23492: no new sites for extension request string

Cause: There is no new site with the specified extension request.

Action: Ensure there is at least one new site in DBA_REPSITES_NEW view for this request before retrying this operation.

ORA-23491: no valid extension request at string

ORA-23491: no valid extension request at string

Cause: The specified database does not have a valid extension request.

Action: Ensure there is a valid extension request in DBA_REPEXTENSIONS view before retrying this operation.

ORA-23490: extension request string with status string not allowed in this operation

ORA-23490: extension request string with status string not allowed in this operation

Cause: The specified operation is not allowed for the extension request with the specified status.

Action: Ensure the extension request has the appropriate status before retrying this operation.

ORA-23489: duplicate entry string

ORA-23489: duplicate entry string

Cause: The specified value is duplicated in the parameter list.

Action: Remove duplicated entries in the parameter list.

ORA-23488: propagation mode string for string is not allowed for this operation

ORA-23488: propagation mode string for string is not allowed for this operation

Cause: This operation does not support the specified dblink in the above propagation mode.

Action: Do not invoke the operation for this dblink, or change the propagation mode for this dblink.

ORA-23487: object groups string . string and string . string do not have the same connection qualifier

ORA-23487: object groups string . string and string . string do not have the same connection qualifier

Cause: The specified two object groups do not have the same connection qualifier.

Action: Do not invoke the operation on the above object groups, or ensure they have the same connection qualifier.

ORA-23485: Column group string must consist of a single numeric column only

ORA-23485: Column group string must consist of a single numeric column only

Cause: The column group doesn t contain only one numeric column.

Action: Use a column group containing a single numeric column.

ORA-23484: internal internet Application Server error: string

ORA-23484: internal internet Application Server error: string

Cause: An internal error occurred in internet Application Server.

Action: Report the error and other information to support.

ORA-23483: object string . string not allowed in this operation.

ORA-23483: object string . string not allowed in this operation.

Cause: The specified operation does not support the given object.

Action: Do not invoke the operation for this object.

ORA-23482: column string of string . string : object types not allowed.

ORA-23482: column string of string . string : object types not allowed.

Cause: The column is of Object Type.

Action: Ensure that all the columns are not of Object Type.

ORA-23480: Column string is not a top-level column of string . string .

ORA-23480: Column string is not a top-level column of string . string .

Cause: The column is either not a top-level column or is not present in the table or materialized view.

Action: Ensure only valid top-level columns are used.

ORA-23478: object group string is already mastered at string

ORA-23478: object group string is already mastered at string

Cause: There is at least one other materialized view repgroup at the local site with the same group name but a different master site.

Action: Ensure that all materialized view repgroups at the local site with the same group name have the same master.

ORA-23477: unable to alter propagation mode for object group string . string

ORA-23477: unable to alter propagation mode for object group string . string

Cause: The propagation method of a materialized view object group can only be altered when no other object groups with the same master object group are sharing the materialized view site.

Action: Ensure that there are no other materialized view object groups at the local site with the same master object group.

ORA-23476: cannot import from string to string

ORA-23476: cannot import from string to string

Cause: This object was imported from a database with a different global name than the importing database.

Action: Only import this object into a database with the same global name.

ORA-23475: key column string must be sent and compared

ORA-23475: key column string must be sent and compared

Cause: The specified column is a key column and must be sent and compared during replication propagation.

Action: Make sure every key column is sent and compared.

ORA-23474: definition of string . string has changed since generation of replication support

ORA-23474: definition of string . string has changed since generation of replication support

Cause: The current columns in the specified table and their column types do not match the columns and column types when replication support was last generated.

Action: Regenerate replication support for the affected table. All flavors that include the specified table should be checked for validity. Types for any UDT columns should also be checked for validity.

ORA-23473: replication RPC processing for string . string is disabled

ORA-23473: replication RPC processing for string . string is disabled

Cause: The processing of replication RPCs for the object group that contains this object is disabled. This includes RPCs in the error queue.

Action: Processing of replication RPCs is disabled when the object group is being offline instantiated. Wait until offline instantiation is finished.

ORA-23472: materialized view string . string must be atomically refreshed

ORA-23472: materialized view string . string must be atomically refreshed

Cause: Non-atomic refresh is not supported for the specified materialized view.

Action: Set the value of the ATOMIC parameter to FALSE in the refresh procedure being used or remove the specified materialized view from the set of materialized views being refreshed.

ORA-23471: template not authorized for user

ORA-23471: template not authorized for user

Cause: The refresh template is private and the user has not been authorized to instantiate the template.

Action: Authorize the user to use the template.

ORA-23470: invalid status

ORA-23470: invalid status

Cause: The status should be DELETED, INSTALLING or INSTALLED. Any other status is invalid.

Action: Check that the specified status value is correct.

ORA-23469: %s is different between templates

ORA-23469: %s is different between templates

Cause: The values for the specified columns are different in each template for the same key values.

Action: Correct the column values to make the templates the same.

ORA-23468: missing string string

ORA-23468: missing string string

Cause: The template is missing the object with the specified key.

Action: Add the object to the template.

ORA-23467: flavor lacks object string . string

ORA-23467: flavor lacks object string . string

Cause: The flavor does not include the specified object which is being dropped.

Action: Check that the specified object is correct.

ORA-23466: flavor requires missing object string . string

ORA-23466: flavor requires missing object string . string

Cause: The flavor includes the specified object which does not exist

Action: Check that the specified object name is correct, and create the object if appropriate.

ORA-23465: flavor already includes column string of string . string

ORA-23465: flavor already includes column string of string . string

Cause: The flavor includes the specified column which is being added.

Action: Check that the specified column is correct.

ORA-23464: flavor lacks column string of string . string

ORA-23464: flavor lacks column string of string . string

Cause: The flavor includes some columns of an object group but not all the required columns.

Action: Change the flavor definition to include all required columns.

ORA-23463: flavor incompatible with object string . string

ORA-23463: flavor incompatible with object string . string

Cause: An existing flavor includes the specified object with an incompatible type.

Action: Change the type of the object, or delete the flavor if it is not in use.

ORA-23462: flavor string in use at site string

ORA-23462: flavor string in use at site string

Cause: The given flavor cannot be deleted because it is being used at the given site.

Action: Change the flavor of the site, or unregister it if it is a materialized view site.

ORA-23460: missing value for column string in resolution method string for string. string . string

ORA-23460: missing value for column string in resolution method string for string. string . string

Cause: before resolving conflicts, some values necessary resolving conflicts are not available, or after resolving conflicts, some values necessary for re-trying of the SQL are not available

Action: define appropriate flavors, provide necessary values through availability vector in USER FLAVOR FUNCTION for conflict resolution

ORA-23459: flavor string must contain string

ORA-23459: flavor string must contain string

Cause: The flavor must contain the given object, column, or attribute.

Action: Either choose a different database flavor or ensure the object, column, or attribute is available.

ORA-23458: inappropriate flavor string at string

ORA-23458: inappropriate flavor string at string

Cause: The given flavor at the given database prevents the operation from succeeding.

Action: Either change the database flavor or choose a different operation.

ORA-23457: invalid flavor ID string

ORA-23457: invalid flavor ID string

Cause: The given flavor ID is invalid.

Action: Make sure this flavor has been instantiated. If the flavor ID is outside the range (-2147483647, 2147483647), contact customer support.

ORA-23456: flavor string does not contain string

ORA-23456: flavor string does not contain string

Cause: The flavor does not contain the given object, column, or attribute.

Action: Either drop the flavor or choose a different object, column, or attribute.

ORA-23455: flavor string contains object string

ORA-23455: flavor string contains object string

Cause: The given flavor contains the object to be dropped.

Action: Purge the flavor or choose another object to drop.

ORA-23454: flavor string not defined for object group string . string

ORA-23454: flavor string not defined for object group string . string

Cause: The given object group does not contain a (published) definition of the specified flavor.

Action: Check the spelling of the flavor name. Ensure the flavor has been defined (and published) for the object group.

ORA-23453: requested operation is not supported on top flavor

ORA-23453: requested operation is not supported on top flavor

Cause: The TOP flavor has a NULL name and may not be directly defined or deleted.

Action: Supply the name of a flavor other than the TOP flavor or use dbms_repcat routines to implicitly change the TOP flavor.

ORA-23452: flavor string of object group string . string is already published

ORA-23452: flavor string of object group string . string is already published

Cause: The given object group already contains a (published) definition of the specified flavor.

Action: Check the spelling of the flavor name.

ORA-23451: flavor string already defined for object group string . string

ORA-23451: flavor string already defined for object group string . string

Cause: The given object group already contains a (possibly unpublished) definition of the specified flavor.

Action: Check the spelling of the flavor name. Check for an unpublished flavor of the desired name.

ORA-23450: flavor already contains object string . string

ORA-23450: flavor already contains object string . string

Cause: The flavor already contains the specified object.

Action: Check that the specified object is correct. To add all columns of a table object, delete the object from the flavor and then add it again.

ORA-23449: missing user name

ORA-23449: missing user name

Cause: The user specified by the user name parameter does not exist in the database.

Action: Correct an invalid user name or create the user in the master database. Use the DBA_USERS view to select the valid database users.

ORA-23448: duplicate user parameter value

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: Correct the invalid parameter and execute the procedure again. Use the DBA_REPCAT_USER_PARMS view to query the existing user parameters.

ORA-23447: missing user parameter value

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: Correct the invalid parameter and execute the procedure again. Use the DBA_REPCAT_USER_PARMS view to query the existing user parameters.

ORA-23446: duplicate template site

ORA-23446: duplicate template site

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

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

ORA-23445: missing template site

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: Correct the invalid parameter and execute the procedure again. Use the DBA_REPCAT_TEMPLATE_SITES view to query the existing template sites.