Oracle DB names via SNMP | LM Exchange

Michael Baker · 2021-08-05T01:52:55Z

Given the existing modules use SSH/WMI to discover the DB names we required a way without the need to SSH into a server we have published a Property Source 4TK9LN that utilises SNMP to pull the DB names and then populate auto.oracle_dbs, you will either need to update / fork existing Oracle datasources or move this to a DS and set the oracle_dbnames there. Also attached inline. any improvements welcome! { "scheduleOption": 0, "dataType": 0, "description": "List all Oracle databases with SNMP", "appliesTo": "hasCategory(\"OracleDB\")", "technology": "", "type": "propertyrule", "params": [ { "name": "linuxcmdline", "comment": "", "value": "" }, { "name": "linuxscript", "comment": "", "value": "" }, { "name": "scriptgroovy", "comment": "", "value": "// Locate Oracle database names via SNMP, tested on Linux\nimport com.santaba.agent.groovyapi.snmp.Snmp\n\ndef snmp_timeout = 15000\n\ndef g_hostname = hostProps.get(\"system.hostname\")\ndef g_community = hostProps.get(\"snmp.community\")\ndef g_version = hostProps.get(\"snmp.version\")\ndef g_security_name = hostProps.get(\"snmp.security\")\ndef g_auth_proto = hostProps.get(\"snmp.auth\")\ndef g_auth_token = hostProps.get(\"snmp.authtoken\")\ndef g_priv_proto = hostProps.get(\"snmp.priv\")\ndef g_priv_token = hostProps.get(\"snmp.privtoken\")\n\ndef snmp = new lm_snmp( g_hostname, g_community, g_version, g_security_name, g_auth_proto, g_auth_token, g_priv_proto, g_priv_token, snmp_timeout)\n// List all running processes\noutput = snmp.snmpwalk(\"1.3.6.1.2.1.25.4.2.1.4\")\ndef databases = [:]\ndef dblist = []\noutput.eachLine { entry ->\n process = entry.split(\"=\")\n // Find the Oracle process names\n def proc_name = process[1] =~ /oracle(?!PRD)(\\w+)/\n if(proc_name) {\n // Dump it in a Map to keep it unique\n databases[proc_name[0][1]] = 1\n }\n}\n// Loop the Map and pump them back into an array\ndatabases.each{entry -> dblist << entry.key}\ndb_names = dblist.join(\",\")\nprint \"auto.oracle_dbs=${db_names}\"\n\n// Core classes\nclass lm_snmp\n{\n\n String community\n String version // v1, v2c, v3\n String security_name\n String auth_proto // MD5\n String auth_token\n String priv_token\n String priv_proto // DES\n Integer timeout = 30000\n\n Map v3_map = [:]\n\n String hostname\n\n lm_snmp( String hostname, String community, String version = \"v3\", String security_name = null, String auth_proto = null, String auth_token=null, String priv_proto=null, String priv_token=null, Integer timeout = 30000 ) {\n\n this.hostname = hostname\n this.community = community\n this.version = version\n this.timeout = timeout\n\n if ( this.version == \"v3\" )\n {\n this.security_name = security_name\n if ( auth_proto == null ) { this.auth_proto = \"SHA\" } else { this.auth_proto = auth_proto }\n this.auth_token = auth_token\n\n if ( priv_proto == null ) { this.priv_proto = \"AES\" } else { this.priv_proto = priv_proto }\n this.priv_token = priv_token\n\n v3_map[\"snmp.version\"] = \"v3\"\n v3_map[\"snmp.security_name\"] = this.security_name\n v3_map[\"snmp.auth_proto\"] = this.auth_proto\n v3_map[\"snmp.auth_token\"] = this.auth_token\n v3_map[\"snmp.priv_proto\"] = this.priv_proto\n v3_map[\"snmp.priv_token\"] = this.priv_token\n }\n }\n\n def snmpget ( String oid )\n {\n\n println \"Trying: ${oid}\"\n\n if ( this.version == \"v3\" )\n {\n //return Snmp.getV3(this.hostname, this.security_name, this.auth_proto, this.auth_token, this.priv_proto, this.priv_token,oid, this.timeout)\n return Snmp.get(this.hostname, oid, v3_map )\n }\n else\n {\n return Snmp.get(this.hostname, this.community, this.version, oid, this.timeout)\n }\n\n }\n\n def snmpwalk ( String oid )\n {\n\n println \"debug: ${this.hostname}, ${this.security_name}, ${this.auth_proto}, ${this.auth_token}, ${this.priv_proto}, ${this.priv_token}, ${oid}, ${this.timeout.toString()}\"\n\n if ( this.version == \"v3\" )\n {\n //return Snmp.walkV3(this.hostname, this.security_name, this.auth_proto, this.auth_token, this.priv_proto, this.priv_token, oid, this.timeout)\n return Snmp.walk( this.hostname, oid, v3_map)\n }\n else\n {\n return Snmp.walk(this.hostname, this.community, this.version, oid, this.timeout)\n }\n }\n}" }, { "name": "scripttype", "comment": "embed", "value": "embed" }, { "name": "windowscmdline", "comment": "", "value": "" }, { "name": "windowsscript", "comment": "", "value": "" } ], "version": 1628127167, "tags": "", "auditVersion": 0, "name": "List_Oracle_Databases_SNMP", "id": 153, "group": "Oracle" }

MoreDiscussions

Oracle DB names via SNMP | LM Exchange | LogicMonitor Community