-
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
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?
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Some of the core options are listed in v$version.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|