In response to the "how to set environment vars via nsd" question: If you are using .tcl config files, you could probably just source a file that sets the environment vars. The traditional aD was is to make a wrapper for nsd called nsd-oracle that sets up the environment (NLS_DATE_FORMAT, etc.) then calls nsd. Only hazzard is forgetting this trick and starting your server using nsd - and then spending 30 minutes trying to figure out how you broke your server.
