国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 開發 > 綜合 > 正文

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]$ 

然后就可以啟動了。


發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 阜阳市| 札达县| 仁寿县| 武夷山市| 晋中市| 昌吉市| 惠州市| 平安县| 黔西县| 衡山县| 宝兴县| 皋兰县| 襄樊市| 广东省| 萝北县| 叶城县| 乳山市| 绩溪县| 福建省| 盐津县| 揭东县| 江门市| 富顺县| 祁门县| 龙里县| 珲春市| 屏边| 桐庐县| 安化县| 外汇| 长葛市| 昌宁县| 武城县| 林州市| 灌阳县| 孝义市| 淮安市| 兴文县| 石景山区| 平阳县| 六安市|