Cause:
ASM instance not came up on node1 after node reboot, when I tried to start asm instance manually got below error
[grid@racnode01 ~]$ sqlplus "/as sysasm"
SQL*Plus: Release 18.0.0.0.0 - Production on Thu Jul 23 06:33:14 2020
Version 18.3.2.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORA-39511: Start of CRS resource for instance '223' failed with error:[CRS-2549: Resource 'ora.asm' cannot be placed on 'racnode01' as it is not a valid candidate as per the placement policy
CRS-0223: Resource 'ora.asm' has placement error.
clsr_start_resource:260 status:223
clsrapi_start_asm:start_asmdbs status:223
Check resource details:
[grid@racnode01 ~]$ crsctl stat server -f
NAME=racnode01
MEMORY_SIZE=128462
CPU_COUNT=8
CPU_CLOCK_RATE=2053
CPU_HYPERTHREADING=1
CPU_EQUIVALENCY=1000
DEPLOYMENT=other
CONFIGURED_CSS_ROLE=hub
RESOURCE_USE_ENABLED=0. --- Issue
SERVER_LABEL=
PHYSICAL_HOSTNAME=
CSS_CRITICAL=no
CSS_CRITICAL_TOTAL=0
RESOURCE_TOTAL=0
SITE_NAME=poc19c-cluster
STATE=ONLINE
ACTIVE_POOLS=Free
STATE_DETAILS=
ACTIVE_CSS_ROLE=hub
NAME=racnode02
MEMORY_SIZE=128462
CPU_COUNT=8
CPU_CLOCK_RATE=2684
CPU_HYPERTHREADING=1
CPU_EQUIVALENCY=1000
DEPLOYMENT=other
CONFIGURED_CSS_ROLE=hub
RESOURCE_USE_ENABLED=1
SERVER_LABEL=
PHYSICAL_HOSTNAME=
CSS_CRITICAL=no
CSS_CRITICAL_TOTAL=0
RESOURCE_TOTAL=0
SITE_NAME=poc19c-cluster
STATE=ONLINE
ACTIVE_POOLS=Generic ora.poc19c
STATE_DETAILS=
ACTIVE_CSS_ROLE=hub
RESOURCE_USE_ENABLED:
The possible values are 1 or 0. If you set the value for this attribute to 1, which is the default, then the server can be used for resource placement.
If you set the value to 0, then Oracle Clusterware disallows starting server pool resources on the server. The server remains in the Free server pool.
Set RESOURCE_USE_ENABLED value to 1
root@racnode01:# ./crsctl set resource use 1
CRS-4416: Server attribute 'RESOURCE_USE_ENABLED' successfully changed. Restart Oracle High Availability Services for new value to take effect.
root@racnode01:#
restart Cluster
root@racnode01:# ./crsctl stop crs
root@racnode01:# ./crsctl start crs
Check ASM Status and Resource details
[grid@racnode01 ~]$ sql
SQL*Plus: Release 18.0.0.0.0 - Production on Fri Jul 24 09:10:17 2020
Version 18.3.2.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.2.0.0
SQL> select INSTANCE_NAME,host_name,status,logins, to_char(STARTUP_TIME,'DD/MM/YYYY HH24:MI:SS') "STARTUPSP2-0734: _TIME" from gv$instance;unknown command beginning "==========..." - rest of line ignored.
INSTANCE_NAME HOST_NAME STATUS LOGINS STARTUP_TIME
---------------- ------------ ------------ ---------- -------------------
+ASM1 racnode01.com STARTED ALLOWED 24/07/2020 09:05:32
+ASM2 racnode02.com STARTED ALLOWED 23/07/2020 06:14:17
[grid@racnode02 ~]$ crsctl stat server -f
NAME=racnode01
MEMORY_SIZE=128462
CPU_COUNT=8
CPU_CLOCK_RATE=2334
CPU_HYPERTHREADING=1
CPU_EQUIVALENCY=1000
DEPLOYMENT=other
CONFIGURED_CSS_ROLE=hub
RESOURCE_USE_ENABLED=1
SERVER_LABEL=
PHYSICAL_HOSTNAME=
CSS_CRITICAL=no
CSS_CRITICAL_TOTAL=0
RESOURCE_TOTAL=0
SITE_NAME=poc19c-cluster
STATE=ONLINE
ACTIVE_POOLS=Generic ora.poc19c
STATE_DETAILS=
ACTIVE_CSS_ROLE=hub
NAME=racnode02
MEMORY_SIZE=128462
CPU_COUNT=8
CPU_CLOCK_RATE=2684
CPU_HYPERTHREADING=1
CPU_EQUIVALENCY=1000
DEPLOYMENT=other
CONFIGURED_CSS_ROLE=hub
RESOURCE_USE_ENABLED=1
SERVER_LABEL=
PHYSICAL_HOSTNAME=
CSS_CRITICAL=no
CSS_CRITICAL_TOTAL=0
RESOURCE_TOTAL=0
SITE_NAME=poc19c-cluster
STATE=ONLINE
ACTIVE_POOLS=Generic ora.poc19c
STATE_DETAILS=
ACTIVE_CSS_ROLE=hub
ASM instance started without any issues after adjusting RESOURCE_USE_ENABLED=1
No comments:
Post a Comment