开发者

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

开发者 https://www.devze.com 2023-02-08 10:08 出处:网络
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.

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

精彩评论

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