oracle 错误06512,ORA-06512错误的一个原因

ORA-06512错误的一个原因[@more@]

ORA-06512错误的一个原因

在alert文件中出现错误信息

Wed Sep 3 18:18:43 2008

Errors in file ********_ora_627008.trc:

ORA-03113: end-of-file on communication channel

ORA-03113: end-of-file on communication channel

ORA-06512: at "********.********E_PS_PUBLIC_LOG", line 557

ORA-06512: at "********.********E_PS_PUBLIC_LOG", line 916

ORA-06512: at "********.********E_PS_PUBLIC_LOG", line 975

ORA-06512: at "********.********E_PS_CONFIRM_PS_INCOME", line 917

ORA-06512: at line 1

查看文件life1_ora_627008.trc

*** SERVICE NAME:() 2008-09-03 18:18:43.765

*** SESSION ID:(3263.17257) 2008-09-03 18:18:43.765

*** 2008-09-03 18:18:43.765

ksedmp: internal or fatal error

ORA-03113: end-of-file on communication channel

ORA-03113: end-of-file on communication channel

ORA-06512: at "********.********E_PS_PUBLIC_LOG", line 557

ORA-06512: at "********.********E_PS_PUBLIC_LOG", line 916

ORA-06512: at "********.********E_PS_PUBLIC_LOG", line 975

ORA-06512: at "********.********E_PS_CONFIRM_PS_INCOME", line 917

ORA-06512: at line 1

Current SQL information unavailable - no session.

经调查这个问题的出现和25日的问题相同：

在alert文件：

Mon Aug 25 18:02:28 2008

Errors in file ********_ora_1426164.trc:

ORA-03113: end-of-file on communication channel

ORA-03113: end-of-file on communication channel

ORA-06512: at "********.********E_CLAIM", line 5740

ORA-06512: at line 1

在文件life2_ora_1426164.trc中：

*** SERVICE NAME:() 2008-08-25 18:02:28.646

*** SESSION ID:(2683.48227) 2008-08-25 18:02:28.646

*** 2008-08-25 18:02:28.646

ksedmp: internal or fatal error

ORA-03113: end-of-file on communication channel

ORA-03113: end-of-file on communication channel

ORA-06512: at "********.********E_CLAIM", line 5740

ORA-06512: at line 1

Current SQL information unavailable - no session.

结论：

这个时间正好是和系统上线的时间一直，主要是这个时间中间件重启而造成的问题的产生。