Oracle Repository creation utility Unable to connect to oracle 11g Enterprise Edition database DB ORA-01882: timezone region

Tags: oracle
By : David
Source: Stackoverflow.com
Question!

it happened on Oracle fussion middleware error.

Unable to connect to the DB. Check if DB connection details entered are correct. ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found

To be very honest, i i've searched thouroughly.

i found out that it had something to do with the jdk in my oracle 11g ee edition so i tried running timezone updater on the jdk, but the timezone was unable to update.. it returned an error saying 'cant rename {0} to {1}'.

am not even sure am on the right path... please can someone out there give me a hand.

By : David


Answers

Installation of FMW falls into two categories: Developer and Production. Developer uses soa_quickstart + WCC + WCP + MFT etc. WLS and all needed files are installed in this installation and then there are 3 different domains that can be used/configured - local to JDev, standalone (file based no DB or RCU required) and Compact (db required + RCU). Production requires WLS + infrastructure + binaries (SOA/OSB/BPM, MFT, WCC, WCP). These are all separate installs and require DB and RCU as well. So, the question is: what are you installing and why? If you are installing for a production env you should follow the oracle install instructions and EDG closely. If you are installing a dev env, then it is very fast and easy - a standalone env is a great choice. While there are some capabilities not available in a Standalone/File- based install, it is still the preferred choice for SOA/OSB/BPM developers. If you simply want a FMW install to play with or use as a developer, you can download and install a free VirtualBox image that comes fully configure and ready to use. You should also consult the system compatibility guide as well, just to be sure.

By : Joe


the timezone error was coming up as a result of the character set i selected for my database. it was suppose to be utf8 however, i choose some other one. i had to uninstall my database, and recreated a new one using "utf8" character set, which happens to be a general standard. :)

By : David


var text = "|+HP:+20";
// Break string into an array of strings and grab last element
var results = text.split('+').pop();

References:

By : Ouroborus


This video can help you solving your question :)
By: admin