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

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

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

Oracle 10g errors message troubleshooting 195

时间:2011-04-17 12:03来源:Oracle 作者:admin 点击:
ORA-32058: operation restricted to SYSDBA users Cause: Operation requires SYSDBA priviliges. Action: Connect to the database as SYSDBA.

 

ORA-32001: write to SPFILE requested but no SPFILE specified at startup
Cause: An alter system command or an internal self tuning mechanism requested a write to the SPFILE but no SPFILE was used to startup the instance
Action: Create an SPFILE and re-start the instance using the SPFILE.
ORA-32002: cannot create SPFILE already being used by the instance
Cause: A create spfile command is trying to write to an SPFILE that was used to startup the instance.
Action: Specify a different SPFILE name
ORA-32003: error occured processing parameter 'string'
Cause: An error occured while parsing the parameter file.
Action: See additional errors to determine the root cause.
ORA-32004: obsolete and/or deprecated parameter(s) specified
Cause: One or more obsolete and/or parameters were specified in the SPFILE or the PFILE on the server side.
Action: See alert log for a list of parameters that are obsolete. or deprecated. Remove them from the SPFILE or the server side PFILE.
ORA-32005: error while parsing size specification [string]
Cause: The value specified for an alter operation on a size parameter is not valid
Action: Correct the value and retry the operation
ORA-32006: %s initialization parameter has been deprecated
Cause: A deprecated parmeter was specified at startup
Action: Consult Oracle documentation to find new parameters to use instead.
ORA-32007: internal
Cause: A parameter error occured.
Action: Call Oracle support.
ORA-32008: error while processing parameter update at instance string
Cause: An error occured while processing a parameter on a remote instance.
Action: See accompanying error messages.
ORA-32009: cannot reset the memory value for instance string from instance string
Cause: Memory resets of local parameters are only allowed.
Action: Retry the query for the local instance if needed.
ORA-32010: cannot find entry to delete in SPFILE
Cause: The SPFILE did not contain the sid.parameter entry.
Action: Change the sid and/or the parameter.
ORA-32011: cannot restore SPFILE to location already being used by the instance
Cause: A restore operation trying to write to an SPFILE that was used to startup the instance.
Action: Specify a different SPFILE name
ORA-32012: failure in processing system parameters from restored SPFILE
Cause: Failure during processing of parameters from restored SPFILE
Action: Further diagnostic information should be in the error stack.
ORA-32013: failure in verifying parameters from the restored SPFILE
Cause: Failure during processing of parameters from restored SPFILE. It could be that restore image of the SPFILE is corrupted.
Action: Further diagnostic information should be in the error stack.
ORA-32014: error processing parameter "string" from the SPFILE restore image
Cause: Failure during processing of parameters from restored SPFILE. It could be that restore image of the SPFILE is corrupted.
Action: Further diagnostic information should be in the error stack.
ORA-32015: unable to restore SPFILE
Cause: Failure during SPFILE restore. It could be that the restore destination is not valid.
Action: Further diagnostic information should be in the error stack.
ORA-32016: parameter "string" cannot be updated in SPFILE
Cause: Database is mounted.
Action: Unmount the database to update the parameter in the SPFILE
ORA-32017: failure in updating SPFILE
Cause: A failure occured while updating the SPFILE.
Action: See associated errors.
ORA-32018: parameter cannot be modified in memory on another instance
Cause: Parameter adjustment can take a very long time
Action: Modify the parameter individually on each instance using the SID clause of the alter system command
ORA-32019: The parameter SPFILE cannot be updated in the server parameter file.
Cause: An attempt was made to update the parameter SPFILE in the server parameter file.
Action: Convert the server parameter file into a parameter file and then add the parameters needed and recreate the server parameter file.
ORA-32020: SID=* clause needed to modify this parameter
Cause: The parameter did not have the same value on all RAC instances.
Action: Retry the command by specifying SID=*
ORA-32021: parameter value longer than string characters
Cause: An attempt was made to alter a parameter value but the number of characters in the parameter value was longer than the allowed maximum. For a list parameter, one of the values in the list was longer than the allowed maximum.
Action: Reduce the parameter value length and retry the command. For the DISPATCHERS parameter, use listener aliases to reduce value length.
ORA-32022: parameter value longer than string characters
Cause: An attempt was made to alter a parameter value but the combined length of all the parameter values was more than the allowed maximum.
Action: Reduce the parameter value length and retry the command. For the DISPATCHERS parameter, use listener aliases to reduce value length.
ORA-32024: invalid directory specified for audit_file_dest parameter
Cause: Either the directory does not exist or it is not writable.
Action: Retry the command by specifying a valid directory or granting appropriate directory permissions.
ORA-32025: %s.string is not a table or view object.
Cause: An attempt was made to set the audit table to a non-table object or a non-view object.
Action: Specify a valid table or view object for the audit table option.
ORA-32026: %s.string has fewer columns compared to string table.
Cause: An attempt was made to set the audit table to a table or view object that has fewer columns compared to the base audit table.
Action: Specify a valid table or view object for the audit table option.
ORA-32027: There is no string column with the matching type in string.string.
Cause: An attempt was made to set the audit table to a table or view object that does not have a column with the same name and type as the one in the audit table.
Action: Specify a valid table or view object for the audit table option.
ORA-32031: illegal reference of a query name in WITH clause
Cause: forward or recursive reference of a query name in WITH clause is not allowed.
Action: Correct query statement, then retry.
ORA-32032: free temporary object number not available
Cause: Too many queries using temp table transformation are currently being run to use up all temporay object numbers.
Action: Turn off temporary table transformation or wait, then retry
ORA-32033: unsupported column aliasing
Cause: column aliasing in WITH clause is not supported yet
Action: specify aliasing in defintion subquery and retry
ORA-32034: unsupported use of WITH clause
Cause: Inproper use of WITH clause because one of the following two reasons:

1. nesting of WITH clause within WITH clause not supported yet

2. For a set query, WITH clause can't be specified for a branch.

3. WITH clause can't sepecified within parentheses.

Action: correct query and retry
ORA-32035: unreferenced query name defined in WITH clause
Cause: There is at least one WITH clause query name that is not referenced in any place.
Action: remove the unreferenced query name and retry
ORA-32036: unsupported case for inlining of query name in WITH clause
Cause: There is at least one query name which is inlined more than once because it's definition query is too simple and references another query name. This is currently unsupported yet.
Action: remove such query name and retry
ORA-32037: unsupported use of LEVEL in membership condition
Cause: An attempt was made to use LEVEL in membership condition with subquery that is not supported.
Action: Rewrite query to avoid using LEVEL in membership condition
ORA-32050: %s operation failed
Cause: A mapping operation failed.
Action: Check FMON trace files for errors.
ORA-32051: mapping service not available
Cause: The mapping service was never started or previously failed to start properly.
Action: Set FILE_MAPPING to TRUE if it is not currently set. Otherwise, check FMON trace files for an ORA-32052 error.
ORA-32052: failed to start mapping service
Cause: The mapping service failed to start properly.
Action: Check FMON trace files for errors.
ORA-32053: operation not supported
Cause: Mapping libraries do not support operation.
Action: Check whether mapping libraries are available and whether operation is supported by the libraries.
ORA-32054: lost communication with FMPUTL process
Cause: Lost communication with mapping utility.
Action: Check FMON and FMPUTL trace files for errors.
ORA-32055: invalid file type
Cause: Invalid file type used when mapping files.
Action: Specify one of expected file types.
ORA-32056: invalid number of extents
Cause: Invalid number of extents used for map operation.
Action: Specify a non-negative number of extents.
ORA-32057: invalid lock mode
Cause: An invalid mode was used for a lock operation.
Action: Specify one of expected lock modes.
ORA-32058: operation restricted to SYSDBA users
Cause: Operation requires SYSDBA priviliges.
Action: Connect to the database as SYSDBA.
ORA-32059: deadlock detected on mapping structures
Cause: Mapping structures already locked by the same session.
Action: Unlock mapping structures before proceeding with current operation.
ORA-32060: channel failure
Cause: Channel failure between foreground and background process.
Action: Check foreground trace files for errors.
ORA-32100: operation invalid on transient object
Cause: Trying to perform an operation on transient object which is is valid only on persistent objects
Action: Make sure object is persistent
(责任编辑:eric)
织梦二维码生成器
顶一下
(0)
0%
踩一下
(0)
0%
------分隔线----------------------------
发表评论
请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
评价:
表情:
用户名: 验证码:点击我更换图片
栏目列表
推荐内容