在安装以前可以在ORACLE_HOME/javavm 目录下找到readme另外注意的是所有jvm相关的sql都必须用sys as sysdba权限
先决条件:
:rollback segment至少m
:System tablespace所有的脚本大概要消耗minitjvmsql 所产生
的objects 消耗接近m空间
:Shared_pool_size >=m
:Java_pool_size >=m
pool sizes 大小可以用
select * from v$sgastat where name = free memory 检定
安装过程:
:***INITJVMSQL***
SQL>set echo on
SQL>spool jvminstlog
SQL>@/javavm/install/initjvmsql
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
initjvmsql 同时做以下动作:
:将类载入SYS schema
:建立这些类的同义词使可以被所有用户访问
:调整一些类的权限使支持CORBA callouts
:定义一些数据库start up 和shut down触发器
注意:如果initjvmsql 运行失败在重新运行以前必须先执行rmjvmsql安装失败一般都是因为资源不足的问题比如memory 和tablespace
:***INITXMLSQL***
SQL>set echo on
SQL>spool initxmllog
SQL>@?/oracore/admin/initxmlsql
SQL>spool off
主要功能:
将xml 组件load到jserver里可以利用plsql的接口对xlm进行扩展
XML Parser for PL/SQL 支持 WC XML 规范
:***CATXSUSQL***
SQL>set echo on
SQL>spool catxsulog
SQL>@?/rdbms/admin/catxsusql
SQL>spool off
主要功能:
将XMLSQL Utility (XSU)装入数据库主要用来做data transformation
将关系型的数据的SQL query result转换到xml格式反之依然
***INIT_JISSQL***
SQL>set echo on
SQL>spool init_jislog
SQL>@?/javavm/install/init_jissql
SQL>spool off
主要功能:
用来安装Oracle Servlet Engine (OSE)的OSE象一个特定的web server一样工作servlet类 通过java载入命令置入数据库并在数据库的namespace 里注册A servlet runner 处理HTTP 请求publise serverlet进程invoke serverlet 方法
***JISJASQL***
主要功能:
主要用来使能JAccelerator (ncomp) for JIS对优化性能有帮助JServer Accelerator 通过ncomp工具将java类编译成共享库来提高执行效率
***JISAEPHCSQL***
SQL>set echo on
SQL>spool jisaephclog
SQL>@?/javavm/install/jisaephcsql
SQL>spool off
主要功能:
OSE 安装完毕后Adds the set of default end points to the server with hardcoded values for the admin service
***INITPLGSSQL***
SQL>set echo on
SQL>spool initplgslog
SQL>@?/rdbms/admin/initplgssql
SQL>spool off
主要功能:
将PLSQL Gateway Servlet 的jar文件装入数据库这个使plsql的存储过程可以象servelet那样运行PL/SQL 过程可以在web上运行而无需做任何改装
***INITJSPSQL***
SQL>set echo on
SQL>spool initjsplog
SQL>@?/jsp/install/initjspsql
SQL>spool off
主要功能:
用来安装Java Server Pages (JSP)
***JSPJASQL***
SQL>spool jspjalog
SQL>@?/jsp/install/jspjasql
SQL>spool off
主要功能:
用JAccelerator 来performace jsp功能组件以native 方式编译java代码
***INITPLSJSQL***
SQL>spool initplsjlog
SQL>@?/rdbms/admin/initplsjsql
SQL>spool off
主要功能:
初始化plsql 的java类库
***INITJMSSQL***
SQL>spool initjmslog
SQL>@?/rdbms/admin/initjmssql
SQL>spool off
主要功能:
将AQ/JMS 载入数据库oracle ssaging Service (JMS)提供了一组java api来支持Advanced Queuing based on the JMS standard
***INITREPAPISQL***
SQL>spool initrepapilog
SQL>@?/rdbms/admin/initrepapisql
SQL>spool off
主要功能:
This script loads RepAPI server classes and publishes the repapi objects
The RServerclass and its helper class are published in /etc namespace RepAPI is a runtime library that enables clients to replicate data with Oracle servers
***INITSOXXSQL***
SQL>spool initsoxxlog
SQL>@?/rdbms/admin/initsoxxsql
SQL>spool off
主要功能:
This script loads objects extensibility and xml related java classes into the database
***JISAEPSQL***
SQL>spool jisaeplog
SQL>@?/javavm/install/jisaep admin
SQL>spool off
主要功能:
将OSE 配置成缺省的web服务需要个或三个参数
:服务名:TCP 端口: ssl端口
如何检定安装是否成功:
新装的数据库即运行过catalogsql 和 catprocsql后数据库里并没载入java对象可以通过查询DBA_OBJECTS条件是OBJECT_TYPE like JAVA%来检查
select count(*) from DBA_OBJECTS where OBJECT_TYPE like JAVA%; This should return a count of
查找无效java对象
select count(*) from DBA_OBJECTS
where OBJECT_TYPE like JAVA% and STATUS = INVALID;
如果数量小于第一个查询的值或第二个查询有返回可能就需要浏览一下spool 的log来找原因了
INITJVMSQL CREATES:
functions
indexes
java classes
java data
java resources
packages
sequence
synonyms
tables
triggers
views
SQL> select count(*) object_type from dba_objects where object_type like JAVA% group by object_type;
JAVA CLASS
JAVA DATA
JAVA RESOURCE
INITXMLSQL CREATES:
indexes
classes
java resources
lob
packages
synonyms
tables
CATXSUSQL
CREATES:
classes
java resources
packages
synonyms
INIT_JISSQL
CREATES:
indexes
classes
java resources
lob
packages
sequences
synonyms
tables
trigger
view
JISJASQL
CREATES:
classes
java sources
procedure
tables
JISAEPHCSQL
CREATES:
No new objects
INITPLGSSQL
CREATES:
class
synonym
INITJSPSQL
CREATES:
classes
java resources
synonyms
JSPJASQL
CREATES:
classes
INITPLSJSQL
CREATES:
classes
INITJMSSQL CREATES:
classes synonyms
INITREPAPISQL
CREATES:
classes
synonyms
INITSOXXSQL
CREATES:
classes
synonyms
JISAEPSQL
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(*)
SQL>select count(*) from dba_objects
where object_type like JAVA% and status = INVALID and owner = SYS;
COUNT(*)
