ORA-15244: new compatibility setting less than current [string]

文档解释

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;

你可能感兴趣的