View to see installed products

hi,
Is there any view to see all the installed products,
apart from v$option(this doesnot list all the products)

see v$option or in O. S orainst directory

If you are on unix, do this on shell prompt

Code:

---

$ inspdver

---

It will list you all the installed product.

Sanjay

PRODUCT_COMPONENT_VERSION

hi to sonia from sonia
well it is not showing me all the installed products

How in the world would database know which Oracle products you have installed?????

For example, how would it know if you have SQL*Plus installed or not? Or ODBC driver? Or Forms? Or ......

When you run universal installer, have you ever noticed that it asks for any database password if you want to install new product? I guess not. So how would the system be able to record installed products into the database (into which database???) if it doesn't connect to the database?

Use the Oracle Universal Installer to see the list of all installed Oracle components, including their versions. You can also create TXT report from the GUI for later reference and archive.

On Windows you can also look into C:\Program Files\Oracle\Inventory\Components - where all installed components are being recorded.

Hope that helps,

clio_usa
OCP DBA 8/8i/9i
visit our Web Site

Glad to hear from u Sonia

"How in the world would database know which Oracle products you have installed????? "

-----Fine, I agree that while installing Oracle, no password/database is asked for. But then if no information is registered for the database, how do we get some info(if not all) in PRODUCT_COMPONENT_VERSION. Where do u think this info come from?

This are clearly compoinents that are part of the database and are registered during database creation. So not during software instalation (as other Sonia asked for), but during database creation/configuration.

Some of the core options are listed in v$version.