Oracle Jserver
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle Jserver

  1. #1
    Join Date
    Aug 2003
    Posts
    54

    Oracle Jserver

    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????

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    For your second question, you can run

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

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Aug 2003
    Posts
    54
    SAM,

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

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Metalink Note:209870.1
    Subject: How to Reload the JVM in 9.2.0.X

    Code:
         -- 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
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width