近几日开始,应用程序频繁出现ORA-21500错误。而且产生错误的原因是随机的。应用程序发生core dump后,栈的信息也是不清晰的,完全不知道到底是应用程序本身的问题还是ORACLE的问题。
ORACLE的文档里是这样描述ORA-21500的:
到了今天,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数据库了。朋友们发现更好的解决办法请告诉我,谢谢!
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.
到了今天,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数据库了。朋友们发现更好的解决办法请告诉我,谢谢!