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

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

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

Oracle 10g errors message troubleshooting 194

时间:2011-04-17 12:00来源:Oracle 作者:admin 点击:
ORA-31695: Inconsistent master table on restart. The following SQL statement returned string identical objects. string Cause: Master table on restart has the same object inserted multiple times. Action: Restart not possible, reissue origi

 

ORA-31601: Function string cannot be called now that fetch has begun.
Cause: The function was called after the first call to FETCH_xxx.
Action: Correct the program.
ORA-31602: parameter string value "string" in function string inconsistent with string
Cause: The parameter value is inconsistent with another value specified by the program. It may be inconsistent with the object type associated with the OPEN context, or it may be of the wrong datatype (a boolean rather than a text string or vice versa).
Action: Correct the program
ORA-31603: object "string" of type string not found in schema "string"
Cause: The specified object was not found in the database.
Action: Correct the object specification and try the call again.
ORA-31604: invalid string parameter "string" for object type string in function string
Cause: The specified parameter value is not valid for this object type.
Action: Correct the parameter and try the call again.
ORA-31605: the following was returned from string in routine string: LPX-numberstring
Cause: An LPX routine (XML/XSL processing) returned an internal error number to its PL/SQL wrapper routine in facility KUX which provides the implementation for package UTL_XML.
Action: Look up the LPX error number and follow its corrective action.
ORA-31606: XML context number does not match any previously allocated context
Cause: A method in package UTL_XML was called with an invalid XML context handle. All handles must have previously been allocated by UTL_XML.XMLINIT.
Action: Always call XMLINIT before any other methods in pkg. UTL_XML.
ORA-31607: function string is inconsistent with transform.
Cause: Either (1) FETCH_XML was called when the "DDL" transform was specified, or (2) FETCH_DDL was called when the "DDL" transform was omitted.
Action: Correct the program.
ORA-31608: specified object of type string not found
Cause: The specified object was not found in the database.
Action: Correct the object specification and try the call again.
ORA-31609: error loading file "string" from file system directory "string"
Cause: The installation script initmeta.sql failed to load the named file from the file system directory into the database.
Action: Examine the directory and see if the file is present and can be read.
ORA-31610: cannot call this function from a non-master process
Cause: Called a Data Pump process model function from a process which is not a master process.
Action: Create a master process first. Then call the function from the master process. If this error occurs from a Data Pump client (e.g. expdp or impdp), try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31612: Allocation of process descriptor failed.
Cause: During creation of a master process or a worker process, a failure occurred allocating a process descriptor for the process.
Action: Try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31613: Master process string failed during startup.
Cause: The master process whose name is listed failed during startup.
Action: Refer to any following error messages for possible actions. Check the trace log for the failed process to see if there is any information about the failure. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31614: routine string received this error from stringstring
Cause: The call to the specified routine failed and the specific error text is included in this error message (the last %s string).
Action: Correct inputs to the specified routine.
ORA-31615: routine string received this error: string
Cause: The specified routine failed and the specific error text is included in this error message (the last %s string).
Action: Correct inputs to the specified routine.
ORA-31616: unable to write to dump file "string"
Cause: Export was unable to write to the export file, probably because of a device error. This message is usually followed by a device message from the operating system.
Action: Take appropriate action to restore the device.
ORA-31617: unable to open dump file "string" for write
Cause: Export was unable to open the export file for writing. This message is usually followed by device messages from the operating system.
Action: Take appropriate action to restore the device.
ORA-31618: dump file size too small
Cause: The value specified for the FILESIZE parameter or the VOLUMESIZE parameter was too small to hold the header information for the export file, plus any data.
Action: Increase the value of the FILESIZE or VOLUMESIZE parameter.
ORA-31619: invalid dump file "string"
Cause: Either the file was not generated by Export or it was corrupted.
Action: If the file was indeed generated by Export, report this as an Import bug and submit the export file to Oracle Customer Support.
ORA-31620: file or device "string" cannot be specified for string operation
Cause: There was an inappropriate use of file or device in the current operation.
Action: Correct operation or job setup.
ORA-31621: error creating master process
Cause: Setup to create a master process failed.
Action: Refer to any following error messages for possible actions. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31622: ORACLE server does not have string access to the specified file
Cause: An attempt was made to read or write files within protected directories.
Action: Correct the file/directory permissions and try the call again.
ORA-31623: a job is not attached to this session via the specified handle
Cause: An attempt to reference a job using a handle which is invalid or no longer valid for the current session.
Action: Select a handle corresponding to a valid active job or start a new job.
ORA-31624: operation string not allowed when job in string state
Cause: The user requested an invalid operation given the current job state.
Action: Verify the state before executing this operation.
ORA-31625: error changing username from string to string
Cause: An error occurred when attempting to change the username.
Action: Refer to any following error messages for possible actions. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31626: job does not exist
Cause: An invalid reference to a job which is no longer executing, is not executing on the instance where the operation was attempted, or that does not have a valid Master Table. Refer to any following error messages for clarification.
Action: Start a new job, or attach to an existing job that has a valid Master Table.
ORA-31627: API call succeeded but more information is available
Cause: The user specified job parameters that yielded informational messages.
Action: Call DBMS_DATAPUMP.GET_STATUS to retrieve additional information.
ORA-31628: error getting worker process exception
Cause: Attempt to get a worker process exception failed.
Action: Refer to any following error messages for possible actions. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31629: unable to allocate additional memory
Cause: A dynamic memory allocation failure occurred.
Action: Report this problem to a database administrator.
ORA-31630: a job name is required to attach a job for user string
Cause: No job name was supplied for an attach and the user has either no jobs executing or mutiple jobs executing.
Action: Provide a job name for attach to use in selecting an executing job, or to use for restarting a stopped job.
ORA-31631: privileges are required
Cause: The necessary privileges are not available for operations such as: restarting a job on behalf of another owner, using a device as a member of the dump file set, or ommiting a directory object associated with any of the various output files. Refer to any following error messages for additional information.
Action: Select a different job to restart, try a different operation, or contact a database administrator to acquire the needed privileges.
ORA-31632: master table "string.string" not found, invalid, or inaccessible
Cause: A Master Table is required but no such table exists, or the content is not consistent with that of a valid Master Table, or the table is not accessible. Refer to any following error messages for clarification.
Action: Make sure a valid Master Table exists, and eliminate any problems indicated by the following error messages.
ORA-31633: unable to create master table "string.string"
Cause: Job creation failed because a Master Table and its indexes could not be created, most commonly due to the pre-existance of a table with the same name (job name) in the user schema. Refer to any following error messages for clarification.
Action: Select a different job name, DROP the existing table, or eliminate any problems indicated by the following error messages.
ORA-31634: job already exists
Cause: Job creation or restart failed because a job having the selected name is currently executing. This also generally indicates that a Master Table with that job name exists in the user schema. Refer to any following error messages for clarification.
Action: Select a different job name, or stop the currently executing job and re-try the operation (may require a DROP on the Master Table).
ORA-31635: unable to establish job resource synchronization
Cause: A lock used in synchronizing Data Pump resources during job creation and deletion could not be obtained during job creation. This indicates that a process for some other Data Pump job has not released the lock due to an internal error.
Action: Eliminate the processes for any failed Data Pump job and try to create the new job again. If the error continues to occur, contact Oracle Customer Support and report the error.
ORA-31636: session is already attached to job string for user string
Cause: The session executing the attach is already attached to the specified job.
Action: Select a different job or create a new session.
ORA-31637: cannot create job string for user string
Cause: Unable to create or restart a job. Refer to any following or prior error messages for clarification.
Action: Eliminate the problems indicated.
ORA-31638: cannot attach to job string for user string
Cause: Unable to attach a job to a session. Refer to any following or prior error messages for clarification.
Action: Eliminate the problems indicated.
ORA-31639: unexpected data found
Cause: The Master Table or Data Pump file contents appear invalid. The table or file may not have been produced by a Data Pump job, or they may have been corrupted.
Action: Select a different job name (Master Table) or replace the table or file with one produced by Data Pump.
ORA-31640: unable to open dump file "string" for read
Cause: Import was unable to open the export file for reading. This message is usually followed by device messages from the operating system.
Action: Take appropriate action to restore the device.
ORA-31641: unable to create dump file "string"
Cause: Export was unable to create the specified file with write enabled.
Action: Check the file name and file system for the source of the error.
ORA-31642: the following SQL statement fails: string
Cause: An internal error was generated from package DBMS_METADATA.
Action: Contact Oracle Customer Support and report the error.
ORA-31643: unable to close dump file "string"
Cause: Export or Import was unable to close the dump file. This message is usually followed by device messages from the operating system.
Action: Take appropriate action to restore the device.
ORA-31644: unable to position to block number string in dump file "string"
Cause: Export or Import was unable to position its file pointer to a specific block within the dump file. This message is usually followed by device messages from the operating system.
Action: Take appropriate action based on the device messages.
ORA-31645: unable to read from dump file "string"
Cause: Import could not read from the dumpfile, probably because of a device error. This message is usually followed by a device message from the operating system.
Action: Take appropriate action to restore the device.
ORA-31648: Timeout before master process string finished initialization.
Cause: The master process whose name is listed started up but did not finish its initialization within the allowed time limit.
Action: Refer to any following error messages for possible actions. Check the trace log for the failed process to see if there is any information about the failure. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31649: Master process string violated startup protocol.
Cause: The master process whose name is listed started up but then exited before notifying the creating process that it was finished with initialization.
Action: Refer to any following error messages for possible actions. Check the trace log for the failed process to see if there is any information about the failure. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31650: timeout waiting for master process response
Cause: After creating the job infrastructure and sending the initial message to the master process, it failed to respond in the allotted time and most likely aborted during startup.
Action: Retry the open or attach request. Contact Oracle Customer Support if the problem persists.
ORA-31651: communication error with master process - detaching job
Cause: Unexpected failure trying to communicate with the master process.
Action: Attach again and retry operation. Contact Oracle Customer Support if the problem persists.
ORA-31652: command response message was invalid type - detaching job
Cause: Something horribly wrong with the command/response protocol.
Action: Reattach and retry operation. Contact Oracle Customer Support if the problem persists.
ORA-31653: unable to determine job operation for privilege check
Cause: Failure trying to determine the operation of the current job in order to test for appropriate privileges.
Action: Retry in case it's an intermittent failure. If it still fails, detach, reattach, and retry the call. Contact Oracle Customer Support if the problem persists.
ORA-31654: unable to convert file or volume size as specified to a number
Cause: File or volume size specification has an error the prevents it from being converted into a numeric value.
Action: Fix the call.
ORA-31655: no data or metadata objects selected for job
Cause: After the job parameters and filters were applied, the job specified by the user did not reference any objects.
Action: Verify that the mode of the job specified objects to be moved. For command line clients, verify that the INCLUDE, EXCLUDE and CONTENT parameters were correctly set. For DBMS_DATAPUMP API users, verify that the metadata filters, data filters, and parameters that were supplied on the job were correctly set.
ORA-31656: cannot use TABLESPACE_EXPR filter with transportable mode
Cause: A TABLESPACE_EXPR metadata filter was supplied for for a transportable mode import job. Transportable mode import does not support the subsetting of tablespaces from a dump file set.
Action: Remove the filter expression.
ORA-31657: data filter name can not be defaulted
Cause: A null data filter name was supplied.
Action: Fix the call to specify a data filter name.
ORA-31658: specifying a schema name requires a table name
Cause: The caller specified a schema name but neglected to specify a corresponding table name.
Action: Fix the call to include a table name.
ORA-31659: status message was invalid type - detaching job
Cause: Message from the master process on the status queue had an invalid message type, indicating a failure in the protocol.
Action: Reattach and retry the operation. Contact Oracle Customer Support if the problem persists.
ORA-31660: metadata filter name can not be defaulted
Cause: A null metadata filter name was supplied.
Action: Fix the call to specify a metadata filter name.
ORA-31661: there are no metadata transform values of type VARCHAR2
Cause: The specified metadata transform value was an invalid type.
Action: Fix the call to specify a valid metadata transform value.
ORA-31662: metadata transform name can not be defaulted
Cause: A null metadata transform name was supplied.
Action: Fix the call to specify a metadata transform name.
ORA-31663: metadata remap name can not be defaulted
Cause: A null metadata remap name was supplied.
Action: Fix the call to specify a metadata remap name.
ORA-31664: unable to construct unique job name when defaulted
Cause: The job name was defaulted, and the name creation algorithm was unable to find a unique job name for this schema where the table name (for the master table) didn't already exist.
Action: Specify a job name to use or delete some of the existing tables causing the name conflicts.
ORA-31665: mode can only be defaulted for IMPORT and SQL_FILE operations
Cause: The job mode can not be null except for IMPORT and SQL_FILE operations.
Action: Fix the call to specify the job mode.
ORA-31666: Master process string had an unhandled exception.
Cause: A Data Pump process model master process had an unhandled exception condition.
Action: Refer to any following error messages for possible actions. Check the trace log for the failed process to see if there is any information about the failure. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31667: parameter name can not be defaulted
Cause: A null was supplied for the parameter name.
Action: Fix the call by providing a valid parameter name.
ORA-31668: Timeout before worker process string finished initialization.
Cause: The worker process whose name is listed started up but did not finish its initialization within the allowed time limit.
Action: Refer to any following error messages for possible actions. Check the trace log for the failed process to see if there is any information about the failure. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31669: Worker process string violated startup protocol.
Cause: The worker process whose name is listed started up but then exited before notifying the creating process that it was finished with initialization.
Action: Refer to any following error messages for possible actions. Check the trace log for the failed process to see if there is any information about the failure. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31670: Username argument must be specified and non-null.
Cause: Called change user with a NULL username or a null string.
Action: Specify a valid username argument. If this error occurs from a Data Pump client (e.g. expdp or impdp), try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31671: Worker process string had an unhandled exception.
Cause: A Data Pump process model worker process had an unhandled exception condition.
Action: Refer to any following error messages for possible actions. Check the trace log for the failed process to see if there is any information about the failure. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31672: Worker process string died unexpectedly.
Cause: A Data Pump process model worker process died unexpectedly, so PMON is cleaning up the process.
Action: Check your system for problems. Check the trace file for the process, if one was created, for any additional information. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31673: worker process interrupt for normal exit by master process
Cause: A worker process was requested to clean up and exit because the master process is doing a normal exit.
Action: If this error occurs from a Data Pump client (e.g. expdp or impdp). it means that the master process for the operation exited prematurely. Try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31674: worker process interrupt for unhandled exception in master process
Cause: A worker process was requested to clean up and exit because an unhandled exception occurred in the master process.
Action: If this error occurs from a Data Pump client (e.g. expdp or impdp), it means that the master process for the operation had an unhandled exception. Check the log file for the operaton and the trace file for the master process for any additional information. Try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31675: worker process interrupt for unexpected death of master process
Cause: A worker process was requested to clean up and exit (signaled by PMON, doing cleanup because the master process died unexpectedly).
Action: If this error occurs from a Data Pump client (e.g. expdp or impdp), it means that the master process for the operation died unexpectedly. Check the log file for the operaton and the trace file for the master process for any additional information. Try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31676: illegal value for number of workers, string
Cause: Called create worker processes with an illegal number of workers specified.
Action: Make sure that the number of workers value is greater than 0 and less than the maximum value for the platform (normally 32767). If this error occurs from a Data Pump client (e.g. expdp or impdp) and you specified the parallel parameter, try the operation again with a smaller value for the parallel parameter. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31686: error creating worker processes
Cause: Setup to create worker processes failed.
Action: Refer to any following error messages for possible actions. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31687: error creating worker process string with worker id string
Cause: Attempt to create the listed worker process failed.
Action: Refer to any following error messages for possible actions. Check the trace log for the failed process to see if there is any information about the failure. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31688: Worker process string failed during startup.
Cause: The worker process whose name is listed failed during startup.
Action: Refer to any following error messages for possible actions. Check the trace log for the failed process to see if there is any information about the failure. Correct the error, if possible, and try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31689: illegal value for base worker id, string
Cause: Called create worker processes with an illegal base worker id value specified.
Action: Make sure that the base worker id value is greater than 0 and less than the maximum value for the platform (normally 32767). If this error occurs from a Data Pump client (e.g. expdp or impdp), try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31690: Process name buffer size must be specified and must be greater than 0.
Cause: Called get worker exception and either specified NULL or 0 for the buffer size argument.
Action: Be sure to specify a buffer size that is big enough to hold the worker process name (e.g. 30 bytes). If this error occurs from a Data Pump client (e.g. expdp or impdp), try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31691: The worker received message number string from the MCP, which is invalid.
Cause: Bad code.
Action: Fix mcp code and reissue export/import command.
ORA-31692: The following SQL statement failed trying to insert a row into the Master table: string
Cause: Bad code.
Action: Fix code and reissue export/import command.
ORA-31693: Table data object string failed to load/unload and is being skipped due to error: string
Cause: Table failed to load or unload due to some error.
Action: Check load/unload error, correct problem and retry command.
ORA-31694: master table string failed to load/unload
Cause: Master table failed to load or unload.
Action: Check load/unload error, correct problem and retry command.
ORA-31695: Inconsistent master table on restart. The following SQL statement returned string identical objects. string
Cause: Master table on restart has the same object inserted multiple times.
Action: Restart not possible, reissue original export/import.
ORA-31696: unable to export/import string using client specified string method
Cause: Table attributes prevent client specified method for exporting or importing data.
Action: Use default 'DATA_ACCESS' parameter value.
ORA-31697: aborting operation at process order number string
Cause: User asked for it.
Action: Don't ask for it.
ORA-31698: Error stack buffer size must be specified and must be greater than 0.
Cause: Called get worker exception and either specified NULL or 0 for the error stack size argument.
Action: Be sure to specify am error stack buffer size that is big enough to hold the error stack string (e.g. 4096 bytes). If this error occurs from a Data Pump client (e.g. expdp or impdp), try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-31901: the current operation was cancelled by the user
Cause: The user requested to cancel current operation
Action: No action is necessary
(责任编辑:eric)
织梦二维码生成器
顶一下
(0)
0%
踩一下
(0)
0%
------分隔线----------------------------
发表评论
请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
评价:
表情:
用户名: 验证码:点击我更换图片
栏目列表
推荐内容