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.
Okay SHUTDOWN IMMEDIATE will take some time depending on the users connnected to the database.SHUTDOWN IMMEDIATE will take sometime to rollback the users transactions and if there are long running transactions it will take some time.Okay no probs it takes some time but while opening ur database ur database is in consistsent state and no recovery is reqd.
In case of any help please be free to ask me at firstname.lastname@example.org
One possible source is NT itself. I have been told that NT is not 100% efficient in returning resources from dead processes. Therefore, you may not have as much of the machine resources as you think after running the backup script twice, but all of the resources after a reboot.
This is Amit Ahuja, working as a Oracle professional in India. Could you please send me the script which you have created to Shutdown Oracle, take the backup, create the archive directory, copy the datafiles and control files and then open the database?
Have you run any perfomance reports to give you an idea about what's happening in DB? Do you have an NT expert who can tell you what NT is reporting?
You may be consuming too many resources to shut down quickly. Can you display the active process prior to your shutdown? What kind of activity are they doing?
The possibilty is Your Service might have been corrupted. Don't ask me why ? I don't have an answer. Sometimes it behaves Crazy. I did have have crazy experiences and I have seen others having that type of experiences with NT.
You can try removing the service and recreating the service using oracle oradim utility