Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    26

    Question Unanswered: How to find Oracle Edition(i.e Enterprise/Standard)

    Hi,
    I want to find oracle version, edition etc, b/c when ever I give Parallel backup command or specifying multiple archive destinations (through log_archive_dest_n) it gives error.
    Thanks in advance.

  2. #2
    Join Date
    Mar 2004
    Posts
    370
    Hope this help:
    Code:
     select banner from v$version;
    -Best wishes

  3. #3
    Join Date
    Aug 2004
    Posts
    26

    but it didn't say any thing about Enterprise/Standard

    Hi,
    I already quey this but it didn't say any thing about Enterprise/standard version o/p is

    SQL> select banner from v$version;

    BANNER
    ----------------------------------------------------------------
    Oracle9i Release 9.2.0.1.0 - Production
    PL/SQL Release 9.2.0.1.0 - Production
    CORE 9.2.0.1.0 Production
    TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
    NLSRTL Version 9.2.0.1.0 - Production

    SQL> SELECT * FROM v$version;

    BANNER
    ----------------------------------------------------------------
    Oracle9i Release 9.2.0.1.0 - Production
    PL/SQL Release 9.2.0.1.0 - Production
    CORE 9.2.0.1.0 Production
    TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
    NLSRTL Version 9.2.0.1.0 - Production

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    You have standard edition. If you have enterprise, it says so. (see below)

    Code:
    SQL> SELECT * FROM V$VERSION;
    
    BANNER
    ----------------------------------------------------------------
    Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
    PL/SQL Release 8.1.7.4.0 - Production
    CORE    8.1.7.0.0       Production
    TNS for Solaris: Version 8.1.7.4.0 - Production
    NLSRTL Version 3.4.1.0.0 - Production
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    Another easy solution is to fire up SQLPLus and connect to your data base. You get the same info. (Of course like the select it will not specifically say what you do not have, it will only say what you do have).
    NOTE: Please disregard the label "Senior Member".

Posting Permissions

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