ORA-00201 是Oracle 数据库中的一个常见错误代码,表示控制文件版本与 Oracle 数据库版本不兼容。以下是对该错误代码的具体描述、可能的原因、解决方法及预防建议: 1. ORA-00201 错误描述 错误代码:ORA-00201 错误描述:控制文件版本字符串与 Oracle 版本字符串不兼容。这通常意味着控制文件中存储的版本信息与当前 Ora...
ORA- 00201: control file version 11.2.0.4.0 incompatible with ORACLE version11.2.0.0.0 ORA- 00202: control file: ' /home/oracle/oradata/easdb/control01.ctl' 2、解决方案 检查pfile参数文件compatible 参数为11.2.0,需更改为11.2.0.4.0,与控制文件匹配。 上一篇:Oracle表空间对应数据文件位置不规范迁...
ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE version 11.2.0.0.0 ORA-00202: control file: '/home/oracle/app/oracle/oradata/control01.ctl' 异常原因: 修改pfile文件时,少粘贴了*.compatible='11.2.0.4.0'参数.
ORA-00201:controlfileversion11.2.0.4.0incompatiblewithORACLE version11.2.0.0.0ORA-00202:controlfile:'/oradata/gabsjsb/control01.ctl' 产生原因: 11.2.0.4数据库参数文件中如果不写明compatible参数,则默认为11.2.0.0.0,主要是手动创建pfile才会发生,正常创建的数据库基本不需要考虑这种问题 参数文件如下: *.aud...
ORA-00201: controlfile version 10.1.0.2.0 incompatible with ORACLE version 10.0.0.0.0 ORA-00202: controlfile: '/opt/app/oracle/oradata/orcl/control01.ctl' SQL> show parameter com NAME TYPE VALUE --- --- --- commit_point_strength integer 1 compatible string 10.0.0 max_commit_propagation...
ORA-00201: controlfile version 10.1.0.2.0 incompatible with ORACLE version 10.0.0.0.0 ORA-00202: controlfile: '/opt/app/oracle/oradata/orcl/control01.ctl' SQL> show parameter com NAME TYPE VALUE --- --- --- commit_point_strength integer 1 compatible string 10.0.0 max_commit_propagation...
ORA-00201: controlfile version 10.1.0.2.0 incompatible with ORACLE version 10.0.0.0.0 ORA-00202: controlfile: '/opt/app/oracle/oradata/orcl/control01.ctl' SQL> show parameter com NAME TYPE VALUE --- --- --- commit_point_strength integer 1 compatible string 10.0.0 max_commit_propagation...
ORA-00201: controlfile version 8.0.0.0.0 incompatible with ORACLE version 9.2.0.0.0 rahulrdeo Explorer on 2015 Nov 06 0 Kudos 175 SAP Managed Tags: Oracle Database Hi All We are facing a weird situation. We took a full offline backup of one of our staging servers with ...
今天从其它机器rman 备份还原到别外一台机器上,restore controlfiel ,DB mount时报ORA-00201: control file version 10.2.0.3.0 incompatible with ORACLE version 10.2.0.1.0 环境备份机10.2.0.4 还原机10.2.0.4 [oracle@aix dbs]$ ora SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jun 10 16:08:46...
原因在于,备库spfile使用的是我自己手动编写生成的,非系统生成,其中的参数compatible 系统跑回去使用init.ora中配置的。 所以造成了:ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE version 11.2.0.0.0 备库中init是:compatible ='11.2.0' ...