SQL>startup spfile='.../spfileSID.ORA' or SQL>startup pfile='.../initSID.ora'
感谢冬瓜问的好阿:昨天我们测试库也被我玩成这样了 我是之前修改了一下init中archivelog的存放地址 做了shutdown immediate,然后startupmount的时候就显示ORA-27101 shared memory realm does not exist了,打开应用程序就显示:现在是火烧眉毛了.................. ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
or
SQL>startup pfile='.../initSID.ora'
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
我不知道你是甚么OS,我的是Windows NT的,打开oracle dba stadio , 以Internal/password打开服务/Instance/database/打开General/database state Open就ok了,一切照常喽!!!