如何判断Oracle数据库安装的操作系统
上一篇 /
下一篇 2008-03-28 16:09:44
如何判断Oracle数据库安装的操作系统[转自www.eygle.com]
有朋友问到这样一个问题:如何远程判断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 -64bitProduction
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 Production
TNS for HPUX: Version 9.2.0.6.0 - Production
NLSRTL
Version 9.2.0.6.0 - Production
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG: