数据库|mysql教程
How,Add,the,JVM,Component,Exis
数据库-mysql教程
phpmps源码下载,ubuntu长时间挂起,爬虫专业有哪些,滴滴外卖php,大熊南岸seolzw
Applies to: Oracle Server – Enterprise Edition – Version 11.2.0.1.0 and later Information in this document applies to any platform. This article details how to install the JVM in an existing Oracle11g Release 2 database. Goal Add the Oracl
php 理财网站源码,vscode修改扩展程序位置,ubuntu 卸载中文,tomcat怎么部署的,爬虫用户关系,php goto 效率,揭阳seo关键词优化服务lzw
小型数据库源码,vscode能改编码,谷歌浏览器ubuntu,tomcat 性能配置,sqlite sqlce,唯品会网页设计,纯真ip数据库 转utf8,云服务器与传统服务器,快递助手插件升级,蚂蚁金服前端框架与工程化,爬虫 坐牢,php 异步请求,慈溪seo,springboot支持配置,dede 版权标签,个人工作室网站,html静态网页模板吧,discuz论坛模板文件,短信群发后台管理系统,手机分类页面模板,档案管理系统代码大全,stvd 程序大小lzw
Applies to:
Oracle Server – Enterprise Edition – Version 11.2.0.1.0 and later
Information in this document applies to any platform.
This article details how to install the JVM in an existing Oracle11g Release 2 database.
Goal
Add the Oracle JVM component to an existing Oracle Database or instance.
As with all destructive actions, Oracle Corporation strongly advises taking a
FULL COLD BACKUP of the database
before these actions are performed.
Fix
There are two options:
Option 1. Add the Oracle JVM component using the Database Configuration Assistant Utility
a. Start the Database Configuration Assistant and Click Next at the Welcome screen.
b. Choose the option to configure a database. Click Next
c. Select the database service name to configure. Click Next
c. Click the Button labeled “Standard Database Components” and check or enable the box “Oracle JVM”. Click Ok.
d. Click Next and then Finish to complete the action.
Option 2. Manually Add the JVM Component by executing the initjvm.sql script.
The following steps need to be executed precisely as listed below to ensure that they complete successfully:
a. Verify the following system requirements are available:
The Shared Pool has at least 96Mb of free space.
The Java Pool has at least 50Mb of free space
The SYSTEM tablespace has at least 70Mb of free space
The SYSTEM RBS has at least 100Mb of free space
The initjvm.sql script in 11g will check these resources are available when it is run, and if they aren’t available the execution of the script will terminate with an error indicating which resource needs to be increased.
b. Shutdown the instance and then create and run the following sql script from a new sqlplus session:
spool full_jvminst.log; set echo on connect / as sysdba startup mount alter system set "_system_trig_enabled" = false scope=memory; alter database open; select obj#, name from obj$ where type#=28 or type#=29 or type#=30 or namespace=32; @?/javavm/install/initjvm.sql select count(*), object_type from all_objects where object_type like \%JAVA% group by object_type; @?/xdk/admin/initxml.sql select count(*), object_type from all_objects where object_type like \%JAVA% group by object_type; @?/xdk/admin/xmlja.sql select count(*), object_type from all_objects where object_type like \%JAVA% group by object_type; @?/rdbms/admin/catjava.sql select count(*), object_type from all_objects where object_type like \%JAVA% group by object_type; @?/rdbms/admin/catexf.sql select count(*), object_type from all_objects where object_type like \%JAVA% group by object_type; shutdown immediate set echo off spool off exit -- End of File full_jvminst.sql-- Start of File full_jvminst.sql
c. Once the database has been restarted, resolve any invalid objects.
This can be performed by running the utlrp.sql script e.g.:
@?/rdbms/admin/utlrp.sql
