在安裝以前可以在Oracle_HOME/javavm 目錄下找到readme,另外注重的是所有jvm相關的sql都必須用sys as sysdba權限.
先決條件:
1:rollback segment至少100m
2:System tablespace,所有的腳本大概要消耗130m,initjvm.sql 所產生
的objects 消耗接近90m空間.
3:Shared_pool_size >=50m
4:Java_pool_size >=30m
pool sizes 大小可以用
select * from v$sgastat where name = 'free memory' 檢定.
安裝過程:
1:***INITJVM.SQL***
SQL>set echo on
SQL>spool jvminst.log
SQL>@/javavm/install/initjvm.sql
SQL>spool off
作用:載入初始用來支持java應用的java類包,初始化支持java和corba的名字空間的表,以及發布頂層調用的入口指針.
支持的java類包括:
The standard Java runtime
Bytecode verifier and optimizer
Java and SQLJ compilers
JDBC runtime
CORBA ORB and EJB runtime
Some additional support classes, sUCh as DBMS_JAVA, which are
described in "Package DBMS_JAVA"
initjvm.sql 同時做以下動作:
1:將類載入SYS schema
2:建立這些類的同義詞,使可以被所有用戶訪問.
3:調整一些類的權限使支持CORBA callouts.
4:定義一些數據庫start up 和shut down觸發器.
注重:假如initjvm.sql 運行失敗,在重新運行以前必須先執行rmjvm.sql,安裝失敗一般都是因為資源不足的問題,比如memory 和tablespace
2:***INITxml.SQL***
SQL>set echo on
SQL>spool initxml.log
SQL>@?/oracore/admin/initxml.sql
SQL>spool off
主要功能:
將xml 組件load到jserver里,可以利用plsql的接口對xlm進行擴展.
XML Parser for PL/SQL 支持 W3C XML 1.0 規范
3:***CATXSU.SQL***
SQL>set echo on
SQL>spool catxsu.log
SQL>@?/rdbms/admin/catxsu.sql
SQL>spool off
主要功能:
將XMLSQL Utility (XSU)裝入數據庫,主要用來做data transformation,
將關系型的數據的SQL query result轉換到xml格式,反之依然.
***INIT_JIS.SQL***
SQL>set echo on
SQL>spool init_jis.log
SQL>@?/javavm/install/init_jis.sql
SQL>spool off
主要功能:
用來安裝Oracle Servlet Engine (OSE)的,OSE象一個特定的web server一樣工作,servlet類 通過java載入命令置入數據庫,并在數據庫的namespace 里注冊,A servlet runner 處理HTTP 請求,publise serverlet進程,invoke serverlet 方法.
***JISJA.SQL***
主要功能:
主要用來使能JAccelerator (ncomp) for JIS,對優化性能有幫助,JServer Accelerator 通過ncomp工具將java類編譯成共享庫,來提高執行效率.
***JISAEPHC.SQL***
SQL>set echo on
SQL>spool jisaephc.log
SQL>@?/javavm/install/jisaephc.sql
SQL>spool off
主要功能:
OSE 安裝完畢后,Adds the set of default end points to the server with hardcoded values for the admin service
***INITPLGS.SQL***
SQL>set echo on
SQL>spool initplgs.log
SQL>@?
/rdbms/admin/initplgs.sql
SQL>spool off
主要功能:
將PLSQL Gateway Servlet 的jar文件裝入數據庫,這個使plsql的存儲過程可以象servelet那樣運行,PL/SQL 過程可以在web上運行而無需做任何改裝,
***INITjsp.SQL***
SQL>set echo on
SQL>spool initjsp.log
SQL>@?/jsp/install/initjsp.sql
SQL>spool off
主要功能:
用來安裝Java Server Pages (JSP) ,
***JSPJA.SQL***
SQL>spool jspja.log
SQL>@?/jsp/install/jspja.sql
SQL>spool off
主要功能:
用JAccelerator 來performace jsp功能組件,以native 方式編譯java代碼.
***INITPLSJ.SQL***
SQL>spool initplsj.log
SQL>@?/rdbms/admin/initplsj.sql
SQL>spool off
主要功能:
初始化plsql 的java類庫
***INITJMS.SQL***
SQL>spool initjms.log
SQL>@?/rdbms/admin/initjms.sql
SQL>spool off
主要功能:
將AQ/JMS 載入數據庫,oracle ssaging Service (JMS)提供了一組java api來支持Advanced Queuing based on the JMS standard,
***INITREPAPI.SQL***
SQL>spool initrepapi.log
SQL>@?/rdbms/admin/initrepapi.sql
SQL>spool off
主要功能:
This script loads RepAPI server classes and publishes the 'repapi' objects
The RServer.class and its helper class are published in /etc namespace. RepAPI is a runtime library that enables clients to replicate data with Oracle servers.
***INITSOXX.SQL***
SQL>spool initsoxx.log
SQL>@?/rdbms/admin/initsoxx.sql
SQL>spool off
主要功能:
This script loads objects, extensibility and xml related java classes into the database.
***JISAEP.SQL***
SQL>spool jisaep.log
SQL>@?/javavm/install/jisaep admin 8080 9090
SQL>spool off
主要功能:
將OSE 配置成缺省的web服務,需要2個或三個參數
1:服務名,2:TCP 端口,3: ssl端口
-----
如何檢定安裝是否成功:
新裝的數據庫,即運行過catalog.sql 和 catPRoc.sql后,數據庫里并沒載入java對象,可以通過查詢DBA_OBJECTS,條件是OBJECT_TYPE like 'JAVA%'來檢查.
select count(*) from DBA_OBJECTS where OBJECT_TYPE like 'JAVA%'; This should return a count of 6785.
查找無效java對象
select count(*) from DBA_OBJECTS
where OBJECT_TYPE like 'JAVA%' and STATUS = 'INVALID';
假如數量小于第一個查詢的值或第二個查詢有返回,可能就需要瀏覽一下spool 的log,來找原因了.
INITJVM.SQL CREATES:
-
3 functions
4 indexes
6438 java classes
290 java data
57 java resources
6 packages
1 sequence
6443 synonyms
8 tables
2 triggers
3 views
SQL> select count(*), object_type from dba_objects where object_type like 'JAVA%' group by object_type;
6438 JAVA CLASS
290 JAVA DATA
57 JAVA RESOURCE
6785
INITXML.SQL CREATES:
-
2 indexes
272 classes
31 java resources
1 lob
19 packages
272 synonyms
2 tables
CATXSU.SQL
CREATES:
29 classes
30 java resources
3 packages
3 synonyms
INIT_JIS.SQL
CREATES: --
12 indexes
2384 classes
10 java resources
1 lob
13 packages
5 sequences
2400 synonyms
17 tables
1 trigger
1 view
JISJA.SQL
CREATES: ------------------
154 classes
8 java sources
1 procedure
3 tables
JISAEPHC.SQL
CREATES: --
No new objects......
INITPLGS.SQL
CREATES: --
1 class
1 synonym
INITJSP.SQL
CREATES: -
275 classes
2 java resources
275 synonyms
JSPJA.SQL
CREATES: ------------------
20 classes
INITPLSJ.SQL
CREATES: --
2 classes
INITJMS.SQL CREATES: -
159 classes 159 synonyms
INITREPAPI.SQL
CREATES: ----
71 classes
71 synonyms
INITSOXX.SQL
CREATES: --
37 classes
37 synonyms
JISAEP.SQL
CREATES:
No new objects.....
TOTALS AFTER THE EXECUTION OF ALL SCRIPTS:
----
SQL>select count(*) from dba_objects
where object_type like 'JAVA%' and owner = 'SYS';
COUNT(*) ---------- 10270
SQL>select count(*) from dba_objects
where object_type like 'JAVA%' and status = 'INVALID' and owner = 'SYS';
COUNT(*) ---------- 0
