Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2616390
  • 博文数量: 323
  • 博客积分: 10211
  • 博客等级: 上将
  • 技术积分: 4934
  • 用 户 组: 普通用户
  • 注册时间: 2006-08-27 14:56
文章分类

全部博文(323)

文章存档

2012年(5)

2011年(3)

2010年(6)

2009年(140)

2008年(169)

分类: Oracle

2010-01-28 16:55:41

  首先,这是一个很简单的问题。在google一搜一大把。但搜的结果没有详细的说明,初学者还是糊涂。比如经常看到这样的回答:
$ sqlplus '/ AS SYSDBA'
SQL*Plus: Release 9.0.1.0.0 - Production on Mon Jul 14 17:01:09 2003
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
PL/SQL Release 9.0.1.0.0 - Production
CORE 9.0.1.0.0 Production
TNS for Solaris: Version 9.0.1.0.0 - Production
NLSRTL Version 9.0.1.0.0 - Production
SQL>
 
--这到底是32位的还是64位的?以下是一些说明,同时还提供了其它查看的方法。
 
1.通过SQLPLUS登录即可看出
  a.64位登录时就有显示
  $ sqlplus "/ as sysdba"
  SQL*Plus: Release 9.2.0.4.0 - Production 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 Production
  With the Partitioning option
  JServer Release 9.2.0.4.0 - Production
  b.32位的无显示
  [oracle@jumper oracle]$ sqlplus "/ as sysdba"
  SQL*Plus: Release 9.2.0.4.0 - Production 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 - Production
  With the Partitioning option
  JServer Release 9.2.0.4.0 - Production
  c.从v$version获取
  SQL select * from v$version;
  BANNER
  ------------------------------------------------------------
  Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
  PL/SQL Release 9.2.0.6.0 - Production
  CORE
  9.2.0.6.0
  Production
  TNS for 32-bit Windows: Version 9.2.0.6.0 - Production
  NLSRTL Version 9.2.0.6.0 - Production
  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/product/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/product/9.2.0/bin/oracle:
  ELF 64-bit MSB executable SPARCV9 Version 1 ..
阅读(3305) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~