open files

[Clutier_1]

Hi,
After closing oracle for backup successfully, i have some dbf files open which can't backup.
Also I seek to determine by which is open.
How can i do ?

[Robert-Jan Goossens]

Hi Clutier,

Lsof is a great tool to list open files, you can download the depot software at the HPUX porting centre,

http://hpux.connect.org.uk/hppd/hpux/Sysadmin/lsof-4.69/

Hope this helps,
Robert-Jan

[Michael Tully]

You can use 'lsof' if you wish, but you should be able to use the 'fuser' tool as well to find what process has the file open.

$ fuser /mydir/my.dbf

[Vijaya Kumar_3 · Accepted solution]

Hi

Lsof will be greatly useful for you.

Some commands example:

# lsof -c
# lsof -u
# lsof -u

Also used to find socket/ports:

# lsof -i tcp:23
# lsof -i udp:123


Hope it helps
-Vijay