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

On April 15, 2019 By taliphakanozturkIn OEM & Grid Control, RACLeave a comment

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.

Creating OEM Repository and ORA-00955/ORA-01921 Errors

On January 31, 2012February 22, 2012 By taliphakanozturkIn OEM & Grid Control1 Comment

Hi Friends,

A month ago, I wrote an article about OEM configuration when the database hostname or ip address changed. You can find that in this link https://taliphakanozturken.wordpress.com/2011/12/31/oem-configuration-when-the-database-host-name-or-ip-address-changes/ .

We can get an error while re-creating (emca -config dbcontrol db -repos create) OEM repository as below:

SEVERE: Error creating the repository

Refer to the log file at /oracle/cfgtoollogs/emca/TALIPDB/emca_2012_01_20_12_07_21.log for more details.

Could not complete the configuration. Refer to the log file at /oracle/cfgtoollogs/emca/TALIPDB/emca_2012_01_20_12_07_21.log for more details.

The error is also seen in the log file of errors is analyzed you can see following lines (/oracle/cfgtoollogs/emca/TALIPDB/emca_2012_01_20_12_07_21.log).

CONFIG: ORA-00955: name is already used by an existing object
CONFIG: ORA-01921: role name ‘MGMT_USER’ conflicts with another user or role name

In this case we must do following operations in SQL*Plus.

SQL> DROP USER SYSMAN CASCADE;

SQL> DROP ROLE MGMT_USER;

SQL> DROP USER MGMT_VIEW;

SQL> spool synonym.sql

SQL> select ‘drop public synonym ‘||object_name||’;’ from dba_objects where object_type=’SYNONYM’ and and object_name like ‘MGMT_%’ and status=’INVALID’;

SQL> spool off

SQL> @synonym.sql

Now, please retry to create OEM respository. It will be success.

emca -config dbcontrol db -repos create

Talip Hakan Öztürk

OEM Configuration When the Database Host Name or IP Address Changes

On December 31, 2011February 19, 2012 By taliphakanozturkIn OEM & Grid Control, Oracle ToolsLeave a comment

The Enterprise Manager console will not work when database host name and / or IP address changes. We must run EMCA tool for reconfiguring the OEM database console. To do this, use the following commands.

emca -deconfig dbcontrol db -repos drop

emca -config dbcontrol db -repos create

emca -deconfig dbcontrol db

emca -config dbcontrol db -repos recreate

TNS konfigürasyonumuz değişir ise (Örneğin dinleyici(listener) portumuz değişirse), bu durumda yine EMCA aracı ile aşağıdaki gibi tekrar konfigürasyonumuzu yapabiliriz.

If our TNS configuration changes (for example, the listener (listener) port is changed), in this case we can still configure with the EMCA tool as follows.

emca -config dbcontrol db

Example: EMCA wants some information during repository drop and create operation. Such as SID, listener port number, SYS and SYSMAN passwords.

talip /oracle/ora11gR2> emctl stop dbconsole

http://dbtalip:1158/em/console/aboutApplication Stopping Oracle Enterprise Manager 11g Database Control … … Stopped.

talip /oracle/ora11gR2> emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Nov 29, 2011 9:16:31 AM

Enter the following information:

Database SID: TEST11GR2

Listener port number: 1521

Password for SYS user:

Password for SYSMAN user:

———————————————————————- WARNING : While repository is dropped the database will be put in quiesce mode. ———————————————————————-

Do you wish to continue? [yes(Y)/no(N)]: y

Nov 29, 2011 9:16:53 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at

/oracle/cfgtoollogs/emca/TEST11GR2/emca_2011_11_29_09_16_30.log.

Nov 29, 2011 9:16:53 AM oracle.sysman.emcp.util.DBControlUtil stopOMS

INFO: Stopping Database Control (this may take a while) …

Nov 29, 2011 9:16:55 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Dropping the EM repository (this may take a while) …

Nov 29, 2011 9:19:15 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully dropped Enterprise Manager configuration completed successfully FINISHED EMCA at Nov 29, 2011 9:19:18 AM

talip /oracle/ora11gR2> emca -config dbcontrol db -repos create

STARTED EMCA at Nov 29, 2011 9:19:25 AM

Enter the following information:

Database SID: TEST11GR2

Listener port number: 1521

Listener ORACLE_HOME [ /oracle/ora11gR2 ]:

Password for SYS user:

Password for DBSNMP user:

Password for SYSMAN user:

Email address for notifications (optional):

Outgoing Mail (SMTP) server for notifications (optional):

—————————————————————–

You have specified the following settings

Database ORACLE_HOME ……………. /oracle/ora11gR2

Local hostname ……………. dbtalip

Listener ORACLE_HOME ……………. /oracle/ora11gR2

Listener port number ……………. 1521

Database SID ……………. TEST11GR2

Email address for notifications ……………

Outgoing Mail (SMTP) server for notifications ……………

—————————————————————–

Do you wish to continue? [yes(Y)/no(N)]: y

Nov 29, 2011 9:19:46 AM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at

/oracle/cfgtoollogs/emca/TEST11GR2/emca_2011_11_29_09_19_24.log.

Nov 29, 2011 9:19:47 AM oracle.sysman.emcp.EMReposConfig createRepository

INFO: Creating the EM repository (this may take a while) …

Nov 29, 2011 9:26:16 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully created

Nov 29, 2011 9:26:22 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository

INFO: Uploading configuration data to EM repository (this may take a while) …

Nov 29, 2011 9:27:19 AM oracle.sysman.emcp.EMReposConfig invoke

INFO: Uploaded configuration data successfully

Nov 29, 2011 9:27:21 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Securing Database Control (this may take a while) …

Nov 29, 2011 9:27:31 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Database Control secured successfully.

Nov 29, 2011 9:27:31 AM oracle.sysman.emcp.util.DBControlUtil startOMS

INFO: Starting Database Control (this may take a while) …

Nov 29, 2011 9:28:09 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully

Nov 29, 2011 9:28:09 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: >>>>>>>>>>> The Database Control URL is https://dbtalip:1158/em <<<<<<<<<<<

Nov 29, 2011 9:28:13 AM oracle.sysman.emcp.EMDBPostConfig invoke

WARNING:

************************ WARNING ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in th file:

/oracle/ora11gR2/dbtalip_TEST11GR2/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will becom unusable if this file is lost.

***********************************************************

Enterprise Manager configuration completed successfully

FINISHED EMCA at Nov 29, 2011 9:28:13 AM

talip /oracle/ora11gR2> emctl status dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0

Oracle Enterprise Manager 11g is running. ——————————————————————

Logs are generated in directory /oracle/ora11gR2/dbtalip_TEST11GR2/sysman/log talip /oracle/ora11gR2>

Now, OEM is available.

Talip Hakan Öztürk