学习oracle技术,每天学一点,每天进步一点

ORA-09968: scumnt: unable to lock file

上一篇 / 下一篇  2007-12-22 09:23:53 / 个人分类:数据库维护

ORA-09968: scumnt: unable to lock file该怎么处理,急!
-r5[&BG3Z0ALTER DATABASE MOUNT
;^&PQA ?Or0Fri Nov 9 09:42:32 2007
-pvYEx5p+k0scumnt: failed to lock /orajl/product/9.2/dbs/lkORAJL exclusive
\} iKD+l3x"Z0Fri Nov 9 09:42:32 2007ITPUB个人空间zDh1p$r2U6~
ORA-09968: scumnt: unable to lock file
8YmF(kY.NXN&k0HP-UX Error: 13: Permission denied
.{ D J0cZ-p8b ?,C0Additional information: 28329
1iR6X3s5h;}0Fri Nov 9 09:42:32 2007
f`"Q-u eB l^ d0ORA-1102 signalled during: ALTER DATABASE MOUNT..
B(Z!a r-{,Q {0ITPUB个人空间b A;~hw,DI/{
的处理方法ITPUB个人空间$Q rN)ELQk
fuser -u /orajl/product/9.2/dbs/lkORAJL
RMt0D/X{!sD$s*d0
Ak%L ]7DC]0看下面是否有用户占用
VHg!ZbY0有的话,用以下命令杀掉ITPUB个人空间 W p-x:@M
ITPUB个人空间/L R,k j1VC?

5a@-KD#j2u(D2g0ITPUB个人空间Y7@[1z a'M)Z
fuser -k /orajl/product/9.2/dbs/lkORAJLITPUB个人空间2cGM \ ^;|;m$\f
ITPUB个人空间4~E Z#lg|I~
然后shutdown immediate;ITPUB个人空间r&z+qa&j
startupITPUB个人空间`d9SC8v-NIr

Linux命令:Fuser 分类:Linux入门/系统维护 fuser命令在linux系统中用来根据文件或文件结构识别进程。
2x&~ } ?7E_K/N!f0使用权限:ITPUB个人空间d`#df#C+L'BR
  超级用户
T ?m!x5J\s]0语法格式:
3u.v5Z}o;Y}.v/K0  fuser [ -c | -d | -f ] [ -k | -K { SignalNumber | SignalName }] [ -u ] [ -x ] [ -V ]File ...ITPUB个人空间} zOvj|1`[
使用说明:ITPUB个人空间5x;P7c-ex*n$m&\ j0w
  此 fuser 命令列出了本地进程的进程号,那些本地进程使用 File 参数指定的本地或远程文件。
.If+qOS;n:Rk0对于阻塞特别设备,此命令列出了使用该设备上任何文件的进程。
$W3fWvD|]u0每个进程号后面都跟随一个字母,该字母指示进程如何使用文件。
&y8E1IHI0c 将此文件作为当前目录使用。ITPUB个人空间:Jdg|(@v
e 将此文件作为程序的可执行对象使用。ITPUB个人空间s5A$ye}5V nGmhk-Wt y
r 将此文件作为根目录使用。ITPUB个人空间8I9s1y9@"Kq;B#I
s 将此文件作为共享库(或其他可装载对象)使用。ITPUB个人空间c\"OR{)R Lf
进程号被写入标准输出(在进程号之间有空格的行中)。
{S0ii-@L-B'^0一个换行符被写入标准错误(在每个文件操作数的最后一个输出之后)。其他所有输出被写入标准错误。
Ljm_JT L _0此 fuser 命令不会检测有 mmap 区域的进程,其中相关的文件描述符已从此被关闭。
G'A#}?Adz0主要参数:
g3m&}'G%P Zf&Yj1U4|0  -c 包含 File 的文件系统中关于任何打开的文件的报告。
-y7`~8V/I8~s0  -d 暗示使用了 -c 和 -x 标志。
PhZ j1C&w0p"o0关于任何与文件系统(自父目录删除的)无链接的打开文件的报告。
wP\f/xTJe$o.G0当与 -V 标志一起使用时,它也会报告被删除文件的节点号和大小。
O;cz}U0-f 仅对文件的打开实例报告。ITPUB个人空间/em[1z#Z
-K SignalNumber | SignalName 将指定信号发送到每个本地进程。ITPUB个人空间Fa@+[N:_Rv%Z!{
仅有 root 用户能终止另一用户的进程。信号可以指定为信号名称(如 -9)或 KILL(用于 SIGKILL 信号)。ITPUB个人空间:? ^\y]B4@i
SignalName 的有效值是 kill -l 命令所显示的那些值。ITPUB个人空间V5f w6^:pX;M
-k 将 SIGKILL 信号发送到每个本地进程。仅有 root 用户能终止另一用户的进程。
h]E$I XV.G0注:ITPUB个人空间MlC'wJ\
fuser -k 或 -K 可能无法检测和杀死程序开始运行后立即创建的新进程。ITPUB个人空间 j'B#^)A/W
-u 为进程号后圆括号中的本地进程提供登录名。
yh*t2J4I"Ck?3I B0-V 提供详细输出。
2i'HQ C&nG0-x 与 -c 或 -f 连用,报告除标准 fuser 输出以外的可执行的和可载入的对象。ITPUB个人空间)C^g'bay
应用实例:ITPUB个人空间 H+t2F&r]:n/[0bn
  要列出使用 /etc/passwd 文件的本地进程的进程号,请输入:ITPUB个人空间,x"jw$E nqL%MZ
fuser /etc/passwdITPUB个人空间,z5^e!E5V/Lut
要列出使用 /etc/filesystems 文件的进程的进程号和用户登录名,请输入:
EZ:VraeI7K`0fuser -u /etc/filesystemsITPUB个人空间|q2ozv5zj ~
要列出正在使用已从给定文件系统删除的文件的全部进程,请输入:ITPUB个人空间7F1W!pi'|1a0F |
fuser -d /usr
*SvZ4yEH&[5mp0
V3~)~~^$h0ITPUB个人空间s)h#Q"n b
fuser -km /homeITPUB个人空间3~-A(gS^8Y"d4v
kills all processes accessing the file system /home in any way.
$c}%C"m4f)~g0
Yyfy?|;M|0if fuser -s /dev/ttyS1; then :; else something; fiITPUB个人空间tj X7fE3y-x
invokes something if no other process is using /dev/ttyS1.
tKApp kr@0
[PBI%M aDQS0fuser telnet/tcpITPUB个人空间P+~]x"p
shows all processes at the (local) TELNET port.
|0eY:z.GGB0ITPUB个人空间$o3U N`8{qcs,V%L
fuser [-a|-s] [-n space] [-signal] [-kimuv] name ... [-]
aq} t/Mt7w0[-n space] [-signal] [-kimuv] name ...
)ru}k[i*p0wp6d Bs0fuser -lITPUB个人空间gWk:g)p_^$\)r
fuser -VITPUB个人空间1U%KkrW1{-S
ITPUB个人空间v"@0d[*y`QbKB
c current directory.ITPUB个人空间XoA?2V,A
e executable being run.
?1T Mdq+S6p}0f open file. f is omitted in default display mode.
'YB*~]"as/N.[o3Y0r root directory.ITPUB个人空间G8^ U5Tp H;W-pL4A
m mmap'ed file or shared library.
Fl7an.DF+W0ITPUB个人空间c1\+y/Q"KC

%rd&CV B8z1brhP0List Open Files: lsof and fuser-进程相关ITPUB个人空间M:g7l6~g

a |vHv^0The function of these commands is very similar. The goal is to determine what processes have certain files open. lsof is freeware and thus freely compilable under all Unixes. It is available by default under Linux only.ITPUB个人空间3n-@)GO9At*|

,E y G9PMcW0The main difference between lsof and fuser is that lsof takes both files/filesystems and PIDs as arguments whereas fuser only accepts files/filesystems.ITPUB个人空间e Yz ?f/op?C v%E

3S~k'U D&c8k0lsof:
4^"a)KxU6O0lsof stands for list open files. It lists information about files that are currently open by processes.ITPUB个人空间y1t:[8jj)g
In the absence of any options, lsof lists all open files belonging to all active processesITPUB个人空间.|s Fd(hO9e8n
ITPUB个人空间nD9R-aQk%i,R
To list all open files for login name ``abe'', or user ID 1234 you would use the -u option. To list files being used by process 456, process 123, or process 789, you would use the -p flag. Putting these criteria together, we would have a command that looks like this:
m+Y}j+thh!~.f0ITPUB个人空间o;o2l!X*N#\3U#dz
lsof -p 456,123,789 -u 1234,abe
Kd} fL0z4t;b0ITPUB个人空间'IlZ.[A%S rR
The command to list all open files on device /dev/hd4, would look like this:ITPUB个人空间)D]Bw }

.r1m8P{g~/h^'K$Vv0lsof /dev/hd4
+}6u!Nv-r#Su9g!y0ITPUB个人空间3o XN'LqY9m$K
To find the process that has /u/abe/foo open, use:ITPUB个人空间^}JlH

Vda5w#J _N:i0lsof /u/abe/fooITPUB个人空间#x y x W{@sg

OtqG%d sNG0fuser:ITPUB个人空间AO7B+DE
fuser is more widely available (under AIX, HP-UX, IRIX, Linux, Solaris, Tru64 UNIX, and others) and can only be run as root. It displays the process ID numbers of processes using the specified files or file systems. In the default display mode, each file name is followed by a letter denoting the type of access (these codes differ from vendor to vendor):ITPUB个人空间wu!By4g9f
a if the process is using the file as its trace file in /proc (IRIX)
+uXH8Ut]0c if the process is using the file as its current directoryITPUB个人空间x@Ef0j
e if the process is using the file as the executable being runITPUB个人空间 W+m4v;b)XA
f if the process is using the file as an open file (Linux)
at$B3xe]0m if the process is using the file as a mmaped or shared lib (Linux)
8N'KP h?q4?&Q0o if the process is using the file as an open file (IRIX, Solaris, Tru64 UNIX))ITPUB个人空间6HXa!H.Z Xe7}
p if the process is using the file as the parent of its current directory (Tru64 UNIX)ITPUB个人空间 Z#} S:|Tg
r if the process is using the file as root directoryITPUB个人空间6y@e~2D"U
s if the process is using the file as a shared lib (AIX)
E*uBW\d G"_O0t if the process is using the file as its text file (Solaris)ITPUB个人空间a@_:S*z?'z1f
y if the process is using the file as its controlling terminal (IRIX)ITPUB个人空间,n:g,}eYMy2C8s,~t
ITPUB个人空间.`X3[ uD7Jb

v6V {3M&c#y\ C0Here is an example of fuser running under Linux:ITPUB个人空间[+NEW4? H
ITPUB个人空间&z.SwW*m`
ITPUB个人空间"{}[(IT
linux# /usr/sbin/fuser //: 1r 1c 2r 2c 3r 3c 4r 4c252r 252c 275r 275c 286r 286c 300r 314r 328r 328c 342r342c 356r 356c 374r 374c 385r 385c 396r 396c 411r 411c412r 412c 413r 413c 414r 414c 415r 415c 416r 416c 417r417c 418r 418c 419r 419c 420r 420c 455r 470r 470c 485r485c 500r 500c 538r 538c 539r 539c 540r 540c 541r 541c542r 542c 543r 543c 544r 544c 546r 546c 548r 548c 551r551c 556r 569r 591r 597r 610r 612r 614r 614c 618r 626r628r 636r 646r 7090r 7090c 7092r 7243r 7288r 7288c 7290r 7303rITPUB个人空间CP]QR0sP[^

c$st+|va/|0


TAG:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-12-02  
 123456
78910111213
14151617181920
21222324252627
28293031   

数据统计

  • 访问量: 26110
  • 日志数: 312
  • 图片数: 2
  • 建立时间: 2007-12-11
  • 更新时间: 2008-11-28

RSS订阅

Open Toolbar