COL_INSTANCE_TZ messes up after relink all command
Anyone encountered issue with COL_INSTANCE_TZ after re-linking oracle binary "relink" command. Only relink was done, no patching what so ever
(COL_INSTANCE_TZ must be +01:00)
1)
sqlplus u1/p1dbeutzn (does not work with @ symbol)
COL_SYSDATE COL_SYSTIMESTAMP COL_DBTIMEZONE COL_INSTANCE_TZ COL_SESSION_TZ COL_TIMESTAMP_IN_SESSION_TZ
----------------- ---------------------------------------- ------------------------- ------------------------- ------------------------- -------------------------------------------------------
20160922 16:26:40 22-SEP-16 04.26.40.943684 PM -04:00 -04:00 -04:00 Europe/London 22-SEP-16 09.26.40.943688 PM EUROPE/LONDON
(why this is not +01:00?)
2)
sqlplus u1/p1 (works as intended without @ symbol)
COL_SYSDATE COL_SYSTIMESTAMP COL_DBTIMEZONE COL_INSTANCE_TZ COL_SESSION_TZ COL_TIMESTAMP_IN_SESSION_TZ
----------------- ---------------------------------------- ------------------------- ------------------------- ------------------------- -------------------------------------------------------