,Hi,
i installed my oracle linux on virtual box and there i installed oracle software.
when i checked my dbtimezone and sessiontimezone , both gives different values.i checked my oracle linux timezone (which is my server) but its in IST.
SQL> select dbtimezone from dual;
DBTIME
------
+00:00
------------------------------------------------
SQL> select sessiontimezone from dual;
SESSIONTIMEZONE
-----------------------------
+05:30
---------------------------------------------------------------
timezone of the linux machine
SQL> !date +%Z
IST
---------------------------------------------------------------------------------------
Please help me out