How to change ASM "compatible.asm" parameters after upgrade the Grid Infrastructue from 11.2.0.3.0 to 12.1.0.2.0.

1) Check the parameter value

ASMCMD> lsattr -l -G DATA

ASMCMD> lsattr -l -G RECO


2) change the parameter by using below command.

SQL> ALTER DISKGROUP DATA SET ATTRIBUTE 'compatible.asm' = '12.1.0.2.0';

SQL> ALTER DISKGROUP RECO SET ATTRIBUTE 'compatible.asm' = '12.1.0.2.0';

Comments

Post a Comment

Popular posts from this blog

Fatal agent error: Target Interaction Manager failed at Startup

Symptoms ========  $ /AGENT_INST/bin/emctl start agent Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved. Starting agent ......................................................................... failed. Fatal agent error: Target Interaction Manager failed at Startup Fatal agent error: Target Interaction Manager failed at Startup Fatal agent error: Target Interaction Manager failed at Startup EMAgent is Thrashing. Exiting watchdog $/AGENT_INST/sysman/log/emagent.nohup reports following error 2013-11-01 17:29:38,596 [1:main] WARN - Missing filename for log handler 'opsscfg' Agent is going down due to an OutOfMemoryError $/AGENT_INST/sysman/log/gcagent.log reports following error 2013-11-01 17:29:19,204 [1:3305B9] INFO - Invoking STARTUP_P1 (1) on Target Interaction Manager 2013-11-01 17:29:23,255 [1:main] FATAL - Fatal error: Target Interaction Manager failed at Startup java.lang.OutOfMemoryError: Java heap sp
Read more

[INS-40718] Single Client Access Name (SCAN): could not be resolved. ( LDOMS & Zones)

Cause The name you provided as the SCAN could not be resolved using TCP/IP host name lookup. Action-Provide name to use for the SCAN for which the domain can be resolved Global Zone : ============= # svccfg svc:> select name-service/switch svc:/system/name-service/switch> setprop config/host = astring: "files dns" svc:/system/name-service/switch> select system/name-service/switch:default svc:/system/name-service/switch:default> refresh svc:/system/name-service/switch:default> validate svc:/system/name-service/switch:default> exit # svcadm refresh name-service/switch # svcadm restart /system/name-service-cache; then, I can resolve host using telnet/ping.
Read more

CRS-2883: Resource 'ora.asm' failed during Clusterware stack start

Symptoms ======== root@oraprod02:~# /u01/app/12.1.0.2/grid/crs/install/rootcrs.pl -postpatch Using configuration parameter file: /u01/app/12.1.0.2/grid/crs/install/crsconfig_params 2017/11/05 15:57:38 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector. 2017/11/05 15:58:08 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector. 2017/11/05 15:58:13 CLSRSC-329: Replacing Clusterware entries in file '/etc/inittab' CRS-4123: Oracle High Availability Services has been started. CRS-4133: Oracle High Availability Services has been stopped. CRS-4123: Starting Oracle High Availability Services-managed resources CRS-2672: Attempting to start 'ora.evmd' on 'oraprod02' CRS-2672: Attempting to start 'ora.mdnsd' on 'oraprod02' CRS-2676: Start of 'ora.mdnsd' on 'oraprod02' succeeded CRS-2676: Start of 'ora.evmd' on 'oraprod02' succeeded CRS-2672: Attempting to st
Read more