ORA-21500 errors have occurred frequently in applications since the last few days. The cause of the error is random. After a core dump occurs in an application, the stack information is unclear, and it is unknown whether the application itself is a problem or an oracle problem.
The Oracle documentation describes the ORA-21500 as follows:
-
ORA-21500 internal error code, arguments :[String], [String], [String], [String], [String], [String], [String], [String]
-
Cause:This is the generic error number for the OCI environment (client-side) internal errors. This indicates that the OCI environment has encountered an exceptional condition.
-
Action:Report to Oracle Support Services. The first argument is the internal error number.
When you query relevant information online, you only need to report the problem like Oracle and do not know how to solve it.
By today, ORA-21500 errors have become necessary. After tracking, it is found that no matter how simple the SELECT statement is, this error will occur.
The error message is as follows:
ORA-21500: Internal error code, arguments: [17099], [], [], [], [], [], [], []
Errors in file:
ORA-21500: Internal error code, arguments: [17099], [], [], [], [], [], [], []
----- Call stack trace -----
Calling call entry argument values in hex
Location Type Point (? Means dubious value)
----------------------------------------------------------------------------
Cannot find symbol in/proc/32129/EXE.
Cannot find symbol in/proc/32129/EXE.
Cannot find symbol in/proc/32129/EXE.
Cannot find symbol in/proc/32129/EXE.
Cannot find symbol in/proc/32129/EXE.
Cannot find symbol in/proc/32129/EXE.
Cannot find symbol in/proc/32129/EXE.
Cannot find symbol in/proc/32129/EXE.
Cannot find symbol in/proc/32129/EXE.
Cannot find symbol in/proc/32129/EXE.
I couldn't find it again. I had to change to another database on the current network and found everything was normal.
It can be seen that this error is caused by Oracle problems. There are three reasons for the error:
1. The configuration is incorrect when the Oracle server is installed;
2. There is a bad track in the disk partition used by Oracle;
3. The Oracle memory configuration is incorrect;
It seems that only the Oracle database is reinstalled first. Please let me know if you have found a better solution. Thank you!