Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Oracle Cluster Node creates all ASM instance

Ashokan Nagabu1
Tera Expert

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

Ashokan Nagabu1
Tera Expert

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.