数据库时间和主机时间比较怪异,server和client端也不一样

edeed

大家有遇到这种情况么？

一、主机时间和从主机直接sqlplus查询sysdate是一致的。
SQL> !date
Fri Aug 24 11:23:51 BEIST 2007

SQL> select sysdate from dual;
SYSDATE
-------------------
2007-08-24 11:23:58

二、客户端（如toad）查询sysdate比从主机直接sqlplus查询sysdate要多1小时。

三、alert文件中时间要比主机时间多1小时。
SQL> alter system switch logfile;

System altered.

SQL> !
$ pwd
/opt/oracle/db01/app/oracle/admin/ORCL/bdump
$ ls -l alert*
-rw-r--r--   1 oracle   dba        32842239 Aug 24 11:26 alert_ORCL.log
$ tail alert*
ARC0: Completed archiving  log 3 thread 1 sequence 338182
Fri Aug 24 12:26:04 2007
Thread 1 advanced to log sequence 338184
  Current log# 4 seq# 338184 mem# 0: /opt/oracle/db02/oradata/ORCL/redo4.log
Fri Aug 24 12:26:04 2007
ARC1: Evaluating archive   log 5 thread 1 sequence 338183
ARC1: Beginning to archive log 5 thread 1 sequence 338183
Creating archive destination LOG_ARCHIVE_DEST_1: '/opt/oracle/arch/ORCL/1_338183.dbf'
Fri Aug 24 12:26:16 2007
ARC1: Completed archiving  log 5 thread 1 sequence 338183
$ echo $TZ
BEIST-8