急！！ORA-00603: ORACLE server session terminated by fatal error

bzy 2004-01-07 10:08:03

这两天orace92老是报此错误。
情景1：使用两个大的表union建立一个表（两个表在其它数据库上）
以前建立时没问题
情景2：我用insert将上面表建好后对此表建立索引
注：表中数据其实也就一百来万条
我怀疑是数据库性能问题，而且经常有时会出现某几个oracle进程占用
大量内存情况。
说明：由于这数据库是别人管理，我只有resoures权限。所以不能自己
对数据库性能调优。
请问高手们出现这种错误主要是什么原因？

...全文

1008 4 打赏收藏转发到动态举报

写回复

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

shuipipi 2004-01-07

打赏
举报

回复

也狠有可能是表空间不够导致的，因为泥的情景下都是要耗费表空间的操作。

shuipipi 2004-01-07

打赏
举报

回复

泥可以先看一下告警日志里面的信息，看是否有所发现；或者该为ORA92打补丁了～

qfsb_p 2004-01-07

打赏
举报

回复

是不是空间不够了？

LGQDUCKY 2004-01-07

打赏
举报

回复

既然没有权限，不如你把数据导出来，到其他机器实验。
这样才能漫漫的找出问题。

Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.1.0.6 Information in this document applies to any platform. Description The following errors may be reported: ORA-00603: ORACLE server session terminated by fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:sskgxp_select failed with status: 3 ORA-27301: OS failure message: No such process ORA-27302: failure occurred at: skgxpvfymmtu ORA-27303: additional information: MTU could not be verified. Did not receive valid message. These errors are caused by more aggressive checking introduced in 10.2.0.4. Likelihood of Occurrence This only affects Oracle Real Application Clusters and can be reported in ASM as well as database instances. The issue was introduced in Oracle 10.2.0.4 so earlier versions are not affected Possible Symptoms The errors above can be reported by Oracle shadow processes or by background processes. Additionally they may be reported in the alert.log. The symptoms can include: - process failure - startup failure - processes spinning in function sskgxp_select with high CPU usage Workaround or Resolution There is no workaround available. However, if the instance fails to start, a reboot of the server supporting the instance will usually allow startup to succeed. Patches At the time of writing, patches were under development on top of 10.2.0.4 on some platforms. Please check Patch 7331323 for availability on your platform. The problem is resolved in 11.1.0.7. References NOTE:419937.1 - Alert.log shows frequently "skgxpvfymmtu: process failed because of a resource problem in the OS" NOTE:419871.1 - Failures due to "skgxpvfymmtu: process failed because of a resource problem in the OS" on 32-bit Linux

ORA-00603: ORACLE server session terminated by fatal error 后台错误中发现是UNDO的问题 ORA-00600: internal error code, arguments: [4194], [98], [75], [], [], [], [], [] 解决办法 1、通过错误信息可以确定当前回滚段是1-10，所以修改PFILE文件

第三方软件连接oracle出现下面的错误： Errors in file /u01/app/oracle/diag/rdbms/{DBNAME}/{instance1}/trace/{instance1}_ora_125091.trc (incident=112901) (PDBNAME=CDB$ROOT): ORA-00603: ORACLE server session terminated by fatal error ORA-27515: inadequate memlock limit or d

今天发现在使用OracleConnection连接ORACLE数据库的过程中突然出现连接不上的情况，dotNetFramework返回ORA-00603错误。 ORA-00603: ORACLE 服务器会话因致命错误而终止。然后跟踪到trace日志。发现如下异常。 Mon Mar 26 15:27:41 2012 Errors i

晚上收到数据报警： Errors in file /app/oracle/admin/xxxxx/udump/xxxxx_ora_22467.trc: ORA-00600: internal error code, arguments: [1265], [0xADE975850], [], [], [], [], [], [] Tue Jun 24 22:00:45 CST 2014 Er

17,086

社区成员

55,238

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章