Date Problem on Oracle Cluster
Problem: When an Oracle node Aurea List Manager is talking to fails and Aurea List Manager transparently connects to another Oracle node, the NLS_DATE_FORMAT value for the session doesn't persist.
Solution:
create or replace trigger data_logon_trigger after logon ON DATABASE begin execute immediate 'alter session set nls_date_format = "YYYY-MM-DD HH24:MI:SS" '; end; /