Oracle Error Ora-21500
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life Cycles Manage Cases Request Case Start Chat Back to results Print Share Is This Content Helpful? Search on GeoNet Submit to ArcGIS Ideas Bug: Underlying Oracle DBMS error ORA-21500 with ST_Geometry attributes Description Using ArcGIS to identify or select a feature from a feature class stored as an ST_Geometry attribute or attempting to open the layer's attribute table results in the underlying Oracle DBMS error ORA-21500.The error is either logged in the ArcSDE error log or the following error message is displayed in ArcGIS: "Underlying DBMS error [ORA-21500: internal error code, arguments: [%s],[%s],[%s],[%s],[%s],[%s],[%s],[%s]]". Cause The cause of the error is an internal Oracle error which neither ArcGIS nor ArcSDE can control. The error is encountered when the application generates a SQL statement using an asterisk in the SELECT list (SELECT * FROM...).For further information on the Oracle error please see Oracle's Metalink Note:49375.1. Workaround There are two possible workarounds for this issue. Ensure there is a spatial index present for the feature class and/or add an additional attribute after the ST_Geometry attribute.To verify if a spatial index is present, using ArcCatalog, connect to the ArcSDE instance as the feature class owner. Select the feature class. Open the properties dialog box. Select the indexes tab and verify that the spatial index is present.To add a new attribute to a feature class in ArcCatalog, open the feature class properties. Select the fields tab and add the new attribute.Once the ST_Geometry attribute is no longer in the last position of the SELECT * list, the internal ORA-21500 error is no longer encountered. Related Information Metalink Note (Oracle Website) Created: 5/5/2016 Last Modified: 5/5/2016 Article ID: 000009667 Software: ArcSDE 9.2 Is This Content Helpful? Is This Content Helpful? Yes No We're glad to know this article was helpful. How can we make this better? Submit Contact our Support Team Request Case Start Chat Questions or issues with the site? Send Feedback Privacy Contact Support USA +1-888-377-4575 Name Email URL Please rate your online support experience with Esri's Support website.* Poor Below Satisified Satisfied Above Satisfied Excellent What issues are you having with the site? How can we improve? Submit Feedback sent successfully. Error while sending mail. Loading
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 http://support.esri.com/technical-article/000009667 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-21500: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s] up vote 2 down vote favorite 1 I searched a lot but none of the links helped me in resolving this issue. I am getting http://stackoverflow.com/questions/25741072/ora-21500-internal-error-code-arguments-s-s-s-s-s-s ORA-21500: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s] when using OracleDataAdapter. I am using 11.2.0 Oracle client and the oracle dataset is 11.1.0.7.0. Can anyone please help me in why I am getting this error? Some of the links that I searched say it is due to incompatible oracle client and database. This error is intermittent and debugging the issue didn't give much clue. Result StackTrace: at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleDataReader.Read() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) c# .net oracle oracle11g share|improve this question edited Sep 9 '14 at 9:57 asked Sep 9 '14 at 9:26 user3894624 add a comment| 2 Answers 2 active oldest votes up vote
for 11gR1 Client UsingXMLTYPE April 28, 2013 Leave a comment Recently one of the user got ORA-21500 and this was due to bug in 11gr1 client. User has 11gr1 client version which connects to 11gr2 DB and this bug is related to securefile handling in 11gr1 client. But, this https://desaitaral.wordpress.com/2013/04/28/ora-21500-bug-for-11gr1-client-using-xmltype-2/ post it not about going into much deeper details but just wanted to document what http://www.ibm.com/support/docview.wss?uid=swg21586244 i learned. CREATE TABLE TARAL.BUG_TEST1(ID NUMBER(38,0) NOT NULL, XCOL1 SYS.XMLTYPE) XMLTYPE COLUMN XCOL1 STORE AS SECUREFILE BINARY XML(TABLESPACE USERS ENABLE STORAGE IN ROW CHUNK 8192); CREATE TABLE TARAL.BUG_TEST2(ID NUMBER(38,0) NOT NULL, XCOL1 SYS.XMLTYPE) XMLTYPE COLUMN XCOL1 STORE AS BASICFILE CLOB(TABLESPACE USERS ENABLE STORAGE IN ROW CHUNK 8192); SQL> select * from bug_test1; ERROR: ORA-21500: internal error code, arguments: [%s], [%s], oracle error [%s], [%s], [%s], [%s],[%s], [%s] we are using windows client here,but if you use UNIX then it throws more specific error. SQL> select * from bug_test1; Errors in file : OCI-21500: internal error code, arguments: [qmcxdEvtNextPPP], [], [], [], [], [], [], [] Ð@ø0Ð@ø0Ð@ø0ERROR: ORA-21500: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s],[%s], [%s] This indeed tells us it's an OCI error. But, how to trace this in windows. Well, this is what oracle error ora-21500 i learned from this error. No OCI Trace Generated With 10.2 Oracle Client Using Oracle Data Provider for .Net [ID 1371240.1] set ORA_CLIENTTRACE_DIR=c:\temp set EVENT_10842=server=all;user=all;stmt=all;level=15 The following levels are supported: 1 - Trace all server attach and server detach calls for servers listed in "server" attribute of the environment variable. 2 - Trace all session begin, logon, session end, logoff calls for the users listed in "user" attribute of the environment variable. 3 - Trace all prepare, execute, fetch calls for the specified statement types listed in "stmt" attribute of environment variable. 4 - Trace all Bind, Define, Describe calls. 5 - Trace all OCI LOB calls 7 - Get statistical info on all connection pooling /connection related calls 8 - Get statistical info on all session info 9 - Get statistical info on all handle info 10 - Get statistical info on time taken in execute and fetch calls 11 - Get statistical info on transaction related calls 15 - Trace all calls with statistical info. Rate this:Share this:EmailLike this:Like Loading... Related Filed under Internal, Troubleshooting About TaralI am Rookie to Oracle Technology so let's see where it goes Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using
Problem(Abstract) OCI-21500 errors are Oracle internal errors and can occur for many reasons, some known and some as yet unknown. This particular one occurred under the following conditions. Jobs utilising the Oracle Connector with a reject link attempt to insert a row with a clob that should reject due to Foreign Key constraint not met, abort with OCI-21500: internal error code. Check the symptoms to see if ths particular OCI-21500 internal error corresponds to the failure you are seeing.. Symptom Jobs utilising the Oracle Connector with a reject link - Attempts to insert a row with a clob that should reject due to Foreign Key constraint not met, abort with OCI-21500: internal error code, arguments: [17112], [0x000B0DEB8], [],[], [], [], [], [] Cause The issue was reported to Oracle with a reproducible test case, Oracle reproduced and assigned bug id 13636295 If you have an oracle support account you can view details at https://support.oracle.com/CSP/main/article?cmd=show&type=BUG&id=13636295&productFamily=Oracle Environment Oracle 11.2.0.2 and 11.2.0.3 Diagnosing the problem In addition to the error message a stack trace taken from a core file generated at this time shows gdb $APT_ORCHHOME/bin/osh core.11888 (gdb) bt #0 0x00002b38b3c23cad in raise () from /lib64/libpthread.so.0 #1 0x00002aaaac7d56b2 in skgesigOSCrash () from /u01/app/oracle/product/11.2.0.2/ic_1/libclntsh.so.10.1 #2 0x00002aaaaca73705 in kpeDbgSignalHandler () from /u01/app/oracle/product/11.2.0.2/ic_1/libclntsh.so.10.1 #3 0x00002aaaac7d58c2 in skgesig_sigactionHandler () from /u01/app/oracle/product/11.2.0.2/ic_1/libclntsh.so.10.1 #4