Urgent Help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Urgent Help

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    5

    Angry

    Hi All,

    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,

    Stella

  2. #2
    Join Date
    Oct 2000
    Posts
    13

    Exclamation

    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.

  3. #3
    Join Date
    Oct 2000
    Posts
    5
    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,

    Stella

  4. #4
    Join Date
    Oct 2000
    Posts
    13

    Unhappy

    Upppsss now I do not know which application , tools or whatever is using that file.

    Sorry.

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    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.

  6. #6
    Join Date
    Oct 2000
    Posts
    5
    But I can't move this datafile. The database is already deleted.

  7. #7
    Join Date
    Oct 2000
    Posts
    8
    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?

    Good Luck!
    Jan
    Jan

  8. #8
    Join Date
    Oct 2000
    Posts
    5
    Thanks all! It worked after doing disable NT services and reboot box.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width