怎么确定安装oracle,Oracle HowTo:如何判断Oracle数据库安装的操作系统

Oracle HowTo:如何判断Oracle数据库安装的操作系统

有朋友问到这样一个问题:如何远程判断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 Production

TNS for HPUX: Version 9.2.0.6.0 - Production

NLSRTL Version 9.2.0.6.0 - Production

By eygle on 2005-12-04 02:00 |

Comments (6) |

HowTo | 561 |

6 Comments

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

哪天我装个Dos按上Oracle。

select * from v$version;

看啥效果。

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

CORE9.2.0.6.0Production

TNS for HPUX: Version 9.2.0.6.0 - Production

NLSRTL Version 9.2.0.6.0 - Production