jvm下载oracle,Oracle 11g 安装JVM

测试环境，创建user的时候，遇到错误如下：

SQL> grant javasyspriv to XXXX

*

ERROR at line 1:

ORA-01919: role ‘JAVASYSPRIV’ does not exist

SQL>

原来是因为安装的时候，用silent模式，执行sql的时候，少了一些。

当前信息：

SQL> SELECT comp_name || ‘ : ‘||version|| ‘ : ‘|| status FROM dba_registry;

COMP_NAME||’:’||VERSION||’:’||STATUS

——————————————————————————–

Oracle Database Catalog Views : 11.2.0.3.0 : VALID

Oracle Database Packages and Types : 11.2.0.3.0 : VALID

SQL>

按照文档执行安装(就是两个sql)。

cd $ORACLE_HOME

SQL> @?/javavm/install/initjvm.sql

SQL> @?/rdbms/admin/catjava.sql

然后验证一下：

SQL> SELECT comp_name || ‘ : ‘||version|| ‘ : ‘|| status FROM dba_registry;

COMP_NAME||’:’||VERSION||’:’||STATUS

——————————————————————————–

Oracle Database Catalog Views : 11.2.0.3.0 : VALID

Oracle Database Packages and Types : 11.2.0.3.0 : VALID

JServer JAVA Virtual Machine : 11.2.0.3.0 : VALID

Oracle Database Java Packages : 11.2.0.3.0 : VALID

SQL> grant javasyspriv to XXXXX;

Grant succeeded.

SQL>

参考了URL如下：

How To Install Oracle JVM

BACKGROUND & OVERVIEW

OracleJava Virtual Machine (JVM)is a feature of the Oracle Database. It provides the ability to run java code from within the database.

This document explains the full set of steps that need to be taken in order to perform a complete and working installation.

ASSUMPTIONS & PRE-REQUISITES

This document expects and assumes the following:

The instructions are carried out by a qualified DBA, fully conversant with Oracle.

A fully working databasewithoutJVM exists.

All references toSIDshould be replaced with correct database name as derived using the database naming standard.

STEP-BY-STEP GUIDE

AsSYS, confirm theJVMis not already installed.

SELECT comp_id, comp_name FROM dba_registry;should not listJAVAMorCATJAVA.

AsSYS, perform theJVMinstallation.

@?/javavm/install/initjvm.sql

@?/rdbms/admin/catjava.sql

AsSYS, confirm theJVMis now fully installed:

SELECT comp_id, comp_name FROM dba_registry;

COMP_ID COMP_NAME

--------- --------------------------------------------

EM Oracle Enterprise Manager

CATALOG Oracle Database Catalog Views

CATPROC Oracle Database Packages and Types

JAVAVM JServer JAVA Virtual Machine

CATJAVA Oracle Database Java Packages

HEALTHCHECK

In addition, the following healthcheck can be performed to confirm the stability of the installed JVM, further details can be found in Metalink Article456949.1:

connect/assysdbaspooljvm_stats.logsetserveroutputonsetechoonsetpagesize500setlinesize100columncomp_nameformata40selectcomp_name,version,statusfromdba_registry;selectowner,status,count(*)fromall_objectswhereobject_typelike'%JAVA%'groupbyowner,status;selectowner,object_type,count(*)fromall_objectswhereobject_typelike'%JAVA%'andstatus<>'VALID'groupbyowner,object_type;selectowner,status,object_type,object_namefromall_objectswhereobject_namelike'%DBMS_JAVA%';selectowner,status,object_type,object_namefromall_objectswhereobject_namelike'%INITJVMAUX%';selectrolefromdba_roleswhererolelike'%JAVA%';select*fromv$sgastatwherePOOL='java pool'orNAME='free memory';showparameterpool_sizeshowparametersgaselectowner,object_type,status,dbms_java.longname(object_name)fromall_objectswhereobject_typelike'%JAVA%'andstatus<>'VALID';spooloff