重建orcl 服务
2021-10-11 本文已影响0人
王滕辉
image.png
oradim -new -sid orcl -startmode auto -srvcstart system
image.png image.pnglsnrctl 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