ORA-15244: new compatibility setting less than current [string]
Cause: The compatibility setting was invalid. The compatibility setting can only be advanced.
Action: Check the version number.
ORA-15244 用于指出当在更新RDBMS兼容性设置时,可能就某个版本低于当前版本。下面是错误消息:
ORA-15244: new compatibility setting less than current string
当您尝试设置当前兼容性为低于当前值时,数据库将报错ORA-15244。当不小心把兼容性由高版本降低到低版本时,也会发生这种情况。
为了避免ORA-15244错误,您必须保证您尝试将兼容性设置为不低于当前值,以及当你执行相应的alter命令时,要记住正确的参数值。
您可以使用以下步骤来解决该问题:
(1)查看当前兼容性设置:
SELECT * FROM V$OPTION;
(2)查看支持的兼容性设置:
show parameter compatible
(3)根据上面显示的参数值来调节兼容性设置:
ALTER SYSTEM SET COMPATIBLE =’xxx.x.x.x.x’ SCOPE = SPFILE;
(4)重新启动数据库:
shutdown immediate;
startup;