Forum Discussion

casteeb's avatar
casteeb
Icon for Neophyte rankNeophyte
8 months ago

Remote DB connections via Oracle SQLnet

While Logic Monitor seems determined that it needs to "connect" to a remote host to gather data, in the case of Oracle DB up / down testing it's much easier to just perform a remote connection via SQ...
casteeb's avatar
casteeb
Icon for Neophyte rankNeophyte
8 months ago

Oddly in this case I want to manually add/remove the DB names in a list on each server, so maintaining 1 list on each server should work for us. The auto discovery for Oracle  RAC and PDBs in LM is sort of the reason we got here. lol

That's not really a problem for use because adding / removing a database requires about 25 Tasks to different functional areas in the data center.

  • Anonymous's avatar
    Anonymous
    8 months ago

    Then in that case, I'd go with this discovery script:

    hostProps.get("oracle_rac_dbs").tokenize(",").each{
    (wildvalue,wildalias) = it.tokenize("|")
    println("${wildvalue}##${wildalias}")
}
return 0

    And put the list on each server with the oracle_rac_dbs property. Comma separate each db/display name pair and separate the db name from the display name with a pipe character.

    That takes care of your discovery. Does your collection script test one DB at a time or all DBs on a server?