DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: 32 or 64 bit Oracle

  1. #1
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    32 or 64 bit Oracle

    Hi All

    How can I find the Oracle is 32 bit or 64 bit..?

    Thanks in advance



    Thomas
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    From Metalink... I didn't know the first one.

    Problem Description:
    ====================

    Q: How do you tell if Oracle is 32 or 64 bit?


    Problem Explanation:
    ====================

    On a UNIX system, there are three ways to tell if media is 32 or 64 bit.

    1. Type: cd $ORACLE_HOME/bin
    file oracle

    2. Start up Server Manager and look at the banner. Some platforms show the
    bit size in the Server Manager banner.

    3. Look at the actual media; sometimes it will state on the media if it is
    32 or 64 bit.
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by grjohnson
    From Metalink... I didn't know the first one.

    Problem Description:
    ====================

    Q: How do you tell if Oracle is 32 or 64 bit?


    Problem Explanation:
    ====================

    On a UNIX system, there are three ways to tell if media is 32 or 64 bit.

    1. Type: cd $ORACLE_HOME/bin
    file oracle

    2. Start up Server Manager and look at the banner. Some platforms show the
    bit size in the Server Manager banner.

    3. Look at the actual media; sometimes it will state on the media if it is
    32 or 64 bit.
    Also when you type RMAN, the 64 bit version will inform you about it:

    Recovery Manager: Release 9.2.0.1.0 - 64bit Production
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Thanks

    Hi Mates

    Its a great help.... Thanks a lot...



    Thomas
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  5. #5
    Join Date
    Dec 2002
    Posts
    3
    Originally posted by julian
    Also when you type RMAN, the 64 bit version will inform you about it:

    Recovery Manager: Release 9.2.0.1.0 - 64bit Production

    ?I don't think it's a good method.



    $file oracle
    is better .........

  6. #6
    Join Date
    May 2002
    Posts
    2,645
    Originally posted by Fenng
    ?I don't think it's a good method.



    $file oracle
    is better .........
    Why? You think sometimes it says 64-bit and sometimes it doesn't?

    Also, starting SQL*Plus will show the bit version.

  7. #7
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Originally posted by stecal
    Why? You think sometimes it says 64-bit and sometimes it doesn't?

    Also, starting SQL*Plus will show the bit version.
    Actaully, I found SQL*Plus no longer does it in 9i (well my version anyway).



    cantest:[TEST9]:/export/home/oracle
    -> sqlplus

    SQL*Plus: Release 9.2.0.1.0 - Production on Fri Dec 13 09:42:36 2002

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    cantest:[TEST9]:/export/home/oracle
    -> rman

    Recovery Manager: Release 9.2.0.1.0 - 64bit Production

    Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

    RMAN>
    OCP 8i, 9i DBA
    Brisbane Australia

  8. #8
    Join Date
    May 2002
    Posts
    2,645
    Code:
    SQL*Plus: Release 8.1.6.0.0 - Production on Thu Dec 12 17:02:18 2002
    
    (c) Copyright 1999 Oracle Corporation.  All rights reserved.
    
    
    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    
    
    NAME      USER                           DATE      TIME
    --------- ------------------------------ --------- --------
    DEVEL40   SYSTEM                         12-DEC-02 05:02 PM
    
    SQL>

  9. #9
    Join Date
    Apr 2001
    Posts
    257
    Strangely, my 32-bit Oracle 8i does not show in SQL*PLUS...

    SQL*Plus: Release 8.1.7.0.0 - Production on Thu Dec 12 16:54:18 2002

    (c) Copyright 2000 Oracle Corporation. All rights reserved.


    Connected to:
    Oracle8i Release 8.1.7.3.0 - Production
    JServer Release 8.1.7.3.0 - Production

  10. #10
    Join Date
    May 2002
    Posts
    2,645
    Shows 64-bit if 64-bit; otherwise, does not show any-bit

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