it's almost certainly your NLS_DATE_FORMAT. Can you check this query in a SQL*Plus session?
select sysdate from dual;
SYSDATE ---------- 2007-05-16
If this is in YYYY-MM-DD, then AOLserver is not correctly reading your environment variables. Do you have a wrapper script for AOLserver?
Brian
The environment variable are set in 2 places. one in my bash profile and another in the run file of aolserver. In run file the format is different hence it is giving the error.
It is fixed now. Thanks a lot for the help.
Asif.
