首页 > 开发 > 综合 > 正文

ORA-09968 unable to lock file

2024-07-21 02:52:24
字体:
来源:转载
供稿:网友

今天因为测试一个东西,使用shutdown abort关闭数据库后,startup半天没动静,看alert日志,也是停留在启动实例的开始

Mon Jul 04 02:51:21 2016Starting Oracle instance (normal)

半天没反应,忍不了,新开了一个sqlplus会话shutdown  abort后startup force。结果报ORA-09968错误:

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 PRoduction on Mon Jul 4 02:34:37 2016Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to an idle instance.SYS>startup nomountORA-10997: another startup/shutdown Operation of this instance inprogressORA-09968: unable to lock filelinux-x86_64 Error: 11: Resource temporarily unavailableAdditional information: 1751SYS>shutdown abort   ORACLE instance shut down.SYS>startup nomountORA-10997: another startup/shutdown operation of this instance inprogressORA-09968: unable to lock fileLinux-x86_64 Error: 11: Resource temporarily unavailableAdditional information: 1751SYS>shutdown abortORACLE instance shut down.SYS>startup forceORA-10997: another startup/shutdown operation of this instance inprogressORA-09968: unable to lock fileLinux-x86_64 Error: 11: Resource temporarily unavailableAdditional information: 1751SYS>exit

Disconnected

果断不能忍,

[root@localhost ~]# ipcs------ Message Queues --------key        msqid      owner      perms      used-bytes   messages    ------ Shared Memory Segments --------key        shmid      owner      perms      bytes      nattch     status      0x00000000 65536      oracle     600        4194304    2          dest         0x00000000 163841     oracle     600        4194304    2          dest         0x00000000 294915     oracle     600        2097152    2          dest         0x00000000 5636102    oracle     600        4194304    2          dest         0x00000000 5734407    oracle     600        393216     2          dest         ------ Semaphore Arrays --------key        semid      owner      perms      nsems     

[oracle@localhost dbs]$ ps -ef|grep pmonoracle     2809   2083  0 02:56 pts/10   00:00:00 grep --color=auto pmon[oracle@localhost dbs]$

[oracle@localhost dbs]$ fuser */home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/lkinstorcl:  1751[oracle@localhost dbs]$ ps -ef|grep 1751oracle     1751      1 99 02:25 ?        00:24:06 oracleorcl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))oracle     2643   2083  0 02:50 pts/10   00:00:00 grep --color=auto 1751

[oracle@localhost dbs]$ kill -9  1751[oracle@localhost dbs]$ fuser *

[oracle@localhost dbs]$ 

然后就可以启动了。


发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表