Upgrade Grid Infrastructure 11.2.0.4 to 12c PSU 12.1.0.2.160719

1.       Bring down the database instance not the ASM instance.

2.       Create backup of spfile of ASM.

3.       Launch runInstaller

 

 

 

 

Got an issue regarding one of the Kernel Parameter (kernel.panic_on_oops).

Solution – Fix and check again.

 

Before executing rootupgrade.sh –

a)       Patch OPatch with p6880880_121010_Linux-x86-64.zip

b)      Install patch 23273629 to the 12c grid home. GRID Infra PSU 12.1.0.2.160719

Open new Putty Terminal

export ORACLE_HOME=/grid/gi/12.1.0

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

cd $ORACLE_HOME/OPatch

opatch apply -oh /grid/gi/12.1.0 -local /shared/23273629/21436941

opatch apply -oh /grid/gi/12.1.0 -local /shared/23273629/23054246

opatch apply -oh /grid/gi/12.1.0 -local /shared/23273629/23054327

opatch apply -oh /grid/gi/12.1.0 -local /shared/23273629/23054341

Once Patching done. Please crosscheck status of ASM instance, if HAS is down bring it UP.

$ sudo /grid/gi/12.1.0/rootupgrade.sh

Hit Next.

Upgrade done successfully. Switch to new terminal, change bash_profile to 12c grid home.

[grid@indelvtdinfdb28 admin]$ crsctl query has softwareversion

Oracle High Availability Services version on the local node is [12.1.0.2.0]

Provide the command.

srvctl config asm

[grid@indelvtdinfdb28 dbs]$ srvctl config asm

ASM home: <CRS home>

PRCA-1057 : Failed to retrieve the password file location used by ASM asm

PRCR-1097 : Resource attribute not found: PWFILE

CAUSE

From 12.1 onwards ASM instance has an attribute called PWFILE(password file). Password file for ASM is not available in 11.2.

This issue is unpublished bug 19449701.  DOC ID 1935891.1

Solution.

[grid@indelvtdinfdb28 dbs]$ crsctl stop resource -all

[grid@indelvtdinfdb28 dbs]$ srvctl remove asm -force 

[grid@indelvtdinfdb28 dbs]$ srvctl add asm -spfile +ORCL_DATA/asm/asmparameterfile/registry.253.917720447 -pwfile $ORACLE_HOME/dbs/orapw+ASM -diskstring '/dev/oracle/*'

[grid@indelvtdinfdb28 dbs]$ srvctl add listener -l listener_ASM -o $ORACLE_HOME -p 26101

[grid@indelvtdinfdb28 dbs]$ srvctl start listener -l listener_ASM

[grid@indelvtdinfdb28 dbs]$ srvctl config asm

ASM home: <CRS home>

Password file: /grid/gi/12.1.0/dbs/orapw+ASM

ASM listener: LISTENER_ASM

Spfile: +ORCL_DATA/asm/asmparameterfile/registry.253.917720447

ASM diskgroup discovery string: /dev/oracle/*

[grid@indelvtdinfdb28 dbs]$ srvctl start asm

[grid@indelvtdinfdb28 dbs]$ crsctl stop has

[grid@indelvtdinfdb28 dbs]$ crsctl start has

[grid@indelvtdinfdb28 dbs]$ crsctl start <diskgroup> -unsupported