products under 8.1.7

[shirly]

Hi all,

In order to upgrade my databases to 8.1.7.4 patch individually I'm reinstalling oracle 8.1.7 in a separate oracle home. How can I tell which products are installed under the current 8.1.7.0?

Thanks

[patel_dil]

Try this following SQL:

SELECT * FROM product_component_version;

You might also want to check /Program files/Oracle/Inventory/Components Directory.

[stecal]

Start OUI, look at Installed Products