ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00600:[rpidrv-3], [], [], [], [], [], [], []

ORA-00600:[rpidrv-3], [], [], [], [], [], [], []

原创 Linux操作系统 作者:yxyup 时间:2007-06-18 00:00:00 0 删除 编辑
ORA-00600: internal error code, arguments: [rpidrv-3], [], [], [], [], [], [], []
今天下午在一如生产DB中又遇见了ORA-600,详细如下
Mon Jun 18 14:04:53 2007
Errors in file /filedata/ora_log/FFV2PROD/udump/ffv2prod_ora_876660.trc:
ORA-00600: internal error code, arguments: [rpidrv-3], [], [], [], [], [], [], []
Mon Jun 18 14:04:55 2007
Errors in file /filedata/ora_log/FFV2PROD/udump/ffv2prod_ora_876660.trc:
ORA-00600: internal error code, arguments: [12804], [kkdlgtd: bad object type], [], [], [], [], [], []
Mon Jun 18 14:04:55 2007
Errors in file /filedata/ora_log/FFV2PROD/udump/ffv2prod_ora_876660.trc:
ORA-00600: internal error code, arguments: [12804], [kkdlgtd: bad object type], [], [], [], [], [], []
Mon Jun 18 14:04:56 2007
Errors in file /filedata/ora_log/FFV2PROD/udump/ffv2prod_ora_876660.trc:
ORA-00600: internal error code, arguments: [rpidrv-3], [], [], [], [], [], [], []
Mon Jun 18 14:04:56 2007
Errors in file /filedata/ora_log/FFV2PROD/udump/ffv2prod_ora_876660.trc:
ORA-00600: internal error code, arguments: [rpidrv-3], [], [], [], [], [], [], []
Mon Jun 18 14:05:54 2007
Errors in file /filedata/ora_log/FFV2PROD/udump/ffv2prod_ora_1544396.trc:
ORA-00600: internal error code, arguments: [rpidrv-3], [], [], [], [], [], [], []

/filedata/ora_log/FFV2PROD/udump/ffv2prod_ora_876660.trc:内空如下
$ vi ffv2prod_ora_876660.trc
"ffv2prod_ora_876660.trc" 109032 lines, 6822131 characters
/filedata/ora_log/FFV2PROD/udump/ffv2prod_ora_876660.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /opt/oracle/product/9.2.0
System name: AIX
Node name: SHASAX02
Release: 2
Version: 5
Machine: 0009AAB8D600
Instance name: FFV2PROD
Redo thread mounted by this instance: 1
Oracle process number: 95
Unix process pid: 876660, image: oracle@SHASAX02 (TNS V1-V3)
*** SESSION ID:(170.25500) 2007-06-18 14:04:53.426
*** 2007-06-18 14:04:53.426
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [rpidrv-3], [], [], [], [], [], [], []
Current SQL statement for this session:
create or replace view ACTUSER0703.re_addd_new as
Select v.valuation_date_str As RE_MONTH,
b.abbreviation branch_code,
p.cntrct_id,
p.Name issued_name,
p.risk_code,
p.Cntrct_SA,
p.CM_Mandatory_SA Net_of_Man,
p.Effective_Re_Prem Re_Prem,
p.issue_age,
p.gender,
p.Curr_OC,
p.process_month,
p.Curr_Reins_Status F_or_A,
p.cvrg_issue_dt,
p.CM_Lastanndate Lastanndate
From RE_ADDD_DETAIL P, BRANCH_HIERARCHY_SETTING B, VALUATION_DATE_SETTING V
Where
p.branch = b.branch_code
And p.Effective_Re_Prem <>0
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp+0148 bl ksedst 1027C70E4 ?
ksfdmp+0018 bl 01FD82A4
kgerinv+00e8 bl _ptrgl
kgesinv+0020 bl kgerinv 700000203CE85E0 ? 000000000 ?
000000000 ? 000000000 ?
FFFFFFFFFFF3FD0 ?
ksesin+005c bl kgesinv 70000022BBAD360 ? 110006288 ?
000000000 ? 000000000 ?
7000002003BFB40 ?
rpidrv+06b4 bl ksesin 102F6B3A8 ? 000000000 ?
110008BA8 ? 1101DD318 ?
1101DD300 ? 000000000 ?
000000000 ? 000000000 ?
rpiope+0064 bl rpidrv 0FFFF4768 ? 6410006148 ?
............
/filedata/ora_log/FFV2PROD/udump/ffv2prod_ora_1544396.trc:内空如下
$ vi ffv2prod_ora_1544396.trc
"ffv2prod_ora_1544396.trc" 40893 lines, 2560418 characters
/filedata/ora_log/FFV2PROD/udump/ffv2prod_ora_1544396.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /opt/oracle/product/9.2.0
System name: AIX
Node name: SHASAX02
Release: 2
Version: 5
Machine: 0009AAB8D600
Instance name: FFV2PROD
Redo thread mounted by this instance: 1
Oracle process number: 144
Unix process pid: 1544396, image: oracle@SHASAX02 (TNS V1-V3)
*** SESSION ID:(44.37145) 2007-06-18 14:05:54.046
*** 2007-06-18 14:05:54.046
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [rpidrv-3], [], [], [], [], [], [], []
Current SQL statement for this session:
create or replace view actuser0703.re_addd_detail as
select p.cntrct_id,
p.branch,
p.risk_code,
p.cstmr_id,
p.Id_Number,
p.name,
p.issue_age,
p.gender,
p.dob,
p.cvrg_issue_dt,
p.process_month,
p.cvrg_status Curr_Status,
pl.cvrg_status LM_Status,
p.cvrg_status_reason Status_Rsn,
p.occupation_class Curr_OC,
pl.occupation_class LM_OC,
Case When r.cm_sa > 350000 Then 'F'
When r.cm_sa > 150000 Then 'A'
Else 'Not_Reinsured' end Curr_Reins_Status,
Case When r.lm_sa > 350000 Then 'F'
When r.lm_sa > 150000 Then 'A'
Else 'Not_Reinsured' end LM_Reins_Status,
p.sa Cntrct_SA,
pl.sa LM_Cntrct_SA,
r.cm_sa Total_SA_per_Life,
r.lm_sa LM_Total_SA_per_Life,
r.cm_ratio CM_Ratio,
r.lm_ratio LM_Ratio,
R.Life_Ratio Life_Ratio, -- should be improved later for surrendered cases
p.lastanndate CM_Lastanndate,
pl.lastanndate LM_Lastanndate,
p.cvrg_status_date,
( Case When (Case When (Case When p.lastanndate Is Null Or p.lastanndate='' Then 0
Else to_number(extract(Year From P.LASTANNDATE) )
End ) < 2005 Then substr(p.process_month, 1, 4)
Else to_char(Extract(Year From P.LASTANNDATE) )
End ) = '2004' Then 0.9
When (Case When (Case When p.lastanndate Is Null Or p.lastanndate='' Then 0
Else to_number(extract(Year From P.LASTANNDATE) )
End ) < 2005 Then substr(p.process_month, 1, 4)
Else to_char(extract(Year From P.LASTANNDATE) )
End ) = '2005' Then 0.95
Else 1
End )
* (Case When p.cvrg_status='IF' Then p.sa Else 0 End ) CM_Mandatory_SA,
( Case When (Case When (Case When pl.lastanndate Is Null Or pl.lastanndate='' Then 0
Else to_number(extract(Year From Pl.LASTANNDATE) )
End ) < 2005 Then substr(pl.process_month, 1, 4)
Else to_char(Extract(Year From Pl.LASTANNDATE) )
End ) = '2004' Then 0.9
When (Case When (Case When pl.lastanndate Is Null Or pl.lastanndate='' Then 0
Else to_number(extract(Year From Pl.LASTANNDATE) )
End ) < 2005 Then substr(pl.process_month, 1, 4)
Else to_char(extract(Year From Pl.LASTANNDATE) )
End ) = '2005' Then 0.95
Else 1
End )
* ( case When pl.cvrg_status='IF' Then pl.sa Else 0 End ) LM_Mandatory_SA,
( (Case When p.cvrg_status='IF' Then p.sa Else 0 End )
* r.cm_ratio ) / 1000 * ( Case p.occupation_class When '4' Then 3.53
When '3' Then 2.82
Else 1.3
End ) CM_Re_Prem,
( Case When pl.cvrg_status='IF' Then pl.sa Else 0 End )
/ 1000 * r.lm_ratio * ( Case pl.occupation_class When '4' Then 3.53
When '3' Then 2.82
Else 1.3
End ) LM_Re_Prem,
( Case When p.cvrg_status='IF'
And ( p.process_month=v.valuation_date_str -- new cases
Or (extract(Year From p.Issue_Dt)<>v.valuation_year -- and renewal cases
And extract(Month From p.issue_dt)=v.valuation_month ) )
Then ( p.sa * r.cm_ratio ) / 1000 * ( Case p.occupation_class When '4' Then 3.53
When '3' Then 2.
82
Else 1.3
End )
When p.cvrg_status='IF'
And p.process_month <> v.valuation_date_str -- NOT new cases
And extract(Month From p.issue_dt) <> v.valuation_month -- and NOT renewal cases
And (p.sa <> nvl(pl.sa, 0) -- sum assured is changed
Or nvl(r.lm_ratio, 0) <> r.cm_ratio -- or ratio is changed
Or p.occupation_class <> pl.occupation_class) -- or occupational class is changed
Then greatest(( ( p.sa * r.cm_ratio ) * ( Case p.occupation_class When '4' Then 3.53
When '3' Then 2.82
Else 1.3
End )
-
pl.sa * r.lm_ratio * ( Case pl.occupation_class When '4' Then 3.53
When '3' Then 2.82
Else 1.3
End ) ), 0) / 1000
* (12 - months_between(v.valuation_begin_date, trunc(p.lastanndate, 'MONTH'))) / 12
Else 0
End ) Effective_Re_Prem, -- Reinsurance Premium charged in the valuation month effectively
Case When r.lm_sa>150000
And ( pl.cvrg_status='IF'
And ((p.cvrg_status_reason='SURRENDERED' Or p.cvrg_status_reason='LAPSED' Or p.cvrg_status_reason='RESCINDED' Or
p.cvrg_status='NI'))
Or (r.cm_ratio < r.lm_ratio
And p.cvrg_status = 'IF')
Or (r.cm_sa < r.lm_sa
And p.cvrg_status ='IF') )
And p.cvrg_id='00263' Then greatest((
pl.sa * r.lm_ratio * ( Case pl.occupation_class When '4' Then 3.53
When '3' Then 2.82
Else 1.3
End )
-
p.sa * r.cm_ratio * ( Case p.occupation_class When '4' Then 3.53
When '3' Then 2.82
Else 1.3
End )
), 0) / 1000
* (Case When p.cvrg_status_reason='RESCINDED' Then 1 -- cooling off cases
When p.cvrg_status= 'TM' And p.cvrg_status_reason<>'RESCINDED' Then 1 - (months_bet
ween(trunc(p.cvrg_status_date,'MONTH'), trunc(p.cvrg_issue_dt, 'MONTH'))-(pl.polyear-1)*12 ) / 12
Else 1 - (months_between(trunc(p.cvrg_status_date,'MONTH'), trunc(p.cvrg_issue_dt,
'MONTH'))-(pl.polyear-1)*12 ) / 12
End)
Else Null
End Recovery_Prem -- Deduction to reinsurance companies
from PROGRAMMEINPUT P
Left Join PROGRAMMEINPUT_LASTMONTH pl
On p.cntrct_id = pl.cntrct_id
And p.risk_code = pl.risk_code
And p.phase = pl.phase
Left Join Re_Addd_Ratio_Table r
On p.Id_Number = r.id_number,
Valuation_Date_Setting v
Where p.risk_code = 'ADDD'
And (p.cvrg_status = 'IF'
Or pl.cvrg_status = 'IF')
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp+0148 bl ksedst 1027C70E4 ?
ksfdmp+0018 bl 01FD82A4
kgerinv+00e8 bl _ptrgl
kgesinv+0020 bl kgerinv 700000203CE85E0 ? 000000000 ?
010320110 ? 11032FDD0 ?
FFFFFFFFFFF3FD0 ?
ksesin+005c bl kgesinv 70000022BBAD360 ? 110006288 ?
FFFFFFFFFFF3F80 ? 110356498 ?
7000002003B3D20 ?
rpidrv+06b4 bl ksesin 102F6B3A8 ? 000000000 ?
110008BA8 ? 1101DD318 ?
1101DD300 ? 000000000 ?
000000000 ? 000000000 ?
rpiope+0064 bl rpidrv 0FFFF4768 ? 6410006148 ?
FFFFFFFFFFF4468 ? 000000000 ?
kqdgtc+02fc bl rpiope 000000000 ?
kqdobr+0060 bl kqdgtc E8000000E8 ?
................

分析解答
1.拿到SQLPLUS中执行,错误一样
SQL> create or replace view ACTUSER0703.RE_ADDD_NEW as
2 Select v.VALUATION_DATE_STR As RE_MONTH,
3 b.abbreviation branch_code,
4 p.cntrct_id,
5 p.Name issued_name,
6 p.risk_code,
7 p.Cntrct_SA,
8 p.CM_Mandatory_SA Net_of_Man,
9 p.Effective_Re_Prem Re_Prem,
10 p.issue_age,
11 p.gender,
12 p.Curr_OC,
13 p.process_month,
14 p.Curr_Reins_Status F_or_A,
15 p.cvrg_issue_dt,
16 p.CM_Lastanndate Lastanndate
17 From ACTUSER.RE_ADDD_DETAIL P, ACTUSER.BRANCH_HIERARCHY_SETTING B, ACTUSER.VALUATION_DATE_SETTING V
18 Where
19 p.branch = b.branch_code
20 And p.Effective_Re_Prem <>0;
From ACTUSER.RE_ADDD_DETAIL P, ACTUSER.BRANCH_HIERARCHY_SETTING B, ACTUSER.VALUATION_DATE_SETTING V
*
ERROR at line 17:
ORA-00604: error occurred at recursive SQL level 1
ORA-00600: internal error code, arguments: [rpidrv-3], [], [], [], [], [], [], []
2.查看matelink
TIP: Click help for a detailed explanation of this page.
Bookmark Go to End
Subject: ORA-600 [rpidrv-3]
Doc ID: Note:285965.1 Type: REFERENCE
Last Revision Date: 23-JUN-2005 Status: PUBLISHED

Note: For additional ORA-600 related information please read Note 146580.1
PURPOSE:
This article represents a partially published OERI note.
It has been published because the ORA-600 error has been
reported in at least one confirmed bug.
Therefore, the SUGGESTIONS section of this article may help
in terms of identifying the cause of the error.
This specific ORA-600 error may be considered for full publication
at a later date. If/when fully published, additional information
will be available here on the nature of this error.
SUGGESTIONS:
If the Known Issues section below does not help in terms of identifying
a solution, please submit the trace files and alert.log to Oracle
Support Services for further analysis.
Known Issues:
Bug# 2949392 See Note 2949392.8
OERI[rpidrv-3] creating a view based on a non-existent table
Fixed: 9.2.0.5, 10.1.0.2
3.查看了SQL中的所用到的表都存在,这下怪了.按matelink上说的creating a view based on a non-existent table,一一都查过了,存在啊.正在不解时,突然注意到所涉及到表的OWNER都是 ACTUSER.猜想难道是没有这个 ACTUSER0703了,于是做了如下测试、检查

SQL> create or replace view ACTUSER.RE_ADDD_NEW as
2 Select v.VALUATION_DATE_STR As RE_MONTH,
3 b.abbreviation branch_code,
4 p.cntrct_id,
5 p.Name issued_name,
6 p.risk_code,
7 p.Cntrct_SA,
8 p.CM_Mandatory_SA Net_of_Man,
9 p.Effective_Re_Prem Re_Prem,
10 p.issue_age,
11 p.gender,
12 p.Curr_OC,
13 p.process_month,
14 p.Curr_Reins_Status F_or_A,
15 p.cvrg_issue_dt,
16 p.CM_Lastanndate Lastanndate
17 From ACTUSER.RE_ADDD_DETAIL P, ACTUSER.BRANCH_HIERARCHY_SETTING B, ACTUSER.VALUATION_DATE_SETTING V
18 Where
19 p.branch = b.branch_code
20 And p.Effective_Re_Prem <>0;
View created.
SQL> drop view ACTUSER.RE_ADDD_NEW;
View dropped.

SQL> select owner,object_name from dba_objects where owner='ACTUSER0703';
no rows selected
SQL> select * from dba_users where username='ACTUSER0703';
no rows selected
SQL> select * from dba_users where username='ACTUSER';
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE
--------------- ---------- ------------------------------ -------------------------------- --------------- ---------------
DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE
------------------------------ ------------------------------ --------------- ------------------------------
INITIAL_RSRC_CONSUMER_GROUP
------------------------------
EXTERNAL_NAME
------------------------------------------------------------------------------------------------------------------------------------
ACTUSER 453 8E389984B79B8A83 OPEN 17-JUL-07
USERS2 TEMP 28-JUN-06 LIMITSESSIONS6
DEFAULT_CONSUMER_GROUP

PS:
SQL> select * from v$version where rownum<2;BANNER----------------------------------------------------------------Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production

SQL> host$ uname -a
AIX 2 5 0009AAB8D600

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7364032/viewspace-17469/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-06

  • 博文量
    163
  • 访问量
    1315173