Database error

[brightrif]

I have getting 3 errors
1) Check NLS_DATE_FORMAT by using SELECT statement.
07-NOV-11 is not the right format 'yyyy-mm-dd hh:mm::ss' (please check $ENV{NLS_DATE_FORMAT}).


2) Check NLS_LANG.
No NLS_LANG configuration found.

3)Check ORACLE_HOME configuration.
No ORACLE_HOME setting found.

but application working properly

[Trav]

What OS are you using?

I'm getting the same NLS_DATE_FORMAT error in my environment. If you set your ORACLE_HOME environment in the Config.pm, your "No ORACLE_HOME setting found" error should clear.

$ENV{ORACLE_HOME} = '/PATH/TO/ORACLECLIENT/'

[brightrif]

Redhat linux

[brightrif]

I already set the environment variable. still i am getting the error.

[VMania]

I already set the environment variable. still i am getting the error.

Inserting the following statement into the file "..\otrs\OTRS\scripts\apache2-perl-startup.pl" resolved (in my case) the misbehaviour you described. With this the "AdminSupport" page now shows green light.
# ORA-01861: literal does not match format string
$ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';

Obviously the "Config.pm" is not run at the right moment so that the settings don't load into Apache's runtime.
Is it a bug or only a lack of explanation in the "otrs_admin" manual?
Will the file "apache2-perl-startup.pl" be replaced during an update process?
However I can use it as a workaround until I do understand the context.