I would like to delete or rename an oracle data file called abc.ora in NT server. The database is deleted and the oracle service is shut down. After reboot the NT box, the data file can not be deleted or renamed, I got the error message as follow:
"Cannot rename abc.ora: There has been a sharing violation. The source or destination file may be in use."
Does someone know how to deal with this problem? Please give me some help since this is an urgent issue for us.
Thanks in advance,
Well , IŽd got something like that with my OAS.
Solution could be dangereus to you but to me it worked. Think twice.
The problems is that file is still in your machine memory, though you put the service down.
You should shoot down THE SERVER and then you will be able to delete the file.
Hope this works.
You said that I should shoot down THE SERVER. If I understand you, I did the same thing as you did - I rebooted NT server but it doesn't work for me.
Anything else could I do?
Thanks for your input,
Upppsss now I do not know which application , tools or whatever is using that file.
SHUTDOWN the database.
At OS level Move d:\abc.ora to d:\newdir\abc.ora
Startup and Mount the database
Rename data file now .
Open the database.
But I can't move this datafile. The database is already deleted.
Well, NT can be a bit flaky sometimes. We mainly had problems when we tried reinstalls, but here are a couple things we've tried:
Did you disable the NT services as well as stop them, so they won't try to restart on reboot?
Did you also delete the instance, as well as the database, along with the control file, init file, etc?
Thanks all! It worked after doing disable NT services and reboot box.