Oracle 10.2.0.4 on Windows Server 2003 R2
On my unix boxes I run rman out of shell scripts with the following:
export NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS'
rman ....
Which works very well to get all of the 'current time' items in the rman output to be formatted with date and time.
Now I have to do the same on a Windows box, so have in my script
set NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS'
rman ....
That results in
RMAN> connect target *
2> show all;
3> list backup;
4> report obsolete;
5> quit
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-00604: error occurred at recursive SQL level 1
ORA-02248: invalid option for ALTER SESSION
Recovery Manager complete.
removing the "set NLS_DATE_FORMAT" from the script allows rman to work as expected, but of course then the date/time is not being reported the way I'd like. Has anyone observed this difference in behavior between *nix and Windows? Neither google nor MOS turned up anything on it, that I could find.