My Oracle Support Banner

Starting AVDF Audit Trail Generates ORA-01875 Error (Doc ID 2335227.1)

Last updated on JANUARY 30, 2020

Applies to:

Oracle Audit Vault and Database Firewall - Version 12.2.0.5 and later
Information in this document applies to any platform.

Symptoms

Starting the audit trail generates the following error ORA-01875: time zone minute must be between -59 and 59 error in the agent log files:

Nov 22,2017 17:43:50 PM logError
SEVERE: On line 675; ORA-01875: time zone minute must be between -59 and 59

Nov 22,2017 17:43:50 PM logError
SEVERE: zaoci.c : zaocisstz : Could not set session timezone for source "estateprd"!
Nov 22,2017 17:43:50 PM logError
SEVERE: zaodr.c : zaodrSetupCtx : Could not set session TZ to '-5:-30' for "estateprd"!
Nov 22,2017 17:43:50 PM logError
SEVERE: zaodr.c : zaodrSetupCtx : could not start collector 48 for source estateprd, internal error: [zaodrSetupCtx], Error code[61]
Nov 22,2017 17:43:50 PM logError
SEVERE: zaodr.c : zaodropds : Failed to setup context while opening source "estateprd"!
Nov 22,2017 17:43:50 PM logError
SEVERE: zaodr.c : zaodropds : Error during Cleanup of file list
Nov 22,2017 17:43:50 PM logError
SEVERE: zaoag.c : zaoagInitCollector : Could not open data source "estateprd"
Nov 22,2017 17:43:51 PM logError
SEVERE: zadcoll.c : zadcolldeamon : Collecting thread died with status 1

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.