Not able to halt Oracle pkg occasionally

[yc_2]

Hi,

In MC/SG environment, we used to halt Oracle pkg; mount back the oracle file system to stand alone and use fbackup to perform file system to backup using cron.

Occasionally, the halting is not successful due to some processes still attaching to the file system.

I believed that cmhaltpkg uses fuser to remove processes that attached to the file system as indicated in the log file below but it failed to do so:

Mar 22 21:05:34 - Node "tphost2": Unmounting filesystem on /dev/vg04/lvol3
WARNING: Running fuser to remove anyone using the file system directly.
/dev/vg04/lvol3: 8902mto(ora8p) 8952mto(ora8p) 9004o(ora8p)

umount: cannot unmount /ora_prod_11i : Device busy
ERROR: Function umount_fs
ERROR: Failed to unmount /dev/vg04/lvol3

How can this be avoided ?


Thanks in advance,
YC

[Steven Sim Kok Leong]

Hi,

I had a similar problem with my MC/ServiceGuard. Installing the latest fuser patches fixed it. The patch I installed might have already been superceded, but it solved the problem:

# PHCO_21901 1.0 fuser(1M) cumulative patch

Search for the latest fuser patch in the ITRC, install it and see if it works.

Hope this Regards.

Steven Sim Kok Leong
Brainbench MVP for Unix Admin
http://www.brainbench.com

[Steffi Jones_1]

Hello,

I agree with the suggestion to install the latest fuser patch.
One other thing you can try is to also change the FS_UMOUNT_COUNT parameter in
package control script from 1 to 2

Steffi Jones

[Jeen Oppedijk]

I would try to find the cause of the processes running. Does your database go down correctly? If not, maybe you could use "shutdown abort; startup restricted; shutdown;" in your shutdown script. That way all users will be disconnected and it will leave the database in a consistent state.
I don't think any processes will be left after this.
Good luck.
Jeen

[Sig. Alessandro MESSINA]

This kind of problem appears sometimes in my configuration.
Due a limitation of the fuser command sometimes fuser in not able to kill all process attached to a mount point, especially when the process are enough, try this :

1) modify the fs_umount procedure adding a loop that try for a series of fuser -cku
2) sometimes umount complain about a device busy, but with fuser no process seems to using the FS, so use the free command lsof (list open files), is more powerful than fuser, pass the result of lsof to a kill command, it will kill everything attached to the FS mount point