1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

oracle database version capable of replication or not?

Discussion in 'Installation - Windows' started by imsean, Jan 6, 2009.

  1. imsean

    imsean Active Member

    Messages:
    15
    Likes Received:
    2
    Trophy Points:
    90
    Hi All

    Is there a way for me to know my database version exactly, i.e whether it is an enterprise edition or not. Actually i want replication over it, is this version is capable for replication or not? If not then do i need to upgrade this? Please reply me in detail.

    Code (Text):
    SQL> select * from v$version;

    BANNER
    Oracle Database 10g Release 10.1.0.5.0 - 64bit Production
    PL/SQL Release 10.1.0.5.0 - Production
    CORE 10.1.0.5.0 Production
    TNS for HPUX: Version 10.1.0.5.0 - Production
    NLSRTL Version 10.1.0.5.0 - Production
    Thanks :)
     
  2. tyro

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    20
    Trophy Points:
    260
    Location:
    India
    When i run v$version, I get the following

    Code (Text):
    SQL> select * from v$version;

    BANNER
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
    PL/SQL Release 10.2.0.1.0 - Production
    CORE 10.2.0.1.0 Production
    TNS for Solaris: Version 10.2.0.1.0 - Production
    NLSRTL Version 10.2.0.1.0 - Production

    SQL>
     
    So obviously, i have EE edition, and u have standard edition
     
  3. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    I think your's is standard edition. Otherwise it will show the edition explicitly like this

    Code (Text):

    SQL>  select * from v$version;
    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
    PL/SQL Release 10.2.0.4.0 - Production
    CORE    10.2.0.4.0      Production
    TNS for Linux: Version 10.2.0.4.0 - Production
    NLSRTL Version 10.2.0.4.0 - Production

    SQL>
     
    Version information can also be checked from Installed Products from the Oracle Universal Installer. It will also tell you its version information.

    In Unix, the installer is located at $ORACLE_HOME/bin/runInstaller.
    In Windows, access the installer by Start -> All Programs -> Oracle Installed Products -> Universal Installer.