How to check the list of installed Oracle components

book

Article ID: 159908

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

You want to know what Oracle components are installed on a system.

Resolution

Log into SQLPlus as sys as sysdba and run the following:

set lines 132
column comp_name format a40
column status format a15
column version format a20

select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from dba_registry;