Timestamp used for messages in alert log after machine timezone change
From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Sun, 18 Sep 2011 20:19:27 +0100
Message-ID: <CAPMSPxP9FMQd4zjfdfhyqkG1nJOdHrV2DZNrma95R6w=EA6imw_at_mail.gmail.com>
Hi,
We changed the timezone of a machine to Chinese Central time, but the alert log timestamps are still US EST/EDT, the original timezone. If this is controlled by the NLS settings according to NLS_DATABASE_PARAMETERS, then I believe that these settings cannot be altered, but is there a way to change the timestamp used in the alert log?
Date: Sun, 18 Sep 2011 20:19:27 +0100
Message-ID: <CAPMSPxP9FMQd4zjfdfhyqkG1nJOdHrV2DZNrma95R6w=EA6imw_at_mail.gmail.com>
Hi,
We changed the timezone of a machine to Chinese Central time, but the alert log timestamps are still US EST/EDT, the original timezone. If this is controlled by the NLS settings according to NLS_DATABASE_PARAMETERS, then I believe that these settings cannot be altered, but is there a way to change the timestamp used in the alert log?
Thanks
Pete
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Sep 18 2011 - 14:19:27 CDT