启动时出现 Oracle 错误“正在进行此实例的另一个启动/关闭操作”
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4902867/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle error on startup "another startup/shutdown operation of this instance in progress"
提问by user437969
I made a mistake in starting my local oracle instance. I did not set the oracle_sidbefore issuing sqlplus "sys as sysdba"and SQL> startup. Now I am unable to startup my instance. Please help me know how to shutdown the erroneous instance. Thanks.
我在启动本地 oracle 实例时犯了一个错误。我没有设置oracle_sid之前的发行sqlplus "sys as sysdba"和SQL> startup。现在我无法启动我的实例。请帮助我知道如何关闭错误的实例。谢谢。
回答by Lev Khomich
close all sessions for this instance, or connect as sysdba and execute
关闭此实例的所有会话，或以 sysdba 身份连接并执行
shutdown abort
and then startup normally
然后正常启动
回答by Jayaprakash Nagarajan
Rename the file $ORACLE_HOME/dbs/lkinst<instance_name>.
Then try shutdown abort
重命名文件$ORACLE_HOME/dbs/lkinst<instance_name>。然后尝试关闭中止
