ndu.user#=o.owner#;
ddl_statement varchar2(200);
iterations number;
previous_iterations number;
loop_count number;
my_err number;
begin
previous_iterations := 10000000;
loop
-- To make sure we eventually stop,pick a maxnumber of iterations
select count(*) into iterations from obj$ wheretype#=56;
exit when iterations=0 or iterations >=previous_iterations;
previous_iterations := iterations;
loop_count := 0;
open C1;
loop
begin
fetch C1 intoddl_statement;
exit when C1%NOTFOUND orloop_count > iterations;
exception when others then
my_err := sqlcode;
if my_err = -1555then --snapshot too old, re-execute fetch query
exit;
else
raise;
end if;
end;
initjvmaux.exec(ddl_statement);
loop_count := loop_count + 1;
end loop;
close C1;
end loop;
end;
commit;
initjvmaux.drp('delete fromjava$policy$shared$table');
update obj$ set status=1 where obj#=(select obj# fromobj$,javasnm$
where owner#=0 and type#=29 and short(+)=name and
nvl(longdbcs,name)='oracle/aurora/rdbms/Compiler');
commit;
end;
/
--2分钟左右
create or replace java system
/
--十分钟左右
11. 在编译一次无效对象
SQL> @ /rdbms/admin/utlrp.sql;
--脚本执行时会产生大量的online redo,所以要保证有足够的online redo 来切换。
--这里突然想到把第九步的编译无效对象省略,放到这里一起执行,应该可以节省半个小时,不过这里不能测试了。
在执行脚本的过程中,session异常中断,在alert log和 trace里都有:ORA-7445的错误:
ORA-07445: exception encountered: core dump[__intel_new_memcpy()+2164] [SIGSEGV] [ADDR:0x7F2F0CBBD2BF] [PC:0x47ED7D4][Address not mapped to object] []
----- Current SQL Statement for thissession (sql_id=2y0pxmcj6k00t) -----
ALTER VIEW"OLAPSYS"."ALL$OLAP2_AW_CATALOGS" COMPILE
导致这个问题,是因为我们启动了OLAP,在32位转到64位时就会遇到这种错误。
12. 处理OLAP 问题
--查看组件
SQL> select comp_id,comp_name,version,status from dba_registry;
COMP_ID COMP_NAME VERSION STATUS
----------------------------------------------- ------------ ------------------
OWB OWB 11.2.0.3.0 VALID
APEX Oracle Application Express 3.2.1.00.12 VALID
EM Oracle Enterprise Manager 11.2.0.3.0 VALID
AMD OLAP Catalog 11.2.0.3.0 INVALID
SDO Spatial 11.2.0.3.0 INVALID
ORDIM Oracle Multimedia 11.2.0.3.0 INVALID
XDB Oracle XML Database 11.2.0.3.0 INVALID
CONTEXT Oracle Text 11.2.0.3.0 VALID
EXF Oracle Expression Filter 11.2.0.3.0 INVALID
RUL Oracle Rules Manager 11.2.0.3.0 INVALID
OWM Oracle Workspace Manager 11.2.0.3.0 INVALID
COMP_ID COMP_NAME VERSION STATUS
----------------------------------------------- ------------ ------------------
CATALOG Oracle Database Catalog Views 11.2.0.3.0 INVALID
CATPROC Oracle Database Packages and Types 11.2.0.3.0 INVALID
JAVAVM JServer JAVA Virtual Machine 11.2.0.3.0 VALID
XML Oracle XDK 11.2.0.3.0 VALID
CATJAVA Oracle Database Java Packages 11.2.0.3.0 VALID
APS