前面都安装都是正常,
os :Linux vamdb1 2.4.21-37.EL #1 SMP Wed Sep 7 13:32:18 EDT 2005 x86_64 x86_64 x86_64 GNU/Linux
oracle 9204 64位
在升级rac oracle9204到oracle 9206过程中执行
SQL> @?/rdbms/admin/catpatch.sql
在执行到一半的时候异常
起先是:
在编译:xdb.resource_view 视图时无法编译通过
单独 执行
select value(p) res, abspath(9999) any_path
from xdb.xdb$resource p
where under_path(value(p), '/', 9999) = 1
报:
ORA-30554 function-based index string.string is disabled
注;xdb.path_view,xdb.resource_view在数据中库体现为无效。(在没有升级之前,这两个包也是无效的)
然后经过一段时间后
在监控到升级脚本包在执行
select x.schema_url from dba_xml_schemas x, dba_objects o where o.object_type = 'XML SCHEMA' and o.status != 'VALID' and o.object_name = x.int_objname
停止一段时后,就断开数据库链接
在alter_sid.log中报如下
/**********************************/
Tue Apr 17 11:09:48 2007
Errors in file /opt/oracle/admin/vam/udump/vam1_ora_16855.trc:
ORA-00600: internal error code, arguments: [17059], [0x1B5FDA388], [], [], [], [], [], []
Tue Apr 17 11:09:50 2007
Errors in file /opt/oracle/admin/vam/udump/vam1_ora_16855.trc:
ORA-07445: exception encountered: core dump [xplFetchRow()+1032] [SIGSEGV] [Address not mapped to object] [0x000000009] [] []
ORA-00600: internal error code, arguments: [17059], [0x1B5FDA388], [], [], [], [], [], []
Tue Apr 17 11:09:53 2007
Trace dumping is performing id=[cdmp_20070417110953]
Tue Apr 17 11:15:42 2007
Errors in file /opt/oracle/admin/vam/udump/vam1_ora_5897.trc:
ORA-00600: internal error code, arguments: [17059], [0x1B8692910], [], [], [], [], [], []
Tue Apr 17 11:15:43 2007
Trace dumping is performing id=[cdmp_20070417111543]
/**********************************/
单独执行 SELECT * FROM dba_xml_schemas ;
ORA-00600: internal error code, arguments: [17059], [0x1B5FDA388], [], [], [], [], [], []
包编译见附件:
请高手指教一下,接下来要如何做!
感激万分!!!
[此贴子已经被作者于2007-4-17 16:11:51编辑过]