Version of Oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Version of Oracle

  1. #1
    Join Date
    Sep 2001
    Posts
    163
    I was just asked to see what version/type of Oracle was installed on an Win NT 4.0 box. I know I can connect to the database and type Select * from v$version. But this only gives me the version number(Oracle 8i Release 8.1.6.0.0). What I would like to know is if the machine was installed with Oracle Workgroup, Oracle Personal Edition, Enterprise Edition, Oracle Client, etc. in addition to just the version number.

    Thanks.

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    This appears when I log into SQL*Plus as system/manager:

    Verbunden mit:
    Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.6.0.0 - Production

    Hope that is what you are looking for.
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    In any time you can execute statment:
    select * from v$version;
    and see something like this:

    BANNER
    --------------------------------------------------
    Oracle8i Release 8.1.5.0.2 - Production
    PL/SQL Release 8.1.5.0.0 - Production
    CORE Version 8.1.3.0.0 - Production
    TNS for Linux: Version 8.1.5.0.0 - Production
    NLSRTL Version 3.4.0.0.0 - Production

  4. #4
    Join Date
    Sep 2001
    Posts
    163
    dknight,

    That is what I am looking for, but when I do the same thing I get:

    Connected to:
    Oracle8i Release 8.1.6.0.0 - Production
    JServer Release 8.1.6.0.0 - Production

    Based off your reply and what I get, I think it could be safe to say the machine doesn't have Enterprise Edition installed. But which edition does it have? The mystery continues.

  5. #5
    Join Date
    Apr 2001
    Location
    UK
    Posts
    137
    There is also a table called v$option, which tells you which of the optional components you have installed.

  6. #6
    Join Date
    Oct 2001
    Location
    Buffalo, NY
    Posts
    46
    Try executing your Oracle Universal Installer. There is an option that diplays all your installed SW.
    Tim Hussar

  7. #7
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    standard
    sonofsita
    http://www.ordba.net

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