Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01801:date format is too long for internal buffer

888907Sep 18 2011 — edited Sep 29 2011

Few users have got this error message .
Now since it is on database production i don't want want to try out things about which i am not sure .

Will these help?
1. Reducing the shared pool load will help reduce the frequency of this problem. It can also help to KEEP affected cursors in the cache via DBMS_SHARED_POOL.KEEP.
2. Change NLS settings on different clients to match. In particular so that they use the same NLS_DATE_FORMAT.

Since the database is being used for years i think the error is not related to NLS settings.
i am mentioning here few parameters from parameter file.

sga_max_size 369098752
sga_target 293601280
__shared_pool_size 180355072
shared_pool_reserved_size 9017753
shared_pool_size 0

Kindly suggest ASAP.
Thanks in advance.

ERROR MESSAGE:

ODBC--insert on a linked table 'Case_Management' failed.
[DataDirect][ODBC Oracle Wire Protocol driver ][Oracle]ORA-01801:date format is too long for internal buffer
ORA-06512:at "TMS.AUDINS_CASE_MANAGEMENT",line 83
ORA-04088:error during execution of trigger
'TMS.AUDINS_CASE_MANAGEMENT'(#1801)

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 27 2011

Added on Sep 18 2011

#automatic-storage-management, #database, #performance-availability

1 comment

916 views