반응형
ORA-27086: unable to lock file - already in use
In Alert log :
usually this problem occurred because NFS is Hanged,and can check OS logs to find "statd: server localhost not responding, timed out".
1- Check rpc.stat is working and you can restart again , and you have to Restart NFS Services also
Stop :
Please follow the order, also note that when you restart the NFS service the server could hang at most for 1 minute.
Finally you should Reboot your server.
Thank you
Osama Mustafa
Thu Feb 14 09:34:57 EST 2013
Errors in file /u01/app/oracle/admin/rdmetdev/udump/rdmetdev_ora_6321.trc:
ORA-27050: function called with invalid FIB/IOV structure
Additional information: 2
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 37: No locks available
Additional information: 10
usually this problem occurred because NFS is Hanged,and can check OS logs to find "statd: server localhost not responding, timed out".
1- Check rpc.stat is working and you can restart again , and you have to Restart NFS Services also
Stop :
# service nfslock stopStart :
# service nfs stop
# service portmap stop
# umount /proc/fs/nfsd
# service portmap start
# service nfs start
# service nfslock start
# mount -t nfsd nfsd /proc/fs/nfsd
Please follow the order, also note that when you restart the NFS service the server could hang at most for 1 minute.
Finally you should Reboot your server.
Thank you
Osama Mustafa
출처 : http://osamamustafa.blogspot.kr/2013/02/ora-27086-unable-to-lock-file-already.html
반응형
'Database > ORACLE' 카테고리의 다른 글
inactive and locked 세션 관련 (1) | 2017.09.25 |
---|---|
SQL 튜닝의 시작 사용 SQL 스크립트 (0) | 2017.09.17 |
2pc pending 관련 (0) | 2017.07.26 |
오라클 DBMS_XPLAN.display 시 time 나오지 않고 too old 테이블 표기 될 때 (1) | 2017.05.14 |
도스 모드 sql 실행 bat 배치 만들기 (0) | 2016.03.25 |