ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found weblogic

step 1, check the timezone of DB

SELECT dbtimezone FROM DUAL;

step 2,  alter the timezone

ALTER DATABASE SET TIME_ZONE='+00:00';

step 3, alter the timezone for weblogic  in setDomainEnv.sh  

JAVA_OPTIONS=${JAVA_OPTIONS}    -Duser.timezone=GMT

STEP 4 (OPTIONAL) :  WEBLOGIC CONSOLE

Adminserver Setting -> Configuration -> Server start -> params  add the following key-value:

-Duser.timezone=<timezone>