How to check components installed status in Oracle DB

Scenario:

You need to check whether one component have installed/loaded or not Oracle Database.

Or you want to display information about the components in your Oracle Database.

Solution:

You can query the DBA_REGISTRY table.

For instance, in the readme.txt of some database patches, it might require you to check the component status.

(4)Postinstallation

———————-

After you install the patch, reload the packages into the Oracle Database.

change directory to $ORACLE_HOME/rdbms/admin and then

connect as SYSDBA and run the following in given order :

Note: If XDB is installed then it is required to run “catmetx.sql” script also.

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

You can run below query as / sysdba,

SQL> select substr(comp_name,1,30) comp_name, substr(comp_id,1,10) comp_id,substr(version,1,12) version,status from dba_registry where comp_id like ‘XDB’;

COMP_NAME COMP_ID VERSION STATUS

———————————————————————————————————————— —————————————- ———————————————— ——————————————–

Oracle XML Database XDB 11.2.0.3.0 VALID

SQL>