ORA-09968 unable to lock file

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

Mon Jul 04 02:51:21 2016
Starting 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 2016
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.
SYS>startup nomount
ORA-10997: another startup/shutdown operation of this instance inprogress
ORA-09968: unable to lock file
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 1751
SYS>shutdown abort   
ORACLE instance shut down.
SYS>startup nomount
ORA-10997: another startup/shutdown operation of this instance inprogress
ORA-09968: unable to lock file
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 1751
SYS>shutdown abort
ORACLE instance shut down.
SYS>startup force
ORA-10997: another startup/shutdown operation of this instance inprogress
ORA-09968: unable to lock file
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 1751
SYS>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 pmon
oracle     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 1751
oracle     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]$ 

然后就可以启动了。

  • 0
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值