重建orcl 服务

image.png

oradim -new -sid orcl -startmode auto -srvcstart system

image.png image.png

lsnrctl start LISTENER

image.png image.png

.

首先打开注册表，win+R运行regedit然后HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDB12Home2>ORACLE_SID设置默认数据库的SID

错误的修改

ORA-01034: ORACLE not available

select *  from v$log;

alter  database open resetlogs;

shutdown immediate

startup mount;

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file 'F:\app\wth\product\11.2.0\dbhome_1\database\initORA11G.ora'

找到 F:\app\wth\admin\orcl\pfile 下最近一个文件
复制到 F:\app\wth\product\11.2.0\dbhome_1\database\initORA11G.ora

startup 


#recover database until time '2013-03-01 12:12:12';

#alter database open resetlogs;

shutdown

startup