关 键 词:
近几日开始，应用程序频繁出现ORA-21500错误。而且产生错误的原因是随机的。应用程序发生core dump后，栈的信息也是不清晰的，完全不知道到底是应用程序本身的问题还是oracle的问题。
ORACLE的文档里是这样描述ORA-21500的：
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.
网上查询相关资料，也只说要象ORACLE报告此问题，并未说如何解决。
到了今天，ORA-21500错误已成必现。跟踪后发现，无论多简单的SELECT，都会引发这个错误。
错误的信息如下：
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.
遍寻不着，不得已换了个现网的同样的另一个数据库，发现一切正常。
由此可见，是ORACLE本身的问题导致了这个错误。错误产生的原因有三种：
1、安装ORACLE服务器的时候配置不对；
2、ORACLE所使用的磁盘分区存在坏道；
3、ORACLE的内存配置不正确；
看来只有先重装ORACLE数据库了。朋友们发现更好的解决办法请告诉我，谢谢！