date format slips to default

From: Jay <me_at_heyjay.com>
Date: Wed, 23 Jun 2004 09:23:06 -0500
Message-ID: <3b6dnaf4OZpTDkTd4p2dnA@speakeasy.net>

Hi,

Every so often (no real specific amount of time), while my database is up and running, the system wide date format slips from the format in my init.ora of 'YYYY/MM/DD HH24:MI:SS' to the oracle default of "dd-mon-yyyy".

Any one ever see this?

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 on linux

[o10]:~> cat /opt/oracle/admin/o10/pfile/init.ora | grep NLS_DAT NLS_DATE_FORMAT = 'YYYY/MM/DD HH24:MI:SS' ps, is there a way to set the NLS_DATE_FORMAT system wide while the DB is up?

SQL> alter system set nls_date_format = 'yyyy/mm/dd hh24:mi:ss'; alter system set nls_date_format = 'yyyy/mm/dd hh24:mi:ss'

                 *

ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this option

Thanks
Jay Received on Wed Jun 23 2004 - 09:23:06 CDT