今天因为测试一个东西,使用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 2016Copyright (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]$
然后就可以启动了。