SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE    11.2.0.4.0      Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 – Production

SQL> show parameter compati

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

compatible                           string      10.2.0.5.0

plsql_v2_compatibility               boolean     FALSE

SQL>

About The COMPATIBLE Initialization Parameter

The COMPATIBLE initialization parameter enables or disables the use of features in the database that affect file format on disk. For example, if you create an Oracle Database 11g Release 2 (11.2) database, but specify COMPATIBLE=10.0.0 in the initialization parameter file, then features that require 11.2 compatibility generate an error if you try to use them. Such a database is said to be at the 10.0.0 compatibility level.

You can advance the compatibility level of your database by changing the COMPATIBLE initialization parameter. If you do, there is no way to start the database using a lower compatibility level setting, except by doing a point-in-time recovery to a time before the compatibility was advanced.

The default value for the COMPATIBLE parameter is the release number of the most recent major release.

Oracle9i Release 2 (9.2)

8.1.0

8.1.0.0.0

9.2.0.n.n

Oracle Database 10g Release 1 (10.1)

10.0.0

9.2.0.0.0

10.1.0.n.n

Oracle Database 10g Release 2 (10.2)

10.2.0

9.2.0.0.0

10.2.0.n.n

Oracle Database 11g Release 1 (11.1)

11.0.0

10.0.0.0.0

11.1.0.n.n

Oracle Database 11g Release 2 (11.2)

11.2.0

10.0.0.0.0

11.2.0.n.n

SQL> alter system set compatible='11.2.0.4.0' scope=spfile;

System altered.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1068937216 bytes

Fixed Size                  2260088 bytes

Variable Size             335545224 bytes

Database Buffers          725614592 bytes

Redo Buffers                5517312 bytes

Database mounted.

Database opened.

SQL> show parameter compatible

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

compatible                           string      11.2.0.4.0

SQL>

SQL> select name,compatibility,database_compatibility from  v$asm_diskgroup;

NAME            COMPATIBILITY DATABASE_COMPATIBILI

--------------- ------------- --------------------

DATA             10.2.0.5.0    10.2.0.5.0

SQL> alter diskgroup DATA  set attribute 'compatible.asm'='11.2.0.4.0';

Diskgroup altered.

SQL> alter diskgroup DATA set attribute 'compatible.rdbms'='11.2.0.4.0';

Diskgroup altered.

SQL> select name,compatibility,database_compatibility from v$asm_diskgroup;

NAME            COMPATIBILITY DATABASE_COMPATIBILI

--------------- ------------- --------------------

DATA             11.2.0.4.0    11.2.0.4.0