How to find version of oracle applications and database

For applications:(There are many ways to do it...This is one of ...)

SELECT product_group_id GroupID, product_group_name GroupName,
release_name Release, product_group_type GroupType, argument1
FROM fnd_product_groups;


For database. (There are many ways to do it...This is one of ...)

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production


SQL> select COMP_NAME,VERSION,STATUS from dba_registry;

COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ -----------
Oracle9i Catalog Views 9.2.0.6.0 VALID
Oracle9i Packages and Types 9.2.0.6.0 VALID
JServer JAVA Virtual Machine 9.2.0.6.0 VALID
Oracle9i Java Packages 9.2.0.6.0 VALID
Oracle XDK for Java 9.2.0.8.0 VALID
Oracle Text 9.2.0.6.0 VALID
Oracle9i Real Application Clusters 9.2.0.6.0 INVALID
Oracle interMedia 9.2.0.6.0 VALID
Spatial 9.2.0.6.0 VALID

9 rows selected.

No comments:

Post a Comment