ORACLE win 操作系统重装处理

数据盘没动
将E:\app 重命名为E:\app1
将原有的数据库重新安装一遍 目录与之前一致重建实例与之前名字一致
stop数据库 和监听
将 E:\app1\qtong\oradata\orcl  整个目录
将E:\app1\qtong\fast_recovery_area\orcl\下的CTL替换到新目录下
将E:\app1\qtong\product\11.2.0\dbhome_1\network\admin\listener.ora 替换到新目录下
startup DB和监听即可

问题记录：
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\app\qtong\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app\qtong\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)

以下五行为新增

   (SID_DESC =
   (GLOBAL_DBNAME = orcl)
   (ORACLE_HOME = E:\app\qtong\product\11.2.0\dbhome_1)   
   (SID_NAME = orcl)

)
)

转载于:https://www.cnblogs.com/qtong/p/10329772.html