Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

COL_INSTANCE_TZ messes up after relink all command

edited Sep 25, 2016 2:46PM in Database Install/Upgrade/Opatch (MOSC) 1 commentAnswered ✓

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

-----------------                ----------------------------------------                                                                   -------------------------                -------------------------                 -------------------------                -------------------------------------------------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center