Re: To find versions of installed oracle products

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Thu, 6 Jan 2005 22:41:22 +0100
Message-ID: <41ddb088$0$2972$ba620e4c@news.skynet.be>

"Sri via OracleMonster.com" <forum_at_OracleMonster.com> wrote in message news:a28a3193a94a4267bac54987629d8182_at_OracleMonster.com...
>
> I am new to oracle adminstration
>
> I want to find the versions of the following products
>
> Oracle Net Services (64 bit - Enterprise Edition)
> Oracle Server (64 bit - Enterprise Edition)
> Oracle Advanced Security (64 bit - Enterprise Edition)Oracle Transparent
> Gateway for DRDA (64 bit - Enterprise Edition) Oracle Enterprise Manager
> (Enterprise Edition)
>
>
> But the unix.rgs contains only this line "rdbms 9.2.0.0.0 "
>
> can somebody tell me how to find out the current versions..
> In some Dictionaryviews or need to invoke any executable(pls mention the
> executable also)
>
> --
> Message posted via http://www.oraclemonster.com

Try : SELECT * FROM PRODUCT_COMPONENT_VERSION;

HTH,
Matthias Received on Thu Jan 06 2005 - 15:41:22 CST