hi oracle gurus, We have got one dramatic situation where one of our remote dba shutdown the database, which was not supposed to be done. Now I have been asked to stop these sort of situation in future. I know in this situation I need to use trigger(on database before shutdown) but the problem is I dont know how to check the machine name from within the trigger from where the shutdown command has been invoked... Any suggestion??????? -- Thanks & Regards, T. Onkar Nath Ph : +91-9826728111(Cell) to_onkar@xxxxxxxxx onkarnath.tiwary@xxxxxxxxx -- //www.freelists.org/webpage/oracle-l