查看dbtimezone显示为+00:00，理论上应为+08:00，解决方案如下:

SQL> select sessiontimezone from dual ;

SESSIONTIMEZONE
--------------------------------------------------------------------------------
+08:00

SQL> select dbtimezone from dual;

DBTIMEZONE
------------------
+00:00

SQL>  alter database set time_zone='+8:00';

Database altered.

SQL> select dbtimezone from dual;

DBTIMEZONE
------------------
+00:00

SQL> startup force;  
ORACLE instance started.

Total System Global Area 2516581448 bytes
Fixed Size                  9141320 bytes
Variable Size            1140850688 bytes
Database Buffers         1342177280 bytes
Redo Buffers               24412160 bytes
Database mounted.
Database opened.
SQL> select dbtimezone from dual;

DBTIMEZONE
------------------
+08:00

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle