开发者

Oracle error on startup "another startup/shutdown operation of this instance in progress"

I made a mistake in starting my local oracle instance. I did not set the oracle_sid before issuing sqlplus "sys as sysdba" and S开发者_运维问答QL> startup. Now I am unable to startup my instance. Please help me know how to shutdown the erroneous instance. Thanks.


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

shutdown abort

and then startup normally


Rename the file $ORACLE_HOME/dbs/lkinst<instance_name> . Then try shutdown abort

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜