v$version - will it show if edition is Standard or Enterprise?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: v$version - will it show if edition is Standard or Enterprise?

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818

    v$version - will it show if edition is Standard or Enterprise?

    and how do we go about getting (or upgrading to) Enterprise edition if we only have standard?

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    The first row in v$version will show whether it's standard or enterprise edition.

    As for upgrading you simply need to do the following:

    1. Take a backup and stop database
    2. De-install the standard edition software or install enterprise edition in a new home
    3. Modify you "oratab" file to point to the new home
    4. Start your database and run "catalog.sql" and "catproc.sql"

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818

    oratab?

    I'm running 8.1.5 on NT4 . Heres my v$version info ...

    Oracle8i Release 8.1.5.0.0 - Production
    PL/SQL Release 8.1.5.0.0 - Production
    CORE Version 8.1.5.0.0 - Production
    TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
    NLSRTL Version 3.4.0.0.0 - Production

    oratab? Is that Unix?

    I suppose we have to buy Enterprise edition (or at least upgrade our licensing and support)?

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    oratab is UNIX yes, if itīs windows then you might as well delete the stuffs in registry after uninstallation process

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