今天因为测试一个东西,使用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>exitDisconnected
果断不能忍,
[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]$
然后就可以启动了。
新闻热点
疑难解答