How to list installed Oracle components?

Useful to determine the database version and if you have APEX  (Application Express) and/or Java Virtual Machine (JVM) installed.
If you have DBA privileges:
SELECT * 
FROM DBA_REGISTRY;

Or as user:

SELECT *
FROM all_registry_banners;

BANNER
--------------------------------------------------------------------------------
Oracle Database Catalog Views Release 11.2.0.3.0 - 64bit Production
Oracle Database Packages and Types Release 11.2.0.3.0 - Development
Oracle Workspace Manager Release 11.2.0.3.0 - Development
JServer JAVA Virtual Machine Release 11.2.0.3.0 - Development
Oracle XDK Release 11.2.0.3.0 - Development
Oracle Database Java Packages Release 11.2.0.3.0 - Development
Oracle Expression Filter Release 11.2.0.3.0 - Development
Oracle Text Release 11.2.0.3.0 - Development
Oracle XML Database Version 11.2.0.3.0 - Development
Oracle Rules Manager Release 11.2.0.3.0 - Development
Oracle Multimedia Release 11.2.0.3.0 - Development
Oracle Enterprise Manager Release 11.2.0.3.0 - Development
Oracle Application Express Release 4.2.6.00.03 - Development

Leave a Reply

Your email address will not be published. Required fields are marked *