Deleting Oracle10g database manually & kill oracle background processes on Solaris
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Deleting Oracle10g database manually & kill oracle background processes on Solaris

  1. #1
    Join Date
    Jan 2007
    Posts
    3

    Deleting Oracle10g database manually & kill oracle background processes on Solaris

    Hello,

    (1) I want to delete an Oracle 10g database manually on Sun Solaris 5.9 platform. Can you please let me know what are the steps in details for deleting it?

    (2) How to Kill oracle background processes for a particular database on Solaris machine ?
    My situation is that somebody here has deleted the database files without shutting down the Database Instance. So oracle background processes for that Database are still running on the machine. I am not able to stop the processes of that database even after rebooting the machine and not able to kill them. Can you please suggest on this?

    Thanks a lot in advance,
    Best Regards,
    Jigish.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Quote Originally Posted by Jacky014u
    Hello,


    My situation is that somebody here has deleted the database files without shutting down the Database Instance. So oracle background processes for that Database are still running on the machine. I am not able to stop the processes of that database even after rebooting the machine and not able to kill them.
    Thanks a lot in advance,
    Best Regards,
    Jigish.

    That is simply NOT possible!

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    --I thought that a file being used by an Oracle Instance or any other program
    can't be deleted because of some file locking mechanism.

    your O.S. allow you to delete Oracle Database files while the database is up and running? what happen to file locking/file management of your O.S.?
    ---------------

  4. #4
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    I'm also digging the idea of processes that are persistent across a cold reboot of a server Could it be that they simply restarted after you rebooted? That sounds far more sensible. What date do you get when you ps -ef|grep pmon?
    Assistance is Futile...

  5. #5
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    ahh.ok.

    Maybe the instance is still there in oratab and set to Y, or autostarted with run Commands(rc).
    ---------------

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