ORA-08005: specified row does not exist
Cause: A row with the given rowid does not exist in any of the tables given
Action: check the query for misspellings of table names and the rowid
ORA-08006: specified row no longer exists
Cause: the row has been deleted by another user since the operation began
Action: re-try the operation
ORA-08007: Further changes to this block by this transaction not allowed
Cause: Max locks have been reached for this transaction in this block
Action: Commit changes
ORA-08008: another instance is mounted with USE_ROW_ENQUEUES = string
Cause: the shared instance being started does not have the same value for use_row_enqueues as already running instances
Action: ensure that all instances' INIT.ORA files specify the same value for the parameter 'use_row_enqueues'
ORA-08100: index is not valid - see trace file for diagnostics
Cause: Validate Index detected an inconsistency in its argument index
Action: Send trace file to your customer support representative
ORA-08101: index key does not exist file string: (root string, node string) blocks (string)
Cause: Internal error: possible inconsistency in index
Action: Send trace file to your customer support representative, along with information on reproducing the error
ORA-08102: index key not found, obj# string, file string, block string (string)
Cause: Internal error: possible inconsistency in index
Action: Send trace file to your customer support representative, along with information on reproducing the error
ORA-08103: object no longer exists
Cause: The object has been deleted by another user since the operation began, or a prior incomplete recovery restored the database to a point in time during the deletion of the object.
Action: Delete the object if this is the result of an incomplete recovery.
ORA-08104: this index object string is being online built or rebuilt
Cause: the index is being created or rebuild or waited for recovering from the online (re)build
Action: wait the online index build or recovery to complete
ORA-08105: Oracle event to turn off smon cleanup for online index build
Cause: set this event only under the supervision of Oracle development
Action: debugging only
ORA-08106: cannot create journal table string.string
Cause: The online index builder could not create its journal table
Action: rename your table in conflict or rerun the SQL statement
* there may be a concurrent online index rebuild on the same object.
ORA-08108: may not build or rebuild this type of index online
Cause: only support normal index or IOT top-level index
Action: change your index type
ORA-08109: nosort is not a supported option for online index build
Cause: may not specify nosort for online index build
Action: get rid of nosort in the index creation command
ORA-08110: Oracle event to test SMON cleanup for online index build
Cause: Oracle Kernel test only
Action: Donot set this event(for test only)
ORA-08111: a partitioned index may not be coalesced as a whole
Cause: User attempted to coalesce a partitioned index using ALTER INDEX COALESCE statement, which is illegal
Action: Coalesce the index a (sub)partition at a time (using ALTER INDEX MODIFY (sub)PARTITION COALESCE)
ORA-08112: a composite partition may not be coalesced as a whole
Cause: User attempted to coalesce a composite partition
Action: Coalesce the index a subpartition at a time (using ALTER INDEX MODIFY SUBPARTITION COALESCE)
ORA-08113: composite partition index may not be compressed
Cause: User attempted to compress a composite partition index
Action: create uncompressed composite partition index
ORA-08114: can not alter a fake index
Cause: User attempted to alter a fake index
Action: drop fake index
ORA-08115: can not online create/rebuild this index type
Cause: User attempted to create index type that online doesnot support
Action: use offline index create/rebuild command
ORA-08116: can not acquire dml enough lock(S mode) for online index build
Cause: User attempted to create index online without allowing DML Share lock
Action: allow DML share lock on the base table
ORA-08117: Index Organized Table operation released its block pin
Cause: Block maintenance forced the release of a block pin
Action: Contact your customer support representative
ORA-08118: Deferred FK constraints cannot be enforced, index too big (string)
Cause: Deferred Foreign Key constraints cannot be enforced due to the index key being too big and built on a non-default DB_BLOCK_SIZE.
Action: First try to drop the Foreign Key and then the primary key.
ORA-08119: The new initrans will make the index too big
Cause: Specifying the initrans need additional space to hold the index key which might make the index too big
Action: Try giving a smaller initrans value
ORA-08120: Need to create SYS.IND_ONLINE$ table in order to (re)build index
Cause: Alter index Build/Rebuild online require existing of SYS.IND_ONLINE$ table.
Action: User/DBA needs to create sys.ind_online$ before alter the index /rdbms/admin/catcio.sql contains script to create ind_online$.
ORA-08121: Number of indexes need to be maintained offline exceeds limit for DML
Cause: Too many indexes needed to be maintained. The limit is 2^16 indexes for each DML statement
Action: Make sure the index maintainance is online. If indexes need to be maintained offline, drop some indexes.
ORA-08122: Online (re)build of index rolled back due to DML conflict
Cause: The online (re)build journal is inconsistent with ongoing DML and cannot be used successfully to complete the online index (re)build.
Action: Reissue the online (re)build operation, after performing any cleanup, if needed.
ORA-08175: discrete transaction restriction violated (string)
Cause: An attempt was made to perform an action that is not currently supported in a discrete transaction.
Action: Rollback the transaction, and retry it as a normal transaction.
ORA-08176: consistent read failure; rollback data not available
Cause: Encountered data changed by an operation that does not generate rollback data : create index, direct load or discrete transaction.
Action: In read/write transactions, retry the intended operation. Read only transactions must be restarted.
ORA-08177: can't serialize access for this transaction
Cause: Encountered data changed by an operation that occurred after the start of this serializable transaction.
Action: In read/write transactions, retry the intended operation or transaction.
ORA-08178: illegal SERIALIZABLE clause specified for user INTERNAL
Cause: Serializable mode is not supported for user INTERNAL.
Action: Reconnect as another user and retry the SET TRANSACTION command.
ORA-08179: concurrency check failed
Cause: Encountered data changed by an operation that occurred after a specific snapshot. This is usually used to indicate that a particular cached copy of a datablock is stale. This is used for internal use for now.
Action: refresh the cached copy of the datablock and retry operation.
ORA-08180: no snapshot found based on specified time
Cause: Could not match the time to an SCN from the mapping table.
Action: try using a larger time.
ORA-08181: specified number is not a valid system change number
Cause: supplied scn was beyond the bounds of a valid scn.
Action: use a valid scn.
ORA-08182: operation not supported while in Flashback mode
Cause: user tried to do dml or ddl while in Flashback mode
Action: disable Flashback and re-attempt the operation
ORA-08183: Flashback cannot be enabled in the middle of a transaction
Cause: user tried to do Flashback in the middle of a transaction
Action: do a commit
ORA-08184: attempting to re-enable Flashback while in Flashback mode
Cause: as stated above
Action: disable first before re-enabling
ORA-08185: Flashback not supported for user SYS
Cause: user logged on as SYS
Action: logon as a different (non SYS) user.
ORA-08186: invalid timestamp specified
Cause: as stated above
Action: enter a valid timestamp
ORA-08187: snapshot expression not allowed here
Cause: A snapshot expression using AS OF was specified when not allowed.
Action: Do not use the AS OF clause
ORA-08189: cannot flashback the table because row movement is not enabled
Cause: An attempt was made to perform Flashback Table operation on a table for which row movement has not been enabled. Because the Flashback Table does not preserve the rowids, it is necessary that row movement be enabled on the table.
Action: Enable row movement on the table
ORA-08190: restore point string is from a different incarnation of the database
Cause: An attempt was made to perform Flashback Table operation using a restore point from a different incarnation of the database
Action: Provide a restore point from the current database incarnation
ORA-08191: Flashback Table operation is not supported on remote tables
Cause: An attempt was made to perform Flashback Table operation on a remote table. This is not permitted.
Action: Do not perform a Flashback Table operation on remote tables.
ORA-08192: Flashback Table operation is not allowed on fixed tables
Cause: An attempt was made to perform Flashback Table operation on a fixed table. This is not permitted.
Action: Do not perform a Flashback Table operation on fixed tables.
ORA-08193: Flashback Table operation is not allowed on temporary tables
Cause: An attempt was made to perform Flashback Table operation on a temporary table. This is not permitted.
Action: Do not perform a Flashback Table operation on temporary tables.
ORA-08194: Flashback Table operation is not allowed on materialized views
Cause: An attempt was made to perform Flashback Table operation on a materialized view. This is not permitted.
Action: Do not perform a Flashback Table operation on materialized views or snapshot logs.
ORA-08195: Flashback Table operation is not supported on partitions
Cause: An attempt was made to perform Flashback Table operation on a partition. This is not permitted.
Action: Do not perform a Flashback Table operation on partitions.
ORA-08196: Flashback Table operation is not allowed on AQ tables
Cause: An attempt was made to perform Flashback Table operation on AQ tables. This is not permitted.
Action: Do not perform a Flashback Table operation on AQ tables.
ORA-08197: Flashback Table operation is not supported on clustered tables
Cause: An attempt was made to perform Flashback Table operation on a clustered table. This is not permitted.
Action: Do not perform a Flashback Table operation on clustered tables.
ORA-08198: Flashback Table is not supported on object tables, nested tables
Cause: An attempt was made to perform Flashback Table operation on a object table or a nested table or a table with nested table column. This is not permitted.
Action: Do not perform a Flashback Table operation on such tables.
ORA-08199: Flashback Table operation is not supported on this object
Cause: An attempt was made to perform Flashback Table operation on an object on which the operation is not supported.
Action: Do not perform a Flashback Table operation on such objects.
ORA-08205: ora_addr: $ORACLE_SID not set in environment
Cause: The environment variable ORACLE_SID is not set.
Action: Set the ORACLE_SID environment variable.
ORA-08206: ora_addr: cannot translate address file name
Cause: Cannot translate $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf.
Action: Ensure that ORACLE_HOME and ORACLE_SID are properly set.
ORA-08207: ora_addr: cannot open address file
Cause: The address file could not be opened.
Action: Check that ORACLE is up. Check that the file $(ORACLE_HOME)/dbs/sgadef$(ORACLE_SID).dbf exists and has correct permissions.
ORA-08208: ora_addr: cannot read from address file
Cause: The address file could not be read.
Action: Check that the file $(ORACLE_HOME)/dbs/sgadef$(ORACLE_SID).dbf exists and contains a single line of text.
ORA-08209: scngrs: SCN not yet initialized
Cause: The System Commit Number has not yet been initialized.
Action: Contact your customer support representative.
ORA-08210: Requested I/O error
Cause: Oracle requested that an I/O error be returned for this operation.
Action: This should not occur in normal Oracle operation. Contact support.
ORA-08230: smscre: failed to allocate SGA
Cause: The n_core system call failed, maybe due to insufficient memory.
Action: Specify a smaller number of buffers. Check INIT.ORA parameters.
ORA-08231: smscre: unable to attach to SGA
Cause: The process cannot attach to the SGA. This can happen if either the listener can't attach, or the process cannot communicate with the listener.
Action: Verify that the instance is up and running. Contact your customer support representative.
ORA-08232: smsdes: cannot detach from SGA
Cause: Probably, the listener process has died.
Action: Contact your customer support representative.
ORA-08233: smsdes: cannot unmap SGA
Cause: The n_core system call failed while detaching from the SGA.
Action: Note nCX error returned; contact your customer support representative.
ORA-08234: smsget: cannot get instance listener address
Cause: The instance listener address cannot be read from the sgadef file.
Action: Verify $(ORACLE_HOME) and $(ORACLE_SID) are set correctly. Additional information gives error return from ora_addr.
ORA-08235: smsget: listener not on this node
Cause: A process wishing to attach to the SGA is on a different node from its instance's listener.
Action: Verify $(ORACLE_HOME) and $(ORACLE_SID) are set correctly. Contact your customer support representative.
ORA-08236: smsget: cannot share subcube with listener
Cause: The n_share call failed, probably because the listener has died.
Action: Check if the listener is running, and contact your customer support representative.
ORA-08237: smsget: SGA region not yet created
Cause: Attempting to attach to an SGA which has not yet been created.
Action: Verify that the instance is running. Contact your customer support representative.
ORA-08238: smsfre: cannot detach from SGA
Cause: The n_core system call failed while detaching from the SGA.
Action: Check nCX error, and contact your customer support representative.
ORA-08243: recursive audit operation attempted
Cause: A recursive operation requiring audit was attempted in the middle of an auditing operation. The most likely reason is space management operations needed to free up space in the audit tablespace.
Action: Check space in the tablespace for SYS.AUD$ and correct the problem.
ORA-08260: ora_addr: cannot open nameserver
Cause: A process could not connect to the nameserver.
Action: Make sure the nameserver is up and running. Additional information gives nameserver's returned status.
ORA-08261: ora_addr: cannot find name in nameserver
Cause: The listener nameserver entry for an instance could not be found.
Action: Make sure the nameserver is up and running. Additional information gives nameserver's returned status.
ORA-08263: ora_addr: cannot free listener address
Cause: The listener nameserver entry could not be freed
Action: Additional information gives nameserver's returned status. Contact your customer support representative.
ORA-08264: ora_addr: cannot close nameserver
Cause: The connection to the nameserver could not be closed.
Action: Additional information gives nameserver's returned status. Contact your customer support representative.
ORA-08265: create_ora_addr: cannot open nameserver
Cause: A process could not connect to the nameserver.
Action: Make sure the nameserver is up and running. Additional information gives nameserver's returned status.
ORA-08266: create_ora_addr: cannot register name in nameserver
Cause: The listener's addressing information could not be registered.
Action: Make sure the nameserver is up and running. Additional information gives nameserver's returned status.
ORA-08267: destroy_ora_addr: cannot close nameserver
Cause: The connection to the nameserver could not be closed.
Action: Additional information gives nameserver's returned status. Contact your customer support representative.
ORA-08268: create_ora_addr: cannot close nameserver
Cause: The connection to the nameserver could not be closed.
Action: Additional information gives nameserver's returned status. Contact your customer support representative.
ORA-08269: destroy_ora_addr: cannot destroy name
Cause: The listener's addressing information could not be removed.
Action: Additional information gives nameserver's returned status. Contact your customer support representative.
ORA-08270: sksachk: Illegal archival control string
Cause: Archive files cannot be created with the given archival control string.
Action: Check that the volume exists
ORA-08271: sksabln: Buffer size not large enough for archive control string
Cause: The given archival control string expands into too many characters.
Action: Reduce archive control string length.
ORA-08274: Out of memory for environment variable
Cause: There is insufficient memory to return the requested value
Action: Reduce memory usage and retry.
ORA-08275: Environment variable unset
Cause: The requested environment variable is not set
Action: Ensure that the variable name requested is correct.
ORA-08276: No room in nameserver for pid
Cause: There is no room to record the pid for a background process
Action: Shutdown abort and restart the database.
ORA-08277: Cannot set environment variable
Cause: There is insufficient memory to expand the environment.
Action: Reduce memory usage and retry.
ORA-08278: Cannot get CPU statistics
Cause: Could not retrieve CPU times because n_stat failed.
Action: Contact customer support.
ORA-08308: sllfop: Cannot open file
Cause: Oracle could not open a file.
Action: Check the Unix errno returned as additional information.
ORA-08309: sllfop: Cannot fstat file
Cause: Oracle could not obtain information about an open file.
Action: Check the Unix errno returned as additional information.
ORA-08310: sllfop: Bad value for recsize
Cause: An illegal value for the record size was specified.
Action: Specify a value for the recsize option that is greater than 0.
ORA-08311: sllfop: bad value for maxrecsize
Cause: An illegal value for the maximum record size was specified.
Action: Specify a value for the maxrecsize option that is greater than 0.
ORA-08312: sllfop: unrecognized processing option
Cause: An unrecognized processing option was specified.
Action: Check the Oracle for nCUBE 2 User's Guide for valid options.
ORA-08313: sllfop: could not allocate buffers
Cause: Memory for the load buffers could not be allocated.
Action: Reduce the maximum record size. Eliminate any unnecessary processes on your current node before running SQL*Loader again.
ORA-08314: sllfcf: Error closing file
Cause: An error occurred trying to close a file.
Action: Check the Unix errno returned as additional information.
ORA-08315: sllfrb: Error reading file
Cause: An error occurred trying to read from a file.
Action: Check the Unix errno returned as additional information.
ORA-08316: sllfsk: Error seeking in file.
Cause: The lseek system call returned an error.
Action: Check the Unix errno returned as additional information.
ORA-08317: sllfsk: Error seeking in file.
Cause: The lseek system call returned an error.
Action: Check the Unix errno returned as additional information.
ORA-08318: sllfsk: Error reading file
Cause: An error occurred trying to read from a file.
Action: Check the Unix errno returned as additional information.
ORA-08319: sllfsk: Error reading file
Cause: An error occurred trying to read from a file.
Action: Check the Unix errno returned as additional information.
ORA-08320: scnget: Call to scnget before scnset or scnfnd.
Cause: An internal error
Action: Contact your customer support representative.
ORA-08321: scnmin: NOT IMPLEMENTED YET
Cause: An internal error
Action: Contact your customer support representative.
ORA-08322: scnmin: open/convert of bias lock failed
Cause: A call to the lkmgr failed to open and convert the bias lock
Action: Check to make sure the lkmgr is up.
ORA-08323: scnmin: close of bias lock failed
Cause: A call to the lkmgr failed to close the bias lock
Action: Check to make sure the lkmgr is up.
ORA-08330: Printing not supported
Cause: An attempt was made to automatically spool a file to the printer
Action: None
ORA-08331: Wait operation timed out
Cause: Oracle timed out waiting for an event
Action: Contact your Oracle support representative
ORA-08332: rollback segment #string specified not available
Cause: (same as 1545)
Action: (same as 1545). Also, make sure you have created enough rollback segments for the number of instances you are trying to start.
ORA-08340: This command not allowed on nCUBE, only one thread is ever used.
Cause: An illegal command was executed for the nCUBE platform.
Action: There is no need to issue this command.
ORA-08341: On nCUBE, this command can only be executed from instance 1.
Cause: A command that can only be issued on instance 1 was issued elsewhere.
Action: Log on to instance 1 and repeat the command.
ORA-08342: sropen: failed to open a redo server connection
Cause: An error occurred trying to connect to the redo server.
Action: The OS specific error message should tell you what to do.
ORA-08343: srclose: failed to close a redo server connection
Cause: An error occurred trying to close the redo server connection.
Action: The OS specific error message should tell you what to do.
ORA-08344: srapp: failed to send redo data to the redo server
Cause: An error occurred trying to send redo to the redo server.
Action: The OS specific error message should tell you what to do.
ORA-08401: invalid compiler name: string
Cause: An invalid compiler name <compname> was passed to a UTL_PG conversion routine.
Action: Correct the compiler name parameter in the PL/SQL code that called the conversion routine.
ORA-08412: error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message
Cause: The WMSGBSIZ is the maximun size for warning message block, it is recommanded to be 1024 bytes to 8 kbytes.
Action: Defined WMSGBLK of size between 1k to 8k bytes and update the WMSGBSIZ to the sizeof(WMSGBLK).
ORA-08413: invalid compiler type in FORMAT parameter at string
Cause: An invalid compiler type is defined in format control block. The format control block is invalid.
Action: Check to be sure that the format parameter was built by MAKE_RAW_TO_NUMBER_FORMAT or MAKE_NUMBER_TO_RAW_FORMAT, and that it was not accidentally overwritten or modified by the PL/SQL procedure.
ORA-08414: error encountered in string
Cause: The function <routine> returned an error. Where <routine> may be: RAW_TO_NUMER NUMBER_TO_RAW RAW_TO_NUMBER_FORMAT NUMBER_TO_RAW_FORMAT MAKE_NUMBER_TO_RAW_FORMAT MAKE_RAW_TO_NUMBER_FORMAT
Action: to take.
ORA-08429: raw data has invalid digit in display type data
Cause: The input raw buffer passed to a UTL_PG RAW_TO_NUMBER conversion routine contained invalid data. The picture mask parameter specified a digit, but the corresponding input from the raw data did not contain a valid digit.
Action: Either the input data is incorrect, or the picture mask is incorrect. Correct the appropriate item.
ORA-08430: raw data missing leading sign
Cause: The input raw buffer passed to a UTL_PG RAW_TO_NUMBER conversion routine had no leading sign, but the mask options parameter specified a leading sign.
Action: Correct the input raw data or the mask options so that they match.
ORA-08431: raw data missing zero as defined in picture
Cause: The picture mask parameter passed to a UTL_PG RAW_TO_NUMBER conversion routine contained a zero, but the corresponding input from the raw data was not a zero.
Action: Either the input data is incorrect, or the picture mask is incorrect. Correct the appropriate item.
ORA-08432: raw data has invalid floating point data
Cause: The input raw data passed to a UTL_PG RAW_TO_NUMBER conversion routine contained invalid floating point data.
Action: Correct the input raw data.
ORA-08433: invalid picture type in convert raw to number
Cause: The picture mask parameter passed to a UTL_PG RAW_TO_NUMBER conversion routine contained non-numeric characters, but the conversion was to a numeric data type.
Action: Correct the picture mask parameter.
ORA-08434: raw data has invalid trailing sign
Cause: The input raw buffer passed to a UTL_PG RAW_TO_NUMBER conversion routine had no trailing sign, but the mask options parameter specified a trailing sign.
Action: Correct the input raw data or the mask options so that they match.
ORA-08435: PICTURE MASK missing the leading sign when SIGN IS LEADING specified
Cause: The input MASK passed to a UTL_PG RAW_TO_NUMBER conversion routine had no leading sign, but the mask options parameter specified a leading sign.
Action: Correct the input raw data or the mask options so that they match.
ORA-08436: raw data has invalid sign digit
Cause: The input raw buffer passed to a UTL_PG RAW_TO_NUMBER conversion routine had an invalid sign digit in the position where the picture mask specified a sign.
Action: Correct the input raw data or the picture mask so that they match.
ORA-08437: invalid picture type in picture mask
Cause: The picture mask parameter passed to a UTL_PG NUMBER_TO_RAW conversion routine contained non-numeric characters, but the conversion was to a numeric data type.
Action: Correct the picture mask parameter.
No hay comentarios:
Publicar un comentario