Oracle 11g Error Codes and Solution Suggestions from ORA-10900 to ORA-12000

Posted on by Fatih Acar

Oracle 11g Error Codes and Solution Suggestions from ORA-10900 to ORA-12000

ORA-10900: extent manager fault insertion event #string
Cause: causes faults to be generated in instrumented extent code
Action: this should only be enabled for internal testing
ORA-10902: disable seghdr conversion for ro operation
Cause: causes seghdr conversion to be turned off for ro ops(#555856)
Action: this should be enabled only if determined that bug 555856 has occured. Table needs to be exported subsequently
ORA-10906: Unable to extend segment after insert direct load
Cause: This is a restriction with insert direct load transactions.
Action: When a segment has been insert direct loaded, avoid DMLs that could cause more space to be consumed.
ORA-10914: invalid TABLESPACE GROUP clause
Cause: An invalid option appears for TABLESPACE GROUP clause.
Action: Specify a valid tablespace group name.
ORA-10915: TABLESPACE GROUP cannot be specified for this type of tablespace
Cause: In CREATE/ALTER TABLESPACE, the TABLESPACE GROUP clause was used while creating/altering a tablespace that is not TEMPORARY.
Action: Remove the TABLESPACE GROUP clause.
ORA-10916: TABLESPACE GROUP already specified
Cause: In CREATE/ALTER TABLESPACE, the TABLESPACE GROUP option was specified more than once.
Action: Remove all but one of the TABLESPACE GROUP specifications.
ORA-10917: TABLESPACE GROUP cannot be specified
Cause: The tablespace name specified in the command is actually the name of a tablespace group.
Action: Please specify an appropriate tablespace name.
ORA-10918: TABLESPACE GROUP name cannot be the same as tablespace name
Cause: The tablespace group name specified in the command is the same as the tablespace being CREATEd/ALTERed.
Action: Please specify an appropriate tablespace group name.
ORA-10919: Default temporary tablespace group must have at least one tablespace
Cause: An attempt was made to move the only tablespace in the default database temporary tablespace group to another tablespace group.
Action: Either change the database default temporary tablespace or add another tablespace to the group that this tablespace belongs to.
ORA-10920: Cannot offline tablespace belonging to default temporary tablespace group
Cause: An attempt was made to offline a tablespace in the default database temporary tablespace group.
Action: Either change the database default temporary tablespace or change the tablespace group of this tablespace.
ORA-10921: Cannot drop tablespace belonging to default temporary tablespace group
Cause: An attempt was made to drop a tablespace in the default database temporary tablespace group.
Action: Either change the database default temporary tablespace or change the tablespace group of this tablespace.
ORA-10922: Temporary tablespace group is empty
Cause: An attempt was made to allocate a temporary segment in a group, which now no longer has any members.
Action: Either add some temporary tablespaces or change the temporary tablespace for this user.
ORA-10924: import storage parse error ignore event
Cause: causes server to ignore specific error associated with freelists and freelist groups when parsing
Action: this should be enabled by import code only

ORA-10925: trace name context forever
Cause: When enabled, turns off bugfix 237911
Action: set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.
ORA-10926: trace name context forever
Cause: When enabled, turns off bugfix 190119
Action: set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.
ORA-10927: trace name context forever
Cause: When enabled, turns off bugfix 235190
Action: set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.
ORA-10929: trace name context forever
Cause: When enabled, turns off bugfix 343966
Action: set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.
ORA-10930: trace name context forever
Cause: When enabled, provides V7 behavior for fixed char binds
Action: set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.
ORA-10931: trace name context forever
Cause: When enabled, allows normal packages to be compiled with standard extensions like “<ADT_1>”
Action: Set this event only for a short amount of time. Once the packages are compiled, this event should be turned off. Level 1 – Turn the event on Level > 1 – Turn the event off
ORA-10932: trace name context forever
Cause: When enabled, disables one or more features or bug fixes available only in version 8.x.
Action: set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.
ORA-10933: trace name context forever
Cause: When enabled, disables one or more features or bug fixes available only in version 8.x.
Action: set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.
ORA-10934: trace name context forever
Cause: When enabled, disables one or more features or bug fixes available only in version 11.x.
Action: Set this event only if necessary – after reading the README for this release or under supervision of Oracle Support Services.
ORA-10936: trace name context forever
Cause: When enabled, disables one or more features or bug fixes available in versions 7.x and 8.x.
Action: set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.
ORA-10940: trace name context forever
Cause: Size of the PL/SQL tracing circular buffer, in kilobytes.
Action: Set this event in concert with the 10938 event and the _PLSQL_DUMP_BUFFER_EVENTS init.ora parameter, under supervision of Oracle Support.
ORA-10941: trace name context forever
Cause: When enabled, turns on PL/SQL profiler
Action: set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.
ORA-10943: trace name context forever
Cause: When enabled, disables one or more features or bug fixes available only in version 8.x.
Action: set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.
ORA-10944: trace name context forever
Cause: When enabled, allows or controls PL/SQL OPT code gen project. available only in version 8.2+.
Action: set this event ONLY for development of the OPT project. This is not for general use or deployment.
ORA-10945: trace name context forever
Cause: When enabled, disables the behaviour change introduced by the fix for bug 822764, which traps and handles invalidations of packages whereas the previous behaviour was to use stale invalidated instantiations of the stateful package body.
Action: set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.
ORA-10946: trace name context forever
Cause: When enabled, disables one or more features or bug fixes available only in version 10.x.
Action: set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.
ORA-10947: trace name context forever
Cause: When enabled, causes various PL/SQL warnings related debugging info to be written in a trace file. Useful for debugging varous Oracle processes. available only in version 10.x.
Action: set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.
ORA-10970: backout event for bug 2133357
Cause: 2133357 dynamically sets the varying width flag and character width. Lob data which is not migrated during migration from single byte to multibyte charater set will be displayed as special characters.
Action: To help migrate lob data which was not migrated during migration by backing out 2133357, so lob data can be selected and moved to multibyte character set.
ORA-10973: backout evet for 2619509
Cause: 2619509 catches offsets when not reading/writing on full character boundary. To facilitate backward compatiblity event is being introduced.
Action: To help upgrade/migrate issues which already have corrupt data
ORA-10979: trace flags for join index implementation
Cause: This is an informational message.
Action: Values are as follows: LEVEL ACTION ————————————————————————— > 1 Dump refresh expressions (SQL) to trace file. > 999 If a complete refresh is invoked, it will not be performed but the system will assume that a complete refresh was done, causing the view to be VALID and updating timestamps. This should be used only under Oracle Support supervision.
ORA-10997: another startup/shutdown operation of this instance inprogress
Cause: An Oracle Instance startup or shutdown operation failed to procure the serialization primitive. Another foreground process may have attempted startup or shutdown operation in parallel.
Action: Check additional error messages in the alert log and the process trace file.

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.