Thursday, February 16, 2023

How to check the valid components loaded into the database (JVM,XML,XDK,Oracle Label Security......) ?

How to check the valid components loaded into the database ?


Login as privilege user and run below commands : 


SQL> select * from all_registry_banners;


BANNER                                                                           BANNER_FULL

-------------------------------------------------------------------------------- --------------------------------------------------------------------------------------

Oracle Database Catalog Views Release 19.0.0.0.0 - Production                    Oracle Database Catalog Views Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle Database Packages and Types Release 19.0.0.0.0 - Production               Oracle Database Packages and Types Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle XML Database Release 19.0.0.0.0 - Production                              Oracle XML Database Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle Workspace Manager Release 19.0.0.0.0 - Production                         Oracle Workspace Manager Release 19.0.0.0.0 - Production Version 19.3.0.0.0

JServer JAVA Virtual Machine Release 19.0.0.0.0 - Production                     JServer JAVA Virtual Machine Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle XDK Release 19.0.0.0.0 - Production                                       Oracle XDK Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle Database Java Packages Release 19.0.0.0.0 - Production                    Oracle Database Java Packages Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle Text Release 19.0.0.0.0 - Production                                      Oracle Text Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle Multimedia Release 19.0.0.0.0 - Production                                Oracle Multimedia Release 19.0.0.0.0 - Production Version 19.3.0.0.0

OLAP Analytic Workspace Release 19.0.0.0.0 - Production                          OLAP Analytic Workspace Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle OLAP API Release 19.0.0.0.0 - Production                                  Oracle OLAP API Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Spatial Release 19.0.0.0.0 - Production                                          Spatial Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle Label Security Release 19.0.0.0.0 - Production                            Oracle Label Security Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle Database Vault Release 19.0.0.0.0 - Production                            Oracle Database Vault Release 19.0.0.0.0 - Production Version 19.3.0.0.0



14 rows selected.


SQL>

No comments:

Post a Comment