Oracle Inventory

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kalle - 30 Jun 2005 04:09 GMT

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

Reply to this Message

DA Morgan - 30 Jun 2005 05:58 GMT

> Hi there,
>
[quoted text clipped - 11 lines]
>
> 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;

Signature

Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

Reply to this Message

Kalle - 30 Jun 2005 06:50 GMT

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

>> Hi there,
>>
[quoted text clipped - 25 lines]
> FROM dba_high_water_mark_statistics
> ORDER BY 1;

Reply to this Message

Sybrand Bakker - 30 Jun 2005 08:02 GMT

>Hi Daniel,
>
[quoted text clipped - 7 lines]
>rgds
>kalle

Oracle is downwards compatible, so it doesn't matter the client is
running Oracle 8i while your database is 9i.
Other than for illegal purposes, I can not see any need to gather this
information, especially not without connecting (which seems to
indicate the administrators of the affected systems are unaware of
your 'work')

Please adhere do Netiquette and do
- not top post
- not include the entire message in your response.
Humans happen to read from to top bottom (except those pitiful ones
crippled by Bill Gates and his associates), and you are wasting
bandwith.

--
Sybrand Bakker, Senior Oracle DBA

Reply to this Message

DA Morgan - 30 Jun 2005 15:14 GMT

> Hi Daniel,
>
[quoted text clipped - 7 lines]
> rgds
> kalle

Then it can not be done. You need to redefine what it is you NEED to
know to a subset of what is installed. Many parts of the database can
only be detected by logging in.

Signature

Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

Reply to this Message

HansF - 30 Jun 2005 15:31 GMT

> And of course version can vary :)

You should be able to specify a range of valid versions, or a minimum
version number. Like any good design, you need to have an idea of the
boundary conitions, otherwise we might get the impression you are simply
trying to crack systems ...

The reasons for needing this ... the information you need is in the Oracle
Inventory, but Oracle changed their inventory mechanism around 9iR2.
However, the inventory is pretty large - if you want to see the kind of
contents, fire up the universal installer.

Signature

Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***

Reply to this Message

Randy Harris - 30 Jun 2005 13:24 GMT

> Hi there,
>
[quoted text clipped - 11 lines]
>
> kalle

AFAIK, you need access to either the database or to the system (telnet, rsh,
etc). I don't believe there is a way, nor should there be, if you have no
access permissions.

Reply to this Message