Oracle time stamp showing wrong timezone connecting TNS remote
Time stamp problem:- sqlplus system/****@ORCL SQL>alter session set nls_date_format=’dd-mm-yyyy hh:mi:ss’; SQL>select instance_name from v$instance; SQL>select sysdate, current_timestamp, systimestamp, localtimestamp from dual; The above query will show different time . How to Fix:- 1.1 Stop the apps and DB cluster/HAS. su – root cd /orasw/app/grid/product/11.2.0/grid/bin ./crsctl stop crs –f su – grid cd /orasw/app/grid/product/11.2.0/grid/bin ./crsctl stop […]