DanBrother的部落格

Error retrieving information from database. Exception: ORA-01882: timezone region not found
ORA-06512: at "SYSMAN.MGMT_GLOBAL", line 8
java.sql.SQLDataException: ORA-01882: timezone region not found
ORA-06512: at "SYSMAN.MGMT_GLOBAL", line 8
oracle.sysman.emSDK.app.exception.EMSystemException

Solution:
# $OMS_HOME/bin/emctl stop oms -all
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
AdminServer Successfully Stopped
Oracle Management Server is Down


# grep "ZONE=" /etc/sysconfig/clock
>>
ZONE="Asia/Taipei"

# . oraenv
ORACLE_SID = [CCDB]

# sqlplus / as sysdba

col TZname format a20
col TzAbbrev format a20
select TZname,TzAbbrev from v$timezone_names
where Tzname = 'Asia/Taipei'
order by TzAbbrev;
>>
TZNAME               TZABBREV
-------------------- --------------------
Asia/Taipei          CDT
Asia/Taipei          CST
Asia/Taipei          LMT

cd /u01/Middleware12cR2/gc_inst/user_projects/domains/GCDomain/bin
cp setDomainEnv.sh setDomainEnv.sh.OLD

edit setDomainEnv.sh 

# JAVA_PROPERTIES="-Dplatform.home=${WL_HOME} -Dwls.home=${WLS_HOME}

   -Dweblogic.home=${WLS_HOME}"

JAVA_PROPERTIES="-Dplatform.home=${WL_HOME} -Dwls.home=${WLS_HOME} 

  -Dweblogic.home=${WLS_HOME} -Duser.timezone=Asia/Taipei"


# $OMS_HOME/bin/emctl start oms