www.eygle.com

---

December 4, 2005

Install MT plugins-Scode 1

作者:eygle

出处:http://blog.eygle.com

终于对铺天盖地的spam留言忍无可忍了,20条一批的删除也要删好久,今天花了点时间安装了anti-spam的优秀插件Scode,这一插件通过加入图片验证码可以有效的防止机器人回复,但是同时会给大家回复带来一点小负担,希望大家不要介意.

 安装Scode需要Perl的GD模块支持,GD模块可以使用CPAN通过如下步骤安装:

perl -MCPAN -e shell

cpan> d /gd/

cpan> install L/LD/LDS/GD-2.30.tar.gz

之后安装SCODE插件就很顺利了.

Posted by eygle at 1:40 PM | Comments (2)

---

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

作者:eygle

出处:http://blog.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 - 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

Posted by eygle at 2:00 AM | Comments (6)

---