Select from DBA_SCHEDULER_JOBS gives "ORA-01882 Timezone Region Not Found" after Upgrade from 9.2
(Doc ID 1112328.1)
Last updated on FEBRUARY 02, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
After upgrade from 9.2.0.8 to 11.2.0.1 "ORA-01882: timezone region not found" error occurs when attempting to select fields with time zone data from dba_scheduler_jobs.
The problem does not reproduce on a new 11.2.0.1 database created under the same Oracle install.
Changes
Recently upgraded to 11.2 from 9.2.0.8.
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 |
Changes |
Cause |
Solution |