数据库是两个节点的RAC，每个节点都有两个不同的数据库（epay和wldb），epay库的alert日志（两个节点均有）间歇性（每天一到两次或几天出现一次）的出现报错ORA-600和ORA-7445错误，代码如下：
ORA-00600: internal error code, arguments: [17147], [0xFFFFFFFF7DF77130], [], [], [], [], [], [], [], [], [], []
ORA-24365: error in character conversion
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [17114], [0xFFFFFFFF7DF77130], [], [], [], [], [], [], [], [], [], []
Incident details in: /epayrac/oracle/diag/rdbms/epay/epay1/incident/incdir_476999/epay1_ora_29550_i476999.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x1082D9408, kgherrordmp()+1192] [flags: 0x0, count: 1]
Errors in file /epayrac/oracle/diag/rdbms/epay/epay1/trace/epay1_ora_29550.trc (incident=477000):
ORA-07445: exception encountered: core dump [kgherrordmp()+1192] [SIGSEGV] [ADDR:0x0] [PC:0x1082D9408] [Address not mapped to object] []
ORA-00600: internal error code, arguments: [17147], [0xFFFFFFFF7DF77130], [], [], [], [], [], [], [], [], [], []
ORA-24365: error in character conversion
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [17114], [0xFFFFFFFF7DF77130], [], [], [], [], [], [], [], [], [], []
Incident details in: /epayrac/oracle/diag/rdbms/epay/epay1/incident/incdir_477000/epay1_ora_29550_i477000.trc
ORA-00600[17114]和ORA-07445[kgherrordmp()+1192]通常有以下几种情况：
1、有表上存在部分字段损坏，可以使用select where rowid循环的方式去排查是否存在
2、内存有坏块
3、使用NDATE、NVARCHAR转换
4、SQL中使用XML、CLOB等情况
现在没有SQL和相关对象无法准确定位，如果方便请提供下这个存储过程进一步分析：PSTORE_RISK_CONTROL
评论
有用 0
我们这边有用到sybase数据库，oracle这边通过透明网关调用sybase的数据，经常发现存在通过透明网关调用sybase的oracle存储过程会较为频繁的出现invaild状态。不知道是否与此有关。
评论 有用 0基于目前的信息，可以定位到错误应该是出现在INSERT INTO "excp_trade_monitor_log"@umps这一步。这样的做法其实很少见，就连oracle到oracle dblink的insert都比较少，分布式事物不可控的地方太多了，更何况是异构的数据库。
建议先将数据落到Oracle本地表，然后再通过数据同步工具OGG之类的同步到sybase上。
评论 有用 0
墨值悬赏