{"id":1847,"date":"2016-04-02T11:52:38","date_gmt":"2016-04-02T08:52:38","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1847"},"modified":"2016-10-24T11:54:14","modified_gmt":"2016-10-24T08:54:14","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-10900-to-ora-12000","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-10900-to-ora-12000\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-10900 to ORA-12000"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-10900 to ORA-12000<\/strong><\/p>\n

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

<\/p>\n

<\/a><\/a>ORA-10925: trace name context forever<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When enabled, turns off bugfix 237911<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10926: trace name context forever<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When enabled, turns off bugfix 190119<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10927: trace name context forever<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When enabled, turns off bugfix 235190<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10929: trace name context forever<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When enabled, turns off bugfix 343966<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10930: trace name context forever<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When enabled, provides V7 behavior for fixed char binds<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10931: trace name context forever<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When enabled, allows normal packages to be compiled with standard extensions like “<ADT_1>”<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Set 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<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10932: trace name context forever<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When enabled, disables one or more features or bug fixes available only in version 8.x.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10933: trace name context forever<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When enabled, disables one or more features or bug fixes available only in version 8.x.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10934: trace name context forever<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When enabled, disables one or more features or bug fixes available only in version 11.x.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Set this event only if necessary – after reading the README for this release or under supervision of Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10936: trace name context forever<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When enabled, disables one or more features or bug fixes available in versions 7.x and 8.x.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10940: trace name context forever<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Size of the PL\/SQL tracing circular buffer, in kilobytes.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Set this event in concert with the 10938 event and the _PLSQL_DUMP_BUFFER_EVENTS init.ora parameter, under supervision of Oracle Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10941: trace name context forever<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When enabled, turns on PL\/SQL profiler<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10943: trace name context forever<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When enabled, disables one or more features or bug fixes available only in version 8.x.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10944: trace name context forever<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When enabled, allows or controls PL\/SQL OPT code gen project. available only in version 8.2+.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0set this event ONLY for development of the OPT project. This is not for general use or deployment.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10945: trace name context forever<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10946: trace name context forever<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When enabled, disables one or more features or bug fixes available only in version 10.x.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10947: trace name context forever<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0set this event ONLY if necessary – after reading the README for this release or under supervision of Oracle Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10970: backout event for bug 2133357<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a02133357 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0To 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10973: backout evet for 2619509<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a02619509 catches offsets when not reading\/writing on full character boundary. To facilitate backward compatiblity event is being introduced.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0To help upgrade\/migrate issues which already have corrupt data<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10979: trace flags for join index implementation<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This is an informational message.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Values 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-10997: another startup\/shutdown operation of this instance inprogress<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An Oracle Instance startup or shutdown operation failed to procure the serialization primitive. Another foreground process may have attempted startup or shutdown operation in parallel.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional error messages in the alert log and the process trace file.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-10900 to ORA-12000 ORA-10900: extent manager fault insertion event #string Cause:\u00a0causes faults to be generated in instrumented extent code Action:\u00a0this should only be enabled for internal testing ORA-10902: disable seghdr conversion for ro operation Cause:\u00a0causes seghdr conversion to be turned off for ro ops(#555856) Action:\u00a0this should be…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1847","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-tN","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1847","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1847"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1847\/revisions"}],"predecessor-version":[{"id":1848,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1847\/revisions\/1848"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1847"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1847"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1847"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}