Oracle Cluster Node creates all ASM instance
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2024 11:10 AM
Hi,
We have a 2 node Oracle DB cluster. When we run discovery for one node, it also fetches other nodes ASM instance and populates cmdb.
Executing SSH command: export TNS_ADMIN=/u01/app/19.3/grid/network/admin;export ORACLE_BASE=/u01/app/19.3/grid;export ORACLE_HOME=/u01/app/19.3/grid;/u01/app/19.3/grid/bin/lsnrctl status ASMXX_ASM
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM))) STATUS of the LISTENER ------------------------ Alias ASMXX_ASM Version TNSLSNR for Linux: Version XX.0.0.0.0 Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19.3/grid/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/SERVER/asmXX_asm/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=ASMXXX_ASM))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX)(PORT=XX))) Services Summary... Service "+ASM" has 2 instance(s). Instance "+ASM1", status READY, has 2 handler(s) for this service... Instance "+ASM2", status READY, has 1 handler(s) for this service...
====================================================================================
Does anyone faced this error? please suggest, expectation is only one entry should be created in cmdb like ASM1@node1
Regards,
Ashokan
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-04-2024 12:47 PM
We have found the issue and fixed it. There is a step to fetch the process running with ASM keyword which has been modified with respect to our environment.