Query To Check Components Status Registered in an Oracle Database

Download(dbregistry.sql)

REM +======================================================================+
REM                    
REM File Name: dbregistry.sql
REM 
REM Description:
REM   Query To Check Components Status Registered in an Oracle Database
REM   
REM Notes:
REM   Usage: sqlplus "/ as sysdba" @dbregistry.sql 
REM   
REM +======================================================================+

clear columns
set lines 180
set pages 100
col COMP_ID for a10
col COMP_NAME for a50 WORD_WRAPPED
col VERSION for a15
col STATUS for a15
select COMP_ID,COMP_NAME,VERSION,STATUS from dba_registry;