Oracle 12c R2 Error Codes and Solution Suggestions from ORA-10900 to ORA-10999
- 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
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
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-10911: Locally managed SYSTEM tablespace bitmaps can be modified only under the supervision of Oracle Support
Cause: N/A
Action: n/a
Cause: N/A
Action: The event should be used only under the supervision of Oracle Support
Cause: An invalid option appears for TABLESPACE GROUP clause.
Action: Specify a valid tablespace group name.
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.
Cause: In CREATE/ALTER TABLESPACE, the TABLESPACE GROUP option was specified more than once.
Action: Remove all but one of the TABLESPACE GROUP specifications.
Cause: The tablespace name specified in the command is actually the name of a tablespace group.
Action: Please specify an appropriate 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.
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.
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.
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.
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-10923: prints debug information for object space server manageability
- 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
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.
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.
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.
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.
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.
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
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.
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.
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.
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-10937: trace name context forever
- ORA-10938: trace name context forever
- ORA-10939: trace name context forever
- 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.
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.
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.
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.
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.
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.
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-10949: Disable autotune direct path read for full table scan
- 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.
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
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-10990: dump spreadsheet info
- ORA-10992: event to enable dbms_job instead of dbms_scheduler
- ORA-10993: Runtime enable IOQ batching
- ORA-10994: Compiletime enable IOQ batching
- 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.