Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Inventory
Hi Daniel,
thank you for your tip but as I said
>> This information should be collected remotely without accessing or
>> logging into database.
And of course version can vary :)
rgds
kalle
"DA Morgan" <damorgan_at_psoug.org> wrote in message
news:1120107510.180414_at_yasure...
> Kalle wrote:
>> Hi there,
>>
>> I need your advice so please could you tell me
>>
>> what is the way to collect information about the oracle versions and
>> options installed or used on database server.
>>
>> This information should be collected remotely without accessing or
>> logging into database.
>>
>> Also I know there might be differencies cross the platforms...
>>
>> Thank you in advance for your help :)
>>
>> kalle
>
> And the version number is?
>
> Well you didn't say so I'm going to guess 10gR1.
>
> select comp_name, version, status from dba_registry;
>
> SELECT name, detected_usages
> FROM dba_feature_usage_statistics
> ORDER BY 1;
>
> SELECT name, version, highwater
> FROM dba_high_water_mark_statistics
> ORDER BY 1;
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)
Received on Thu Jun 30 2005 - 00:50:58 CDT