jvm和xdb组件

GDS

请问：11gR2使用dbca建库，  jvm和xdb组件取消安装的时候，可能导致哪些正常的功能无法使用？

Maclean Liu(刘相兵

From Upgrade team  Mike Dietrich








Recently I had to dig a bit into the component dependency topic as I was working with an Oracle Database 10.1.0.5 customer planning to upgrade to Oracle Database 11.2.0.2 with a limited downtime window. To achieve the given downtime window we planned to remove some unused components from the database.

As you know already the time it'll take to upgrade an Oracle database is mainly dependent on the number of installed components. If you'll query DBA_REGISTRY (or the underlying REGISTRY$) you'll spot all the installed (and usually configured) database components. And the more of these components are installed the longer the upgrade usually will take.
    Please don't get me wrong here: This is NOT a recommendation to deinstall any components. Tomorrow or the day after somebody wishes to use some component functionality - and not nice if you have deinstalled it.
   But first of all it might be a good idea to know a little bit about component dependecies - and on the other hand this might help you in one or another situations to fix INVALID components.
And please be advised: The presentation I'm refering to is not a official support note. And as it is the first release of this presentation I don't guarantee that every mentioned workaround is the best available - or will work in any environment. Please check also the referenced notes in case you'd like to "tweak" one or the other component.
   You might download the presentation either via the DOWNLOAD SLIDES section in the right column of this blog (please scroll down a bit) or via this direct link here.


From https://blogs.oracle.com/UPGRADE ... ponent_dependencies

Maclean Liu(刘相兵

各主流版本DB software 中组件component 的依赖关系

Component Dependecies in 10.1
RDBMS (Oracle Server) is the base component
Stand alone components (no dependencies):
JAVAVM, XDB, EM, OLAP, LABEL SECURITY, OWM, RAC
XML requires JAVAVM
DATA MINING requires JAVAVM and XDB
SPATIAL DATA requires DATA MINING, JAVAVM, XDB, XML
CONTEXT requires DATA MINING
APEX requires CONTEXT and XDB
EXPRESSION FILTER requires JAVAVM
INTERMEDIA/MULTIMEDIA requires JAVAVM, XDB, XML
ULTRA SEARCH requires JAVAVM
OALP API (XOQ) requires XML and XDB (and XS)



Component Dependecies in 10.2
RDBMS (Oracle Server) is the base component
Stand alone components (no dependencies):
JAVAVM, XDB, XML, EM, OLAP, LABEL SECURITY, OWM, RAC
XML requires JAVAVM
DATA MINING requires JAVAVM and XDB
SPATIAL DATA requires DATA MINING, JAVAVM, XDB, XML
CONTEXT requires DATA MINING
2011 Oracle Corporation 35
APEX requires CONTEXT and XDB
DATA VAULT requires LABEL SECURITY
EXPRESSION FILTER requires JAVAVM
RULES MANAGER requires EXPRESSION FILTER, JAVAVM
INTERMEDIA/MULTIMEDIA requires JAVAVM, XDB, XML
ULTRA SEARCH requires JAVAVM
OALP API (XOQ) requires XML and XDB (and XS)









Component Dependecies in 11.1
RDBMS (Oracle Server) is the base component
Stand alone components (no dependencies):
JAVAVM, XDB, XML, EM, OLAP, LABEL SECURITY, OWB, OWM, RAC
XML requires JAVAVM
DATA MINING requires JAVAVM and XDB
SPATIAL DATA requires DATA MINING, JAVAVM, XDB, XML
CONTEXT requires DATA MINING
2011 Oracle Corporation 58
APEX requires CONTEXT and XDB
DATA VAULT requires LABEL SECURITY
EXPRESSION FILTER requires JAVAVM
RULES MANAGER requires EXPRESSION FILTER, JAVAVM
INTERMEDIA/MULTIMEDIA requires JAVAVM, XDB, XML
ULTRA SEARCH requires JAVAVM
OALP API (XOQ) requires XML and XDB (and XS)



Component Dependecies in 11.2
RDBMS (Oracle Server) is the base component
Stand alone components (no dependencies):
JAVAVM, XDB, XML, EM, OLAP, LABEL SECURITY, OWB, OWM, RAC
XML requires JAVAVM
DATA MINING requires JAVAVM and XDB
SPATIAL DATA requires DATA MINING, JAVAVM, XDB, XML
CONTEXT requires DATA MINING
2011 Oracle Corporation 83
APEX requires CONTEXT and XDB
DATA VAULT requires LABEL SECURITY
EXPRESSION FILTER requires JAVAVM
RULES MANAGER requires EXPRESSION FILTER, JAVAVM
INTERMEDIA/MULTIMEDIA requires JAVAVM, XDB, XML
OALP API (XOQ) requires XML and XDB (and XS)
Ultrasearch will be deinstalled during upgrade to Oracle 11.2

GDS

Thanks， 这个图我也看到过， 但好像自始至终一直都是Mike Dietrich自圆其说的。。。没有其它的依据。
in Oracle 11.2 you will lose the ability to use the following components (because they are dependent on JAVAVM component in DBA_REGISTRY:
XML, Expression Filter, Multimedia, Spatial, OLAP API, Rules Manager, TEXT; APEX.

And be aware that in future version of the database some components might be installed by default as mandatory components.

Thanks, Mike
并且这些东西都是not well documented。。。

GDS

以上这个mike说缺少jvm会导致的这些功能不能用，跟他画的这个图自相矛盾。

GDS

比如rat中spa对jvm的依赖，expdp的某些功能依赖，他也没提到。
所以我怀疑他这个图不是太可信。。。

GDS

其实需求很简单，就是有客户想把这些组件都不选，但是又怕某些功能会异常或者无法正常使用。

Maclean Liu(刘相兵

这个貌似目前没有一个 best practice 的paper 介绍哪个版本上推荐装哪些组件。

装的components 太多 影响 catupgrd.sql时候的速度， 装地少了 又可能一些必要的 工具如expdp 无法完全正常使用。

这个问题还是交给甲方的同志吧

GDS

Thx Liu
虽然是个小问题，不少客户对于这个问题一直比较纠结， 问过此问题的不下四个。
Mike Dietrich最近会来BJ，到时候再当面去问他了。。。

Maclean Liu(刘相兵

这个upgrade team 我觉得还算蛮open的， 有什么东西都愿意放出来分享。