View to see installed products
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: View to see installed products

  1. #1
    Join Date
    Feb 2002
    Posts
    267
    hi,
    Is there any view to see all the installed products,
    apart from v$option(this doesnot list all the products)

  2. #2
    Join Date
    Jul 2002
    Posts
    3

    Post

    see v$option or in O. S orainst directory

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    If you are on unix, do this on shell prompt

    Code:
    $ inspdver
    It will list you all the installed product.

    Sanjay

  4. #4
    Join Date
    Jul 2002
    Posts
    132
    PRODUCT_COMPONENT_VERSION

  5. #5
    Join Date
    Feb 2002
    Posts
    267
    hi to sonia from sonia
    well it is not showing me all the installed products

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  7. #7
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Cool

    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


  8. #8
    Join Date
    Jul 2002
    Posts
    132
    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?








  9. #9
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  10. #10
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Some of the core options are listed in v$version.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width