server shutdonw from remote

  • From: Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 15 Jun 2005 13:10:15 +0530

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)


Other related posts: