rac环境sqlplus和plsql查出的时间不一致解决办法

 

 

>> su - grid

vim $GRID_HOME/crs/install/s_crsconfig_*_env.txt

#备份
cp $GRID_HOME/crs/install/s_crsconfig_ora112_env.txt $GRID_HOME/crs/install/s_crsconfig_ora112_env.txt.bak

#编辑(两节点都要改)
vim $ORACLE_HOME/crs/install/s_crsconfig_*_env.txt
改TZ=America/New_York ----> TZ=Asia/Shanghai

#重启CRS(两节点都要重启)
$GRID_HOME/bin/crsctl stop crs
$GRID_HOME/bin/crsctl start crs