« 2005年的第一场雪 | Blog首页 | Install MT plugins-Scode 1 »
Oracle HowTo:如何判断Oracle数据库安装的操作系统
作者：eygle |【转载时请以超链接形式标明文章出处和作者信息及本声明】链接：http://www.eygle.com/archives/2005/12/oracle_howto_know_oracle_install_os.html
有朋友问到这样一个问题:如何远程判断Oracle数据库的安装平台.
我想到的一个方法是,通过查询v$version视图来得到:
1.Windows平台的输出
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.Linux平台输出
SQL> select * from v$version;BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production
3.Solaris平台的输出
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 Solaris: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production
4.AIX平台的输出(感谢brucewoo提供的AIX上输出)
SQL> select * from v$version;BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
PL/SQL Release 9.2.0.5.0 - Production
CORE 9.2.0.6.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production
NLSRTL Version 9.2.0.5.0 - Production
5.HPUX上的输出(感谢tom.shew的提供)
SQL> select * from v$version;BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 ProductionTNS for HPUX: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production
历史上的今天...
>> 2006-12-04文章:
>> 2004-12-04文章:
------
这篇 【Oracle HowTo:如何判断Oracle数据库安装的操作系统】来自 eygle.com | CSDN网摘| del.icio.us|Google订阅 | 鲜果订阅 | 抓虾订阅
By eygle on 2005-12-04 02:00 | Comments (6) | Posted to HowTo | Edit |
| 相关文章 | 随机文章 |
|
Oracle10g安装中的NetWork和crt1.o错误 我的阅读-唐师曾《我的诺曼底》 域名真的很重要么? 电话以及宽带，新家的选择 使用分析函数进行行列转换 |
留言 (6)
04. 给个AIX的例子
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
PL/SQL Release 9.2.0.5.0 - Production
CORE 9.2.0.6.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production
NLSRTL Version 9.2.0.5.0 - Production
Posted by: brucewoo at December 5, 2005 3:22 PM
谢谢哈:)
Posted by: eygle at December 5, 2005 5:16 PM
哪天我装个Dos按上Oracle。
select * from v$version;
看啥效果。
Posted by: John at December 6, 2005 9:13 AM
肯定是:表或视图不存在:D
Posted by: eygle at December 6, 2005 3:53 PM
HPUX的
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for HPUX: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production
Posted by: tom.shew at December 16, 2005 1:30 PM
感谢提供，谢谢!
Posted by: eygle at December 16, 2005 8:06 PM