如何鉴别oracle 64位 32位
发布网友
发布时间：2022-07-23 05:20
共1个回答
热心网友
时间：2023-11-24 01:18
1.通过SQLPLUS登录即可看出
a.64位登录时就有显示
$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Proction on Wed Nov 16 15:27:28 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Proction
With the Partitioning option
JServer Release 9.2.0.4.0 - Proction
b.32位的无显示
[oracle@jumper oracle]$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Proction on Wed Nov 16 15:19:03 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Proction
With the Partitioning option
JServer Release 9.2.0.4.0 - Proction
c.从v$version获取
SQL> select * from v$version;
BANNER
------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Proction
PL/SQL Release 9.2.0.6.0 - Proction
CORE 9.2.0.6.0 Proction
TNS for 32-bit Windows: Version 9.2.0.6.0 - Proction
NLSRTL Version 9.2.0.6.0 - Proction
2.从v$sql视图获取
a.如果输出为8位16进制数，则为32位Oracle
SQL> select address from v$sql where rownum<2;
ADDRESS
--------
578428D8
b.如果输出为16位16进制数，则为64位Oracle
SQL> select address from v$sql where rownum<2;
ADDRESS
----------------
000000040DFA01E0
3.使用系统命令file
a.如果输出带有32-bit字样为32位Oracle
[oracle@jumper oracle]$ file $ORACLE_HOME/bin/oracle
/opt/oracle/proct/9.2.0/bin/oracle: setuid setgid ELF 32-bit LSB executable, Intel 80386..
b.如果输出带有64-bit字样为64位Oracle
$ file $ORACLE_HOME/bin/oracle
/opt/oracle/proct/9.2.0/bin/oracle: ELF 64-bit MSB executable SPARCV9 Version 1 ..
