织梦CMS - 轻松建站从此开始!

文档之家-IT技术文档共享平台

当前位置: 文档之家 > 数据库 > Oracle >

Oracle 10g errors message troubleshooting 192 (ORA-31401 to

时间:2011-04-04 11:50来源:未知 作者:admin 点击:
ORA-31495: error in synchronous change table on "string"."string" Cause: There was an error originating from this synchronous change table. One possible cause is that schema redefinition has occurred on the source table and one or more col

 

ORA-31401: change source string is not an existing change source
Cause: The caller did not use the name of an existing change source. The name given does not match the name of any existing change source.
Action: Check the spelling of the change source name. Choose an existing change source.
ORA-31402: unrecognized parameter string
Cause: Unrecognized parameter was detected.
Action: Check for too many parameters in the call.
ORA-31403: change table string already contains a column string
Cause: Issued ALTER_CHANGE_TABLE with an add operation but a column by this name already exists in the specified table.
Action: Check the names and call the procedure again.
ORA-31404: all input parameters are null
Cause: All input parameters are null. At least one property must be altered.
Action: Call the procedure again, making sure that all the required parameters have been specified. Ensure that at least one parameter is not null. Refer to user documentation for the correct way of calling this procedure.
ORA-31405: cannot make changes while change set string is advancing
Cause: The change set is currently advancing. Change sources related to an advancing change set cannot be altered. Change tables related to the advancing change set cannot be created, altered or dropped. Some or all the parameters of the change set cannot be altered while the set is advancing.
Action: Wait until the change set has finished advancing, then reissue the command. If altering the change set, only the advance_enable parameter can be altered during an advance.
ORA-31406: change source string is referenced by a change set
Cause: The operation cannot complete because this change source is referenced by one or more change sets.
Action: Drop the change sets first, then re-issue the command. May have to drop some change tables before the change sets are dropped.
ORA-31407: end_date must be greater than the begin_date
Cause: The end data of the change set is earlier than the begin date. The end date must always be later in time than the begin date, so that the duration between the begin and end dates is a positive amount of time.
Action: Change the begin date and/or the end date, so that the end date is later than the begin date.
ORA-31408: invalid value specified for begin_scn or end_scn
Cause: The begin_scn was not greater than zero. The end_scn was less than zero. The end_scn was less than the begin_scn.
Action: Check the values of both begin_scn and end_scn. Correct them to make sure that they form a legal SCN range. An end_scn value of zero indicates an infinite scn range.
ORA-31409: one or more values for input parameters are incorrect
Cause: One or more of the inputs to the procedure had invalid values.
Action: Identify the bad parameter(s) and supply correct values to the procedure.
ORA-31410: change set string is not an existing change set
Cause: Could not find an existing change set by this name.
Action: Check the spelling of the change set name. Call the procedure again, passing the correct change set name.
ORA-31411: change set string is referenced by a change table
Cause: The operation cannot be performed because the change set contains one or more change tables.
Action: You will need to drop the change table(s) first, then repeat the operation
ORA-31412: change set string is disabled and cannot be advanced
Cause: The specified change set is disabled. The change set needs to be enabled for the operation to succeed.
Action: Determine why the change set is disabled and correct this condition. Alter the change set specifying 'y' for advance_enable then retry the operation.
ORA-31413: change set string is currently being advanced
Cause: An advance operation is in progress for this change set and we only allow one at a time.
Action: Since the change set is currently being advanced, the best action is to wait for it to finish advancing. Only one caller at a time can advance the change set. Check for the cause of long running advance operations.
ORA-31414: error(s) occurred during change table advance
Cause: One or more errors occurred during the advance operation.
Action: Check the log file(s) for a more detailed report of the underlying errors.
ORA-31415: change set string does not exist
Cause: Specified change set does not exist or the user does not have access to the publications in that change set. The name specified did not match the name of any existing change set. Certain privileges are required to access the publications within that change set.
Action: Check the name and call the procedure again, with the name of an existing change set. Contact the publisher or database administrator if user privileges are required to access the publications in the change set.
ORA-31416: invalid SOURCE_COLMAP value
Cause: A source_colmap value of 'y' was specified for an asynchronous change table.
Action: Specify a source_colmap parameter value of 'n' and call the procedure again.
ORA-31417: column list contains control column string
Cause: Reserved column name was specified in a column list or column type parameter.
Action: Control columns are selected with separate parameters. If you did not want a control column, then change the name of the specified column so that it does not conflict with a reserved column name.
ORA-31418: source schema string does not exist
Cause: Trying to create a synchronous change table and the source schema did not match any existing schema names in the database.
Action: Specify the name of an existing schema.
ORA-31419: source table string does not exist
Cause: When creating a synchronous change table, the underlying source table must exist when the procedure is called. In this case, the source table did not exist.
Action: Specify the name of an existing table.
ORA-31420: unable to submit the purge job
Cause: When creating the first change table, a purge job is submitted to the job queue. Submission of this purge job failed.
Action: Make sure that job queue processes are enabled and are currently running. If this does not solve the problem, contact Oracle.
ORA-31421: change table does not exist
Cause: Specified change table does not exist.
Action: Recheck the name, and call the procedure again using an existing change table.
ORA-31422: owner schema string does not exist
Cause: Value specifed for the owner parameter does not contain the name of an existing schema in the database.
Action: Recheck the name, and call the procedure again using an existing schema name.
ORA-31423: change table string does not contain column string
Cause: Issued ALTER_CHANGE_TABLE with a drop operation and the specified column does not exist in the change table.
Action: Recheck the names, and call the procedure again.
ORA-31424: change table has active subscriptions
Cause: The change table is subscribed to, so it cannot be dropped.
Action: Do not drop a change table while there are active subscribers. If this is an emergency, use the FORCE parameter. This will forcibly drop the change table out from under all subscribers.
ORA-31425: subscription does not exist
Cause: The subscription either did not exist or did not belong to this user.
Action: Call the function again with a valid subscription name.
ORA-31426: cannot modify active subscriptions
Cause: The subscription was already activated so that additional calls to SUBSCRIBE were prohibited.
Action: Subscribe to all the desired tables and columns before activating the subscription. Ensure that the correct subscription name is specifed.
ORA-31427: publication string already subscribed
Cause: The subscription already contained this publication.
Action: Check the values of subscription_name and publication_id. Check any other subscribe calls to see if they subscribe to columns that are shared among more than one publication on the same source table. Do not attempt to subscribe to the same publication more than once in the same subscription. Use the publication_id variant of the SUBSCRIBE call if needed to specify precise publications.
ORA-31428: no publication contains all the specified columns
Cause: One or more of the specifed columns cannot be found in a single publication.
Action: Change the subscription request to select only columns that are in the same publication. Consult the USER_PUBLISHED_COLUMNS view to see current publications.
ORA-31429: subscription has not been activated
Cause: The called procedure required an activated subscription.
Action: Check the subscription name and correct if necessary. Call the ACTIVATE_SUBSCRIPTION procedure for this subscription and then reissue the original command.
ORA-31430: subscriber view exists
Cause: A view that is already in use was specified for the subscriber view.
Action: Call the SUBSCRIBE procedure using a different subscriber view name.
ORA-31431: all source tables must belong to the synchronous change set
Cause: Not all of the source tables belong to the synchronous change set.
Action: Check the spelling of the source tables. Make sure that all of the source tables belong to the synchronous change set.
ORA-31432: invalid source table
Cause: Either the schema_name.source_table did not exist or it did not belong to this subscription.
Action: Check the spelling of the schema_name and source_table. Verify that the specifed table exists in the specifed schema and is subscribed to by the subscription.
ORA-31433: subscriber view does not exist
Cause: The subscription did not contain this subscriber view.
Action: Recheck the name, and specify the name of an existing subscriber view.
ORA-31434: purge is currently running
Cause: Called the PURGE procedure while a purge job was currently running.
Action: Wait for purge to complete before reissueing this command.
ORA-31435: an error occurred during the purge operation
Cause: An error occurred during the purge operation
Action: Check the logfile for a more detailed report of the underlying errors.
ORA-31436: duplicate change source string
Cause: A change source by the specifed name already exists.
Action: Recreate the change source with a unique name.
ORA-31437: duplicate change set string
Cause: A change set by the specified name already exists.
Action: Recreate the change set with a unique name.
ORA-31438: duplicate change table string
Cause: A change table by the specified name already exists.
Action: Recreate the change table with a unique name.
ORA-31439: subscription is already active
Cause: The subscription is already active.
Action: Check name and retry.
ORA-31440: change set string is empty and cannot be advanced
Cause: User attempted to advance a change set which does not contain any change tables. Without change tables, a change set cannot be advanced.
Action: Create change tables in the change set, then retry the advance.
ORA-31441: table is not a change table
Cause: User attempted to execute the DROP_CHANGE_TABLE procedure on a table that is not a CHANGE table. This can also occur when a CHANGE table object has been orphaned. CHANGE tables can become orphaned after a CREATE_CHANGE_TABLE failure or an incomplete DROP_CHANGE_TABLE.
Action: Check spelling. If error was due to an incorrect name, then retry the procedure using the correct name. To drop a table that is not a CHANGE table, or an orphaned CHANGE table, use the DROP TABLE DDL command instead.
ORA-31442: operation timed out while acquiring lock on string
Cause: CDC attempted to acquire a lock on the resource, but the operation timed out.
Action: Retry the operation later.
ORA-31443: deadlock detected while acquiring lock on string
Cause: CDC attempted to acquire a lock on the resource, but encountered a deadlock.
Action: Contact Oracle corporation
ORA-31444: parameter error while acquiring lock on string
Cause: CDC attempted to acquire a lock on the resource, but encountered a problem passing parameters to the lock manager.
Action: Contact Oracle corporation
ORA-31445: invalid lock handle while acquiring lock on string
Cause: CDC attempted to acquire a lock on the resource, but encountered a invalid lock handle, which did not correspond to any existing handle.
Action: Contact Oracle corporation
ORA-31446: this session does not own the lock handle for string
Cause: CDC attempted to acquire a lock on the resource, does not own the the lock associated with the lock. This is an internal error.
Action: Contact Oracle corporation
ORA-31447: cannot create change tables in the SYS schema
Cause: Attempted to create a change table in the SYS schema. This is not allowed.
Action: Use a different existing schema and retry the command.
ORA-31448: invalid value for change_source
Cause: The specified value was not a valid name for a Change Source.
Action: Specify a valid name and retry the command.
ORA-31449: invalid value for change_set_name
Cause: The specified value was not a valid name for a Change Set.
Action: Specify a valid name and retry the command.
ORA-31450: invalid value for change_table_name
Cause: The specified value was not a valid name for a Change Table.
Action: Specify a valid name and retry the command.
ORA-31451: invalid value string for capture_values, expecting: OLD, NEW, or BOTH
Cause: The specified value was not a valid option for a capture_values.
Action: Specify a valid option and retry the command.
ORA-31452: invalid value string for parameter, expecting: Y or N
Cause: The specified value was not Y or N.
Action: Specify Y or N for the parameter and retry the command.
ORA-31453: invalid value string for parameter, expecting: Y, N, or NULL
Cause: The specified value was not Y, N or NULL.
Action: Specify Y, N or NULL for the parameter and retry the command.
ORA-31454: invalid value string for operation parameter, expecting: ADD or DROP
Cause: The specified value was not ADD or DROP.
Action: Specify ADD or DROP and retry the command.
ORA-31455: nothing to ALTER
Cause: The specified column list is NULL and all optional control columns are 'N'.
Action: Specify one or more columns to ALTER.
ORA-31456: error executing a procedure in the DBMS_CDC_UTILITY package
Cause: An internal attempt to invoke a procedure within the DBMS_CDC_UTILITY package failed.
Action: Check the trace logs for more information. Ensure that the package has been installed successfully. Try issuing a DESCRIBE command from SQL on the package. If it fails, then try reinstalling the package. If it succeeds then try invoking one of the procedures from SQL.
ORA-31457: maximum length of description field exceeded
Cause: The maximum number of characters permitted in the description field was exceeded.
Action: The maximum length of the description field is 30 characters. Ensure the length does not exceed this value and retry the command.
ORA-31458: an internal error occurred
Cause: This is an internal error.
Action: Contact Oracle Worldwide Customer Support and report the error.
ORA-31459: system triggers for DBMS_CDC_PUBLISH package are not installed
Cause: One or more required system triggers are not installed. These triggers are required for the proper operation of Change Data Capture. Operations on Change tables cannot continue.
Action: Install or reenable the triggers, or reinstall the package.
ORA-31460: logfile location string is not an existing directory
Cause: The directory specification for logfile location for the change source, does not correspond with an existing directory, or the directory was not accessible.
Action: 1. Create the directory if it does not exist. If the directory does exist, change the file system permissions so the directory can be accessed. OR 2. perform ALTER CHANGE SOURCE and change the logfile_location to be an existing directory that contains the logfiles
ORA-31461: logfile location string contains no files that match pattern string
Cause: The directory specification for logfile location for the change source, does not contain any files whose names pattern-match the logfile_suffix.
Action: 1. Make sure that the logfile location contains logfiles whose names match the logfile_suffix pattern for the change set. OR 2. perform ALTER CHANGE SOURCE and change the logfile_suffix such that it matches the names of existing logfiles in the directory
ORA-31462: internal error while accessing metadata
Cause: An unexpected internal error occurred while CDC was accessing its internal Metadata.
Action: Contact Oracle Corporation
ORA-31463: logfile location string is an empty directory
Cause: The directory specification for logfile location for the change source, is an empty directory
Action: 1. Make sure it is the correct location of the logfiles. If it is, make sure the directory contains logfiles. OR 2. perform ALTER CHANGE SOURCE and change the logfile_location to be an existing directory that contains the logfiles
ORA-31464: target table for the change table no longer exists
Cause: User tried to drop a change table but its underlying storage table (that contains the change data) has been dropped.
Action: Contact Oracle Corporation
ORA-31465: cannot obtain a lock on the subscription
Cause: A timeout occurred while trying to place a lock on the subscription. Another session had already acquired the lock on the subscription.
Action: Ensure the subscription name is correct and correct it if necessary. If it is already correct, try the operation again after the session holding the lock has released it.
ORA-31466: no publications found
Cause: Did not find any publications that matched the input parameters or the user does not have the privileges to access the specified publication.
Action: Check the input parameters on the call to SUBSCRIBE. Validate that the proposed source table has been published by checking the USER_PUBLICATIONS view for that source table. Contact the publisher if user privileges are required to access the publication. Retry the command with correct security or publication information.
ORA-31467: no column found in the source table
Cause: The OBJECT_ID flag was set to 'Y' on the call to CREATE_CHANGE_TABLE and change table belongs to the synchronous change set. The corresponding object column was not detected in the source table.
Action: Create the change table with the OBJECT_ID flag set to 'N' or investigate why the object column is not in the source table and add it to the source table.
ORA-31468: cannot process DDL change record
Cause: The change set has stop_on_ddl enabled and was trying to process a DDL change record.
Action: Check the alert log to find out what the DDL record contained. Make any necessary changes to the change tables. Call ALTER_CHANGE_SET with recover_after_error and remove_ddl set to 'Y'.
ORA-31469: cannot enable Change Data Capture for change set string
Cause: The change set has reached the specified limit that was set up by the CREATE_CHANGE_SET command.
Action: Check the alert log to find out whether capture, apply or both reached the limit. Once apply reaches its limit, the change set is permanently disabled. Create a new change set with new limits to continue capturing data.
ORA-31470: asynchronous change tables must contain the RSID$ column
Cause: If creating an asynchronous change table, the RSID was set to 'N'. If altering an asynchronous change table with an operation parameter of 'DROP' RSID was set to 'Y'.
Action: When creating asynchronous change tables, always specify 'Y' for the RSID parameter. When altering asynchronous change tables always specify 'N' for RSID.
ORA-31471: invalid OBJECT_ID value
Cause: An object_id value of 'y' was specified for an asynchronous change table.
Action: Specify an object_id parameter value of 'n' and call the procedure again.
ORA-31472: Importing Change Data Capture version string.string is too new
Cause: An attempt was made to Import a file that was exported by a newer version of Oracle than the target instance.
Action: If possible, re-export the file using a version of export that matches the import target. Objects can not be imported into previous versions of Oracle that did not support them.
ORA-31475: redo log catalog contains no metadata for the source table
Cause: While advancing a change set, an CDC attempted to query the LogMiner dictionary system tables to obtain the columns from the source table. The query returned no rows. This may be because none of the redo logs contains a catalog, or it may be an internal error.
Action: First, verify that the source system contains the source table. execute dbms_logmnr_d.build procedure to populate the redos log with logminer dictionary information. If this has been done and the problem persists, then contact Oracle Corporation
ORA-31476: a change table data column is missing from the source table
Cause: While advancing a change set, an CDC determined that at least one of the data columns in a change table does not match the name of any of the columns in the source table. The source table column listis stored in dictionary table SYSTEM.LOGMNR_OBJ$
Action: Make sure that all of the data columns of the change table have the same names as the corresponding columns in the source table, and that all the columns exist in the source table.
ORA-31477: could not detach LogMiner session during cleanup
Cause: Failure during detach from a LogMiner session during advance of an asynchronous change set. This is an internal error. This exception is raised when a previous exception occurred during the internal protocol with LogMiner, after which Change Data Capture attempted to detach the LogMiner session as part of recovery. The detach session also failed
Action: Contact Oracle Corporation
ORA-31478: could not detach LogMiner session after change set advance
Cause: Failure during detach from a LogMiner session after successful advance of an asynchronous change set. This is an internal error. This exception is raised when an asynchronous change set has been successfully advanced but CDC was unable to detach from the LogMiner session
Action: Contact Oracle Corporation
ORA-31479: could not create LogMiner session
Cause: Failure during create of a new LogMiner session while advancing an asynchronous change set. This is an internal error.
Action: Contact Oracle Corporation
ORA-31490: could not attach to LogMiner session
Cause: Failure during attach to a LogMiner session while advancing an asynchronous change set. This is an internal error.
Action: Contact Oracle Corporation
ORA-31491: could not add logfile to LogMiner session
Cause: Failure during add logfile to a LogMiner session while advancing an asynchronous change set. This is an internal error.
Action: Contact Oracle Corporation
ORA-31492: could not set session parameters for LogMiner session
Cause: Failure during set parameters for a LogMiner session while advancing an asynchronous change set. This is an internal error.
Action: Contact Oracle Corporation
ORA-31493: could not prepare session for LogMiner session
Cause: Failure during prepare session for a LogMiner session while advancing an asynchronous change set. This is an internal error.
Action: Contact Oracle Corporation
ORA-31494: could not activate a LogMiner session
Cause: Failure during activation of a LogMiner session while advancing an asynchronous change set. This is an internal error.
Action: Contact Oracle Corporation
ORA-31495: error in synchronous change table on "string"."string"
Cause: There was an error originating from this synchronous change table. One possible cause is that schema redefinition has occurred on the source table and one or more columns in the change table are now a different type than corresponding source columns. Another possible cause is that there is a problem accessing the synchronous change table.
Action: Check further error messages in stack for more detail about the cause. If there has been schema redefinition, drop and recreate the synchronous change table.
ORA-31496: must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to drop change tables
Cause: An attempt was made to use the SQL command DROP TABLE for change tables, but DROP TABLE is not supported for change tables.
Action: Use the DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE procedure instead of the DROP TABLE command.
ORA-31497: invalid value specified for first_scn
Cause: The first_scn was not greater than zero or was less than the previous value of first_scn.
Action: Check the value of first_scn. Correct it to make sure it is an integer greater than zero and greater than any previous value for this change source.
ORA-31498: description and remove_description cannot both be specified
Cause: The description and remove_description parameters were both specified.
Action: Check the values of description and remove_description. Correct call to only supply one of these values.
ORA-31499: null value specified for required parameter string
Cause: A null value was specified for a parameter that requires an explicit value.
Action: Correct call to supply a value for this parameter.
ORA-31500: change source string is not a ManualLog change source
Cause: A change source was specified that is not a ManualLog change source, but a ManualLog change source is required.
Action: Correct call to supply a ManualLog change source.
(责任编辑:eric)
织梦二维码生成器
顶一下
(0)
0%
踩一下
(0)
0%
------分隔线----------------------------
发表评论
请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
评价:
表情:
用户名: 验证码:点击我更换图片
栏目列表
推荐内容