Tintin, I myself not clear with my issue. That's the reason, I tried to ask a generic question about file locking concept.
One of our DBA sent a mail like this:
"Can you make this file available from OS(ltprodgui01.dbf). Files are present in their respective directory but Oracle is not able to acquire a lock on the file(s) mentioned below. This problem originated because DB was aborted after the UPS went down"
oracle@shrek2_cydrs% ls -lrt
total 5253232
drwxr-xr-x 2 oracle dba 4096 Jan 29 17:27 cydrs
-rw-r----- 1 oracle dba 1073750016 Feb 16 18:26 ltprodgui03.dbf
-rw-r----- 1 oracle dba 2147491840 Feb 16 18:26 ltprodgui02.dbf
-rw-r----- 1 oracle dba 2147491840 Feb 16 18:26 ltprodgui01.dbf
oracle@shrek2_cydrs% pwd
/proj/itg_ora1/u06/oradata
When I asked him, he is telling that while rebooting a system and when oracle starts along with it, it acquires some lock in many files. Only then the oracle will start successfully it seems. Here the problem is, when oracle starts all the files have acquired the lock, except these 3 files. So he is asking something to do fix this. These files are mounted from a NetApp filer. Any idea how to fix this? Do I need to know something on the NetApp filer like remounting?
Thanks,
Ashok
Main Topics
Browse All Topics





by: TintinPosted on 2007-02-17 at 15:32:36ID: 18556904
locking only works if all processes that access the file use the same type of locking. The most common is flock.
Please give some more detail as to what processes will be locking the file and for what purpose.