My Oracle Support Banner

AIX:11.2.0.4 :ASM&DB Instance Not Starting Up Due to SMR Corrupt After OCT 2020 PSU (Doc ID 2732507.1)

Last updated on DECEMBER 02, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
IBM AIX on POWER Systems (32-bit)
IBM AIX on POWER Systems (64-bit)

Symptoms

The following errors reported in the ASM&DB alert logs while starting the ASM/DB instance after applying the OCT 2020 PSU.

ASM alert log:

Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 32

Autotune of undo retention is turned on.

IMODE=BR
ILAT =0
LICENSE_MAX_USERS = 0
SYS auditing is disabled
NOTE: Volume support enabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Automatic Storage Management option.
ORACLE_HOME = <grid home>
System name: AIX
Node name: <node>
Release: 1
Version: 7
Machine: <Machine ID>
Using parameter settings in server-side spfile +DATA01/asm/asmparameterfile/registry.253.801309187
System parameters with non-default values:
large_pool_size = 12M
instance_type = "asm"
remote_login_passwordfile= "EXCLUSIVE"
asm_diskgroups = "FRA"
asm_diskgroups = "DATA01"
asm_power_limit = 1
diagnostic_dest = "<oracle base>"
Fri Nov 06 00:59:39 2020
WARNING: process PMON (ospid: 27132378) was unable to attach SMR.
SMR is corrupted. Shut down and restart the instance to recreate it.
PMON started with pid=2, OS id=27132378
Fri Nov 06 00:59:39 2020
WARNING: process PSP0 (ospid: 20512830) was unable to attach SMR.
SMR is corrupted. Shut down and restart the instance to recreate it.

Instance terminated by USER, pid = 20512820
Fri Nov 06 00:59:39 2020
Instance shutdown complete

DB alert log:

Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 160
Number of processor cores in the system is 20
SMR is corrupted and will be recreated. All Health Check clients should disconnect and reconnect to the instance.
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as <db_home>/db/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =35
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production.
ORACLE_HOME = <db_home>
System name: AIX
Node name: <nonde_name>
Release: 1
Version: 7
Machine: <Machine ID>
Using parameter settings in server-side spfile +GRID_DG/<db_name>/spfile<db_name>.ora
System parameters with non-default values:
processes = 150
spfile = "+GRID_DG/<db_name>/spfiletest.ora"
sga_target = 9856M
control_files = "+GRID_DG/<db_name>/controlfile/current.260.1055516899"
db_block_size = 8192
compatible = "11.2.0.4.0"
db_create_file_dest = "+GRID_DG"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=testXDB)"
audit_file_dest = "<oracle base>/admin/<dbname>/adump"
audit_trail = "DB"
db_name = "test"
open_cursors = 300
pga_aggregate_target = 3276M
diagnostic_dest = "<oracle base>"
Tue Nov 03 17:06:49 2020
WARNING: process PMON (ospid: 36569094) was unable to attach SMR.
SMR is corrupted. Shut down and restart the instance to recreate it.
PMON started with pid=2, OS id=36569094

......

USER (ospid: 32899192): terminating the instance
WARNING: process USER (ospid: 32899192) was unable to attach SMR.
SMR is corrupted. Shut down and restart the instance to recreate it.
Instance terminated by USER, pid = 32899192

The output of "crsctl stat res -t" command:


--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA01.dg
ONLINE OFFLINE hfadbgw01qv
ora.FRA.dg
ONLINE OFFLINE hfadbgw01qv
ora.LISTENER.lsnr
ONLINE ONLINE hfadbgw01qv
ora.asm
ONLINE OFFLINE hfadbgw01qv Abnormal Termination,CLEANING

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.