Wednesday, March 14, 2012

ORA-00600: internal error code, arguments: [12333], [100], [163], [132], [], [], [], []

Got an Ora-00600 error today.

Error message:
ORA-00600: internal error code, arguments: [12333], [100], [163], [132], [], [], [], []

Solution:
-- check Oracle ora-00600 error lookup tool, and get the following note:
-- ORA-600 [12333] "Fatal Two-Task Protocol Violation" [ID 35928.1]
-- Understanding and Diagnosing ORA-00600 [12333] / ORA-3137 [12333] Errors [ID 389713.1]

For any ONE-TIME occurrence we can safely ignore the error. This error does not relate to any potential data corruption or any data loss.  :)

Common Causes & Solutions:
1.  Check the client software version. An incompatible client software can cause such internal error. 

2. An incompatible NLS Client setting can also trigger such internal errors. 

3. Try to reproduce the issue from a different client machine, preferably from server. This will rule out the possibility of bad network. 

4. If error still continues , then do the following to understand from where the error is generated. 
  •  We need to understand which session/program/application that triggers this issue. This shall be found from the trace files under the session state object '(session)'. Sometimes the ORA-00600 [12333] trace files will not capture the session information.  In such cases we can check with the end users about any issues around the time-frame of this internal error. 
  • There is a HIGH chance for application run-time exception to lead to this ORA-00600 [12333]. Due to the unhandled exceptions there is a chance for incomplete information passed to the server hence the internal errors are raised. In such cases, handling those exceptions (or) addressing those errors on the application code will resolve the issue. 
  •  In few cases, the problem application will work for a while before it terminates with the error. This could be due to the TIMEOUT settings at the Application Server (or) Forms Server.,etc. To resolve this either tune the failing application to complete within the TIMEOUT value (or) reset the TIMEOUT to an optimal value.
  • There could be more possibilities here; in simple words the approach should be from application side, which would help us to understand the other issues that triggered this network interruption (ORA-00600 [12333]).

5. If you notice JDBC Client as the failing program under Session state object, please check the following
  • That you use latest compatible version of JDBC Drivers in your application side.
    Note 430839.1 to verify the version of JDBC Drivers and for Installation steps. 
  •  Monitor and try to handle correctly the timeouts from the application 
  • Check that idle or died programs/processes are not just killed at the client side but using a good cleaning procedure. 
  • Increase queue sizes / buffers and similar from the jdbc side.
6. In-case if all the above suggestions does not help to identify the cause, and the ORA-00600 [12333] persists we may need to enable the networking tracings from the problem client and need to review the network traces to understand where the problem occurs.

More Oracle DBA tips, please visit Oracle DBA Tips 

Upgrading ArcSDE 10 and ORA-00942

I got an Ora-00942 error. And the following link explains a good reason:

Problem:  Incorrect dbtune XML_IDX_INDEX_TEXT values cause ArcSDE for Oracle geodatabase upgrades to fail with "ORA-00942: table or view does not exist" (http://support.esri.com/en/knowledgebase/techarticles/detail/38312)


Description

If there is an invalid value for the XML_IDX_INDEX_TEXT parameter in the dbtune, upgrading an ArcSDE for Oracle geodatabase to version 10 fails with following error in the sde_setup.log:

"[....] Error creating GDB_Items table...
[....] ERROR Creating Geodatabase tables
, Error = -37
,EXT_Error = 942
,EXT_ERROR1 = ORA-00942: table or view does not exist"

Cause

This error occurs when trying to create new geodatabase schema tables with an incorrect value in the XML_IDX_INDEX_TEXT parameter of the DEFAULTS DBTUNE keyword similar to the following:

"TABLESPACE TEST"

▪ The value of this parameter can be checked using the following ArcSDE admin command:

sdedbtune -o list -u sde -p sde -i sde:oracle10g:test -k DEFAULTS -P XML_IDX_INDEX_TEXT

ArcSDE 10.0 for Oracle11g Build 685 Fri May 14 12:05:43 2010
Attribute Administration Utility
-----------------------------------------------------
##DEFAULTS

XML_IDX_INDEX_TEXT "TABLESPACE TEST"

END

▪ The following is the actual SQL that fails:

SQL> CREATE INDEX xmldocix5_tx ON sde_xml_doc5 (xml_doc_val) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('TABLESPACE TEST');

CREATE INDEX xmldocix5_tx ON sde_xml_doc5 (xml_doc_val) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('TABLESPACE TEST')
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-11000: invalid keyword TABLESPACE
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364

Solution or Workaround

  1. Remove the config_string for the XML_IDX_INDEX_TEXT parameter in the DEFAULTS keyword from the DBTUNE.

    OR

    Make sure its value is valid for Oracle text. See the Oracle documentation for more information - there is a link to the Oracle documentation in the Related Information section below.
  2. Re-run the geodatabase upgrade.


More Oracle DBA tips, please visit Oracle DBA Tips