ORA错误记录

2012-9-7 10:43:03:

Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_21692692.trc  (incident=842436):
ORA-00600: 内部错误代码, 参数: [kdoirp-1], [2], [], [], [], [], [], []
Incident details in: /oracle/diag/rdbms/sgerp5/sgerp5/incident/incdir_842436/sgerp5_ora_21692692_i842436.trc

Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_9634226.trc  (incident=842524):
ORA-00600: 内部错误代码, 参数: [kcblibr_1], [18872209], [17], [0], [0], [], [], []
Incident details in: /oracle/diag/rdbms/sgerp5/sgerp5/incident/incdir_842524/sgerp5_ora_9634226_i842524.trc

 

Error 600 trapped in 2PC on transaction 57.32.37224. Cleaning up.
Error stack returned to user:
ORA-00600: 内部错误代码, 参数: [kdoirp-1], [2], [], [], [], [], [], []
Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_21692692.trc  (incident=842437):
ORA-00603: ORACLE 服务器会话因致命错误而终止
ORA-00600: 内部错误代码, 参数: [kdoirp-1], [2], [], [], [], [], [], []
Incident details in: /oracle/diag/rdbms/sgerp5/sgerp5/incident/incdir_842437/sgerp5_ora_21692692_i842437.trc
ORA-603 : opiodr aborting process unknown ospid (21692692_1)

 

Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_21168566.trc  (incident=842628):
ORA-00600: 内部错误代码, 参数: [kcblibr_1], [19636881], [17], [0], [0], [], [], []
Incident details in: /oracle/diag/rdbms/sgerp5/sgerp5/incident/incdir_842628/sgerp5_ora_21168566_i842628.trc

Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_27590750.trc  (incident=842372):
ORA-00600: 内部错误代码, 参数: [4552], [2], [128], [], [], [], [], []
Incident details in: /oracle/diag/rdbms/sgerp5/sgerp5/incident/incdir_842372/sgerp5_ora_27590750_i842372.trc

Trace dumping is performing id=[cdmp_20120907142245]
Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_21168566.trc  (incident=842629):
ORA-00600: 内部错误代码, 参数: [kcblibr_1], [19636881], [17], [0], [0], [], [], []
Incident details in: /oracle/diag/rdbms/sgerp5/sgerp5/incident/incdir_842629/sgerp5_ora_21168566_i842629.trc

 

 

Error 600 trapped in 2PC on transaction 26.28.141360. Cleaning up.
Error stack returned to user:
ORA-00600: 内部错误代码, 参数: [4552], [2], [128], [], [], [], [], []
Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_27590750.trc  (incident=842373):
ORA-00603: ORACLE 服务器会话因致命错误而终止
ORA-00600: 内部错误代码, 参数: [4552], [2], [128], [], [], [], [], []
Incident details in: /oracle/diag/rdbms/sgerp5/sgerp5/incident/incdir_842373/sgerp5_ora_27590750_i842373.trc
ORA-603 : opiodr aborting process unknown ospid (27590750_1)

 

Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_27132126.trc  (incident=842460):
ORA-00600: 内部错误代码, 参数: [17182], [0x11058DBA8], [], [], [], [], [], []
Incident details in: /oracle/diag/rdbms/sgerp5/sgerp5/incident/incdir_842460/sgerp5_ora_27132126_i842460.trc

 

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFFDFFFF70] [PC:0x1003ADC64, kdr9ir2rst0()+0064]
Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_26083392.trc  (incident=841684):
ORA-07445: 出现异常错误: 核心转储 [kdr9ir2rst0()+0064] [SIGSEGV] [ADDR:0xFFFFFFFFDFFFF70] [PC:0x1003ADC64] [Address not mapped to object] []
Incident details in: /oracle/diag/rdbms/sgerp5/sgerp5/incident/incdir_841684/sgerp5_ora_26083392_i841684.trc

 

Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_9830426.trc  (incident=843292):
ORA-00600: 内部错误代码, 参数: [qeshQBNextLoad.1], [], [], [], [], [], [], []
Incident details in: /oracle/diag/rdbms/sgerp5/sgerp5/incident/incdir_843292/sgerp5_ora_9830426_i843292.trc

 

Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_26017838.trc  (incident=842668):
ORA-00600: 内部错误代码, 参数: [kcblibr_1], [22035473], [17], [0], [0], [], [], []
Incident details in: /oracle/diag/rdbms/sgerp5/sgerp5/incident/incdir_842668/sgerp5_ora_26017838_i842668.trc

 

Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_4522298.trc:
ORA-03135: 连接失去联系
ORA-00600: 内部错误代码, 参数: [kcbnew_3], [0], [20061329], [8192], [], [], [], []
Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_4522298.trc:
ORA-03113: 通信通道的文件结束
Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_4522298.trc  (incident=842541):
ORA-00600: 内部错误代码, 参数: [17090], [], [], [], [], [], [], []
Incident details in: /oracle/diag/rdbms/sgerp5/sgerp5/incident/incdir_842541/sgerp5_ora_4522298_i842541.trc

 

 

Error 600 trapped in 2PC on transaction 13.32.294404. Cleaning up.
Error stack returned to user:
ORA-00600: 内部错误代码, 参数: [17182], [0x11058DBA8], [], [], [], [], [], []
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x120060263140A08] [PC:0x10016010C, kghrst()+020c]
Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_27132126.trc  (incident=842461):
ORA-07445: 出现异常错误: 核心转储 [kghrst()+020c] [SIGSEGV] [ADDR:0x120060263140A08] [PC:0x10016010C] [Address not mapped to object] []
ORA-00600: 内部错误代码, 参数: [17182], [0x11058DBA8], [], [], [], [], [], []
Incident details in: /oracle/diag/rdbms/sgerp5/sgerp5/incident/incdir_842461/sgerp5_ora_27132126_i842461.trc

 

 

2012-9-7 16:14:51:

Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_4522298.trc  (incident=842542):
ORA-00600: 内部错误代码, 参数: [], [], [], [], [], [], [], []
ORA-00600: 内部错误代码, 参数: [17090], [], [], [], [], [], [], []
ORA-06512: 在 line 1
Incident details in: /oracle/diag/rdbms/sgerp5/sgerp5/incident/incdir_842542/sgerp5_ora_4522298_i842542.trc

 

ORA-00054 resource busy and acquire with NOWAIT specified
ORA-12542 tns address already in use

 

Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_18153912.trc  (incident=907488):
ORA-04031: 无法分配 3896 字节的共享内存 ("shared pool","SELECT * FROM (SELECT C.CONT...","sga heap(1,0)","kglsim object batch")
Fri Sep 28 10:08:03 2012
Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_20381990.trc  (incident=907975):
ORA-04031: 无法分配 3896 字节的共享内存 ("shared pool","DELETE FROM "000".TBFINPAYBI...","sga heap(1,0)","kglsim object batch")
Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_20381990.trc  (incident=907976):
ORA-04031: 无法分配 3896 字节的共享内存 ("shared pool","DELETE FROM "000".TBFINPAYBI...","sga heap(2,0)","kglsim object batch")
Fri Sep 28 10:08:12 2012

### 常见的 Oracle 数据库 ORA 错误及其解决方案 #### ORA-00942 表或视图不存在 当尝试访问不存在的表或视图时会触发此错误。这可能是由于拼写错误、权限不足或是对象确实未创建。 ```sql SELECT * FROM non_existent_table; -- 将返回 ORA-00942: table or view does not exist [^1] ``` 为了修复这个问题,确认目标表名正确无误并拥有适当的操作权限。 #### ORA-01403 未找到数据 该异常发生在查询期望至少一条记录而实际并未检索到任何行的情况下。这不是致命错误,在某些逻辑判断场景下属于正常现象。 ```sql SELECT column_name INTO variable FROM dual WHERE condition; -- 如果条件不满足则抛出 ORA-01403 ``` 处理方式取决于业务需求,可以设计程序来优雅地应对这种情况,比如设置默认值给变量。 #### ORA-00904 非法列名 指定了一个非法或者不允许在此上下文中使用的列名称就会引发这个错误。通常是因为输入了错别字或者是试图引用尚未定义好的字段。 ```sql SELECT invalid_column FROM valid_table; -- 这里invalid_column是虚构的名字, 导致ORA-00904 ``` 仔细检查SQL语句中的所有标识符是否准确对应数据库里的实体即可解决问题。 #### ORA-01722 转换错误 (无效数) 如果尝试将无法转换成数值的数据作为算术表达式的操作数,则会出现此类警告。例如字符串'abc'被当作整型参与计算。 ```sql INSERT INTO some_table VALUES ('abc'); -- 若some_table某列为NUMBER类型, 则可能报ORA-01722 ``` 确保传入的数据格式匹配预期的目标属性,并且遵循正确的语法规范能够有效预防这类问题的发生。 #### ORA-01858 在日期/时间函数中发现非数字字符 这是因为在解析日期串的时候遇到了不符合标准格式的内容所引起的。如使用`TO_DATE()`函数时提供了不合规格的时间描述。 ```sql SELECT TO_DATE('not a date', 'YYYY-MM-DD') FROM DUAL; -- 此处参数明显不对, 抛出ORA-01858 ``` 提供严格遵照规定模式编写的日期字符串可避免上述情况发生;另外也可以利用正则表达式验证输入合法性后再做进一步处理。 ---
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值