Hi,
I tried SHUTDOWN IMMEDIATE on Oracle NT but it hangs after working several times. I knows this sounds a bit strange but this is really happening.
The situation is I'm testing the backup script which is supposed to set in scheduler and run automatically. The script run smoothly the first time, the second ..... But after I tried the backup script for a couple of times (no more than 5 times). The script hangs in the SHUTDOWN IMMEDIATE command. I tried to reboot the NT Server and test the backup script again. It worked again at the time but after a couple of times, the cycle repeats and the machine hangs up again!!!
The environment is Oracle 8.1.5 under NT Server. And the backup script is a simple physical OS backup, including shutdown database, create the archive directory, copy the datafiles and control files and then open the database.
Please Please for any advise. I really don't know what's wrong and what can I do with it now.
Thanks,
Nancy