ORA-08238: smsfre: cannot detach from SGA

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-08237: smsget: SGA region not yet created

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-08236: smsget: cannot share subcube with listener

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-08235: smsget: listener not on this node

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-08234: smsget: cannot get instance listener address

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-08233: smsdes: cannot unmap SGA

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-08232: smsdes: cannot detach from SGA

ORA-08232: smsdes: cannot detach from SGA

Cause: Probably, the listener process has died.

Action: Contact your customer support representative.

ORA-08231: smscre: unable to attach to SGA

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-08230: smscre: failed to allocate SGA

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-08210: Requested I or O error

ORA-08210: Requested I or O error

Cause: Oracle requested that an I or O error be returned for this operation.

Action: This should not occur in normal Oracle operation. Contact support.

ORA-08209: scngrs: SCN not yet initialized

ORA-08209: scngrs: SCN not yet initialized

Cause: The System Commit Number has not yet been initialized.

Action: Contact your customer support representative.

ORA-08208: ora_addr: cannot read from address file

ORA-08208: ora_addr: cannot read from address file

Cause: The address file could not be read.

Action: Check that the file $(ORACLE_HOME) or dbs or sgadef$(ORACLE_SID).dbf exists and contains a single line of text.

ORA-08207: ora_addr: cannot open address file

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) or dbs or sgadef$(ORACLE_SID).dbf exists and has correct permissions.

ORA-08206: ora_addr: cannot translate address file name

ORA-08206: ora_addr: cannot translate address file name

Cause: Cannot translate $ORACLE_HOME or dbs or sgadef$ORACLE_SID.dbf.

Action: Ensure that ORACLE_HOME and ORACLE_SID are properly set.

ORA-08205: ora_addr: $ORACLE_SID not set in environment

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-08199: Flashback Table operation is not supported on this object

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-08198: Flashback Table is not supported on object tables, nested 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-08197: Flashback Table operation is not supported on clustered 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-08196: Flashback Table operation is not allowed on AQ tables

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-08195: Flashback Table operation is not supported on partitions

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-08194: Flashback Table operation is not allowed on materialized views

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-08193: Flashback Table operation is not allowed on temporary 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-08192: Flashback Table operation is not allowed on fixed 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-08191: Flashback Table operation is not supported on remote tables

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-08190: restore point string is from a different incarnation of the database

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-08189: cannot flashback the table because row movement is not enabled

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-08187: snapshot expression not allowed here

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-08186: invalid timestamp specified

ORA-08186: invalid timestamp specified

Cause: as stated above

Action: enter a valid timestamp

ORA-08185: Flashback not supported for user SYS

ORA-08185: Flashback not supported for user SYS

Cause: user logged on as SYS

Action: logon as a different (non SYS) user.

ORA-08184: attempting to re-enable Flashback while in Flashback mode

ORA-08184: attempting to re-enable Flashback while in Flashback mode

Cause: as stated above

Action: disable first before re-enabling

ORA-08183: Flashback cannot be enabled in the middle of a transaction

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-08182: operation not supported while in Flashback mode

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-08181: specified number is not a valid system change number

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-08180: no snapshot found based on specified time

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-08179: concurrency check failed

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-08178: illegal SERIALIZABLE clause specified for user INTERNAL

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-08177: can t serialize access for this transaction

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 or write transactions, retry the intended operation or transaction.

ORA-08176: consistent read failure; rollback data not available

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 or write transactions, retry the intended operation. Read only transactions must be restarted.

ORA-08175: discrete transaction restriction violated (string)

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-08121: Number of indexes need to be maintained offline exceeds limit for DML

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-08120: Need to create SYS.IND_ONLINE$ table in order to (re)build index

ORA-08120: Need to create SYS.IND_ONLINE$ table in order to (re)build index

Cause: Alter index Build or Rebuild online require existing of SYS.IND_ONLINE$ table.

Action: User or DBA needs to create sys.ind_online$ before alter the index or rdbms or admin or catcio.sql contains script to create ind_online$.

ORA-08119: The new initrans will make the index too big

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-08118: Deferred FK constraints cannot be enforced, index too big (string)

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-08117: Index Organized Table operation released its block pin

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-08116: can not acquire dml enough lock(S mode) for online index build

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-08115: can not online create or rebuild this index type

ORA-08115: can not online create or rebuild this index type

Cause: User attempted to create index type that online doesnot support

Action: use offline index create or rebuild command

ORA-08114: can not alter a fake index

ORA-08114: can not alter a fake index

Cause: User attempted to alter a fake index

Action: drop fake index

ORA-08113: composite partition index may not be compressed

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-08112: a composite partition may not be coalesced as a whole

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-08111: a partitioned index may not be coalesced as a whole

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-08110: Oracle event to test SMON cleanup for online index build

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-08109: nosort is not a supported option for online index build

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-08108: may not build or rebuild this type of index online

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-08106: cannot create journal table string.string

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-08105: Oracle event to turn off smon cleanup for online index build

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-08104: this index object string is being online built or rebuilt

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-08103: object no longer exists

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-08102: index key not found, obj# string, file string, block string (string)

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-08101: index key does not exist file string: (root string, node string) blocks (string)

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-08100: index is not valid - see trace file for diagnostics

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