create table as 报ora-600错误解决方案

作者简介:王承宇,现就职于北京海天起点长春办事处,吉林电信项目组成员,持有OCP 10g,具有5年以上数据库维护服务经验,擅长于OGG和Oracle搭建方案的制定、运维优化及故障诊断。

电信日志中报错如下:

Mon May 15 19:02:54 2017

Errors in file /oracle/app/diag/rdbms/rapjl/rapjl/trace/rapjl_ora_48278.trc  (incident=480388):

ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

Incident details in: /oracle/app/diag/rdbms/rapjl/rapjl/incident/incdir_480388/rapjl_ora_48278_i480388.trc

Use ADRCI or Support Workbench to package the incident.

See Note 4OPatchSession cannot load inventory for the given Oracle Home /u01/app/grid/11.2.0. Possible causes are:
No read or write permission to ORACLE_HOME/.patch_storage
Central Inventory is locked by another OUI instance
No read permission to Central Inventory
The lock file exists in ORACLE_HOME/.patch_storage
The Oracle Home does not exist in Central Inventory

11.1 at My Oracle Support for error and packaging details.

trc文件内容:

去掉create table,只有select, 是可以成功的.所以尝试把create table 改为create view 是可以成功的. 但是使用此viewcreate table还是报错。

查询metalink搜索此错误: create table [rwoirw: check ret val]

采用下面的方案,问题解决
alter session set “_pred_move_around”=true;

未经允许不得转载:Oracle一体机用户组 » create table as 报ora-600错误解决方案

相关推荐