查看数据库和asm版本
[oracle@rac02 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jul 27 16:35:30 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL>
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jul 27 16:35:30 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL>
SQL> select GROUP_NUMBER,NAME,TYPE,COMPATIBILITY,DATABASE_COMPATIBILITY from v$asm_diskgroup;
GROUP_NUMBER NAME TYPE
------------ ------------------------------ ------
COMPATIBILITY
------------------------------------------------------------
DATABASE_COMPATIBILITY
------------------------------------------------------------
1 DATA EXTERN
11.2.0.0.0
10.1.0.0.0
GROUP_NUMBER NAME TYPE
------------ ------------------------------ ------
COMPATIBILITY
------------------------------------------------------------
DATABASE_COMPATIBILITY
------------------------------------------------------------
1 DATA EXTERN
11.2.0.0.0
10.1.0.0.0
解决办法：满足asm磁盘组属性
SQL> alter diskgroup data set attribute 'compatible.asm'='11.2.0.4';
Diskgroup altered.
SQL> alter diskgroup DATA set attribute'compatible.rdbms'='11.2.0.4.0';
Diskgroup altered.
| 欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |