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
精彩评论