启动时出现Oracle错误“此实例的另一个启动/关闭操作正在进行中”(Oracle error on startup “another startup/shutdown operation of th

启动时出现Oracle错误“此实例的另一个启动/关闭操作正在进行中”(Oracle error on startup “another startup/shutdown operation of this instance in progress”)

我在启动本地oracle实例时犯了一个错误。 在发出sqlplus "sys as sysdba"和SQL> startup之前，我没有设置oracle_sid 。 现在我无法启动我的实例。 请帮我知道如何关闭错误的实例。 谢谢。

I made a mistake in starting my local oracle instance. I did not set the oracle_sid before 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.

最满意答案

关闭此实例的所有会话，或以sysdba身份连接并执行

shutdown abort

然后正常启动

close all sessions for this instance, or connect as sysdba and execute

shutdown abort

and then startup normally