ASM alert log is full of messages like this:
WARNING: too many parse errors, count=302700 SQL hash=0xa6cbf389 PARSE ERROR: ospid=4026, error=6550 for statement: 2018-04-10T14:32:00.956787+03:00 declare cursor NlsParamsCursor is SELECT * FROM nls_session_parameters;begin SELECT Nvl(Lengthb(Chr(16777216)), Nvl(Lengthb(Chr(65536)), Nvl(Lengthb(Chr(256)), 1))), Nvl(Lengthb(Chr(1)), 1) INTO :MaxCharLength, :MinCharLength FROM dual; for NlsRecord in NlsParamsCursor loop if NlsRecord.parameter = 'NLS_DATE_LANGUAGE' then :NlsDateLanguage := NlsRecord.value; elsif NlsRecord.parameter = 'NLS_DATE_FORMAT' then :NlsDateFormat := NlsRecord.value; elsif NlsRecord.parameter = 'NLS_NUMERIC_CHARACTERS' then :NlsNumericCharacters := NlsRecord.value; elsif NlsRecord.parameter = 'NLS_TIMESTAMP_FORMAT' then :NlsTimeStampFormat := NlsRecord.value; elsif NlsRecord.parameter = 'NLS_TIMESTAMP_TZ_FORMAT' then :NlsTimeStampTZFormat := NlsRecord.value; end if; end loop;end; Additional information: hd=0x7cf02228 phd=0x7cf04980 flg=0x100476 cisid=0 sid=0 ciuid=0 uid=0
These messages appears when spotlight connects to collect information from ASM.
WORKAROUND
None
SOLUTION
Waiting for a fix in a future version of Spotlight on Oracle.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center