Creating the 11.2 OEM (with Oracle Flex) with emca Fails with Message: WARNING: Error determining the nodes associated with cluster database for ASM

Hi,

When I try to create Oracle Enterprise Manager with EMCA for 11.2.0.3 database running on 18c Grid Infrastructure, it fails with following error mesaage

Database Control (DBC) 11.2 web site creation with emca fails for Oracle Flex with this error message:

WARNING: Error determining the nodes associated with cluster database for ASM
Apr 9, 2019 11:28:18 PM oracle.sysman.emcp.ParamsManager queryDBForASMNodeList
CONFIG: Stack trace:
PRCA-1018 : Failed to retrieve ASM instance list for ASM asm
PRCR-1115 : Failed to find entities of type resource instance that match filters ((TYPE == ora.asm.type) && (NAME == ora.asm)) and contain attributes LAST_SERVER,USR_ORA_INST_NAME
CRS-2653: Special value evaluation must be associated with a resource instance
at oracle.cluster.impl.asm.ASMImpl.getInstances(ASMImpl.java:787)
at oracle.cluster.impl.asm.ASMImpl.allInstances(ASMImpl.java:702)
at oracle.sysman.emcp.ParamsManager.queryDBForASMNodeList(ParamsManager.java:1899)
at oracle.sysman.emcp.ParamsManager.getASMNodeList(ParamsManager.java:1673)
at oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:3483)
at oracle.sysman.emcp.EMConfigAssistant.promptForData(EMConfigAssistant.java:710)
at oracle.sysman.emcp.EMConfigAssistant.promptForParams(EMConfigAssistant.java:3028)
at oracle.sysman.emcp.EMConfigAssistant.displayWarnsAndPromptParams(EMConfigAssistant.java:3065)
at oracle.sysman.emcp.EMConfigAssistant.getDisplayAndPromptWarnsParms(EMConfigAssistant.java:3090)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1116)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:583)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:529)
Caused by: PRCR-1115 : Failed to find entities of type resource instance that match filters ((TYPE == ora.asm.type) && (NAME == ora.asm)) and contain attributes LAST_SERVER,USR_ORA_INST_NAME
CRS-2653: Special value evaluation must be associated with a resource instance
at oracle.cluster.impl.crs.CRSNative.searchEntities(CRSNative.java:1016)
at oracle.cluster.impl.crs.CRSFactoryImpl.searchEntities(CRSFactoryImpl.java:637)
at oracle.cluster.impl.asm.ASMImpl.getInstances(ASMImpl.java:768)
... 11 more
Caused by: CRS-2653: Special value evaluation must be associated with a resource instance
at oracle.cluster.impl.crs.CRSNativeResult.addComp(CRSNativeResult.java:171)
at oracle.cluster.impl.crs.CRSNative.doQueryEntities(Native Method)
at oracle.cluster.impl.crs.CRSNative.searchEntities(CRSNative.java:1006)
... 13 more
Apr 9, 2019 11:28:18 PM oracle.sysman.emcp.ParamsManager getInaccessibleSidList
CONFIG: Invalid Node/Sid List specified.

This is due to bug number 20416112.

In the Oracle Flex ASM configuration not all ASM instances are required to be Up or even to have been yet started. In such a case, the DBC web site configuration process can fail.

Querying the ASM instances for activity shows the following, namely one OFFLINE ASM instance.

orcnode1 /home/oracle> crsctl stat res ora.asm -t 
--------------------------------------------------------------------------
Name Target State Server State details 
--------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------
ora.asm
1 ONLINE ONLINE orcnode1 Started,STABLE
2 ONLINE ONLINE orcnode2 Started,STABLE
3 OFFLINE OFFLINE STABLE
--------------------------------------------------------------------------

Please also check clsuter mode.

orcnode1 /home/oracle> asmcmd showclustermode
ASM cluster : Flex mode enabled – Direct Storage Access
orcnode1 /home/oracle> srvctl config asm
ASM home: <CRS home>
Password file: +DATA/orapwASM
Backup of Password file:
ASM listener: LISTENER_REP
ASM instance count: 3
Cluster ASM listener: ASMNET1LSNR_ASM,ASMNET2LSNR_ASM

For workaround, please issue this command with grid os user.
orcnode1 /home/oracle> srvctl modify asm -count ALL

And again check status.

orcnode1 /home/oracle> srvctl config asm
ASM home: <CRS home>
Password file: +DATA/orapwASM
Backup of Password file:
ASM listener: LISTENER_REP
ASM instance count: ALL
Cluster ASM listener: ASMNET1LSNR_ASM,ASMNET2LSNR_ASM

orcnode1 /home/oracle> crsctl stat res ora.asm -t
--------------------------------------------------------------------------
Name Target State Server State details 
--------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------
ora.asm
1 ONLINE ONLINE orcnode1 Started,STABLE
2 ONLINE ONLINE orcnode2 Started,STABLE
--------------------------------------------------------------------------
orcnode1 /home/oracle>

This action will decrease the number of ASM instances expected by emca to the number of ONLINE instances returned by  the “crsctl stat res ora.asm -t” command and allow the configuration to continue.

Now, you can retry to run EMCA with cluster parameter.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s