Query to find the Installed Components of an Oracle Database
Connect to database as SYSDBA
Query:
set line 200;
set pagesize 9999;
col COMP_ID format a15;
col COMP_NAME format a50;
select COMP_ID,COMP_NAME,STATUS from dba_registry;
Output as Below:
COMP_ID COMP_NAME STATUS
--------------- -------------------------------------------------- --------------------
AMD OLAP Catalog VALID
CONTEXT Oracle Text VALID
SDO Spatial VALID
ORDIM Oracle Multimedia VALID
XDB Oracle XML Database VALID
EXF Oracle Expression Filter VALID
CATALOG Oracle Database Catalog Views VALID
CATPROC Oracle Database Packages and Types VALID
RAC Oracle Real Application Clusters INVALID
JAVAVM JServer JAVA Virtual Machine VALID
XML Oracle XDK VALID
CATJAVA Oracle Database Java Packages VALID
APS OLAP Analytic Workspace VALID
XOQ Oracle OLAP API VALID
Post a Comment
Post a Comment