Wednesday, July 27, 2011

Error occurred when creating new connection on first time in SQL Developer

I have experienced a problem of creating a new connection through the SQL developer, after first time I install SQL developer. I gave all the parameters correctly when creating new connection.
Although I have given proper connection name, correct username and password with correct SID, following error alert when I click the test button on the SQL developer interface.

“Status: Failure – Test failed: ORA-00604: error occurred at recursive SQL level    1ORA-01882: timezone region not found”

See the following figure:




To resolve this error I had to edit the “sqldeveloper.conf” file in the ‘\sqldeveloper\sqldeveloper\bin’ directory. It need to add the  following line and save the file.

AddVMOption -Duser.timezone=SAST-2

Close the SQL developer and reopen. Try now. It will show “Status: Success”.
Now you can connect to the database successfully.

5 comments: