-
32 or 64 bit Oracle
Hi All
How can I find the Oracle is 32 bit or 64 bit..?
Thanks in advance
Thomas
-
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
-
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
-
Thanks
Hi Mates
Its a great help.... Thanks a lot...
Thomas
-
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 .........
-
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.
-
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
-
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>
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|