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. 10-29-2002, 07:01 AM #1
    JMac
    JMac is offline Red Boy of Differdange
    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?
    Reply With Quote Reply With Quote
  2. 10-29-2002, 07:19 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    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!
    Reply With Quote Reply With Quote
  3. 10-29-2002, 07:23 AM #3
    JMac
    JMac is offline Red Boy of Differdange
    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)?
    Reply With Quote Reply With Quote
  4. 10-29-2002, 07:26 AM #4
    pando
    pando is offline Pando & Company
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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