|
|
删除JVM 组件后 再行升级 没有报相同的错!
删除的脚本为。只适用于9i
-- Start of File full_rmjvm.sql
spool full_rmjvm.log
set echo on
connect / as sysdba
startup mount
alter system set "_system_trig_enabled" = false scope=memory;
alter system enable restricted session;
alter database open;
start ?/rdbms/admin/catnojav.sql
start ?/xdk/admin/rmxml.sql
start ?/javavm/install/rmjvm.sql
truncate table java$jvm$status;
select * from obj$
where obj#=0 and type#=0;
delete from obj$
where obj#=0 and type#=0;
commit;
select owner, count(*) from all_objects
where object_type like '%JAVA%' group by owner;
select obj#, name from obj$
where type#=28 or type#=29 or type#=30 or namespace=32;
select o1.name from obj$ o1,obj$ o2
where o1.type#=5 and o1.owner#=1 and o1.name=o2.name and o2.type#=29;
shutdown immediate
set echo off
spool off
exit
-- End of File full_rmjvm.sql |
|