Thursday 6 March 2014

Timezone issue while connecting to Oracle database from SQL developer client Tool

Hi Guys..

You need to modify sqldeveloper.conf
Steps are given below
1)  Go to the installation directory of Oracle SQL Developer.
2)  Open the file located at: sqldeveloper/bin/sqldeveloper.conf.
3)  At the end of file, add the following line:
    AddVMOption -Duser.timezone=GMT-4

4) Now, restart the SQL developer tool from command prompt.
 Command to start :
sqldeveloper/sqldeveloper/bin$sh sqldeveloper.sh
OR
sqldeveloper/sqldeveloper/bin$./sqldeveloper.sh

5) Connect to data base and test the connections now, you will not get time zone error while connecting. 


I believe in "Learning never exhausts the mind"  

No comments:

Post a Comment