启动时出现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身份连接并执行

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

shutdown abort

然后正常启动

这篇关于启动时出现Oracle错误“此实例正在进行另一次启动/关闭操作".的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！