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.
Talip Hakan Ozturk's ORACLE BLOG 