Oracle Jserver

[candyman]

I got a full dump file from my client and I import this dump into my database. I noticed that they had Jserver on their database so that I have two unused schema on mine when I did the full import. The name of these two schemas are AURORA$JIS$UTILITY$,OSE$HTTP$ADMIN. Since I don't use Jserver, I guess I can drop these two schemas, but I want to confirm with you guys first. Secondly, let's assume, I did have Jserver before and I want to take Jserver out of my database, is there any scripts from Oracle I can run????

[sambavan]

For your second question, you can run

$ORACLE_HOME/rdbms/admin/rmjvm.sql which will remove all the java objects period.

Sam

[candyman]

SAM,

thanks for your reply but the script is for prior to 8i

[sambavan]

Metalink Note:209870.1
Subject: How to Reload the JVM in 9.2.0.X

     -- Start of File full_rmjvm.sql
     spool full_rmjvm.log
     set echo on
     connect / as sysdba
     startup mount
     alter system set "_system_trig_enabled" = fals scope=memory;
     alter system enable restricted session;
     alter database open;
     show parameters _system 
     @?/rdbms/admin/rmaqjms.sql
     @?/rdbms/admin/rmcdc.sql
     @?/xdk/admin/rmxml.sql
     @?/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

Sam