My Oracle Support Banner

NLS_DATE_FORMAT for sesssion lost causing ORA-01843 not a valid month (Doc ID 742724.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2]
Information in this document applies to any platform.

This problem can occur on any platform.


The following errors during normal running of the application

ORA-01843: not a valid month

- After the first occurrence of the error it reoccurs with each query
- After the first appearance of the ORA-01843 error it's observed that the date format in the Oracle session of the application changes
- The only workaround once the problem occurs is restarting the application server process (which
is most unpleasant in a CRM
- The application typically works for several hours before the first occurrence of the error
- The problem occurs in a weblogic application




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

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