Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    39

    Unanswered: How to Find out oracle version 64 or 32 bit

    There is a oracle 9.2.0.1 installation on a solaris 64bit server.
    The orginal cd is currently not available. No patches applied sofar.
    No database instance created so far.

    I want to find out the version of oracle database including whether 64 or 32 oracle.

    Note: On one of my 64bit oracle server. I ran runInstaller. it is giving wrong info for the oracle version. It diaplys oracle 9.2.0.1 -32 bit inspite of a 64 bit installation. This may be a bug.

    So, is there any other way to find out the version information

    Thanks
    Ydj

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    file oracle

  3. #3
    Join Date
    Jan 2004
    Location
    India
    Posts
    191
    Try with this

    SQL> select * from v$version;

    BANNER
    ----------------------------------------------------------------
    Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
    PL/SQL Release 9.2.0.4.0 - Production
    CORE 9.2.0.3.0 Production
    TNS for HPUX: Version 9.2.0.4.0 - Production
    NLSRTL Version 9.2.0.4.0 - Production
    Pagnint
    (No need to search web before posting new question)

Posting Permissions

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