存储架构

Creating the 11.2 OEM (with Oracle Flex) with emca Fails with Message: WARNING: Error deter…

微信扫一扫,分享到朋友圈

Creating the 11.2 OEM (with Oracle Flex) with emca Fails with Message: WARNING: Error deter…
0

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
<strong>3 OFFLINE OFFLINE STABLE</strong>
--------------------------------------------------------------------------

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.

Advertisements

阅读原文...

微信扫一扫,分享到朋友圈

Creating the 11.2 OEM (with Oracle Flex) with emca Fails with Message: WARNING: Error deter…
0
Avatar

AMD Poised for Explosive CPU and GPU Sales Growth in 2019

上一篇

10分钟快速入门Redis

下一篇

评论已经被关闭。

插入图片

热门分类

往期推荐

Creating the 11.2 OEM (with Oracle Flex) with emca Fails with Message: WARNING: Error deter…

长按储存图像,分享给朋友