def discoverOracle(sqlAgent, ip, oracleOSH):
dbRelationRes = doQuery(sqlAgent, dbRelation, ip)
parseDbRelation(dbRelationRes)
def doQuery(sqlAgent, query, ip):
tableRes = None
try:
tableRes = sqlAgent.doTableCommand( query )
except:
stacktrace = traceback.format_exception(sys.exc_info()[0], sys.exc_info()[1], sys.exc_info()[2])
if mam_utils.isDebugEnabled():
mam_utils.debug('Failed activating query: ' , query , '\non destination: ' , ip , '\nException:')
mam_utils.debug(stacktrace)
if mam_utils.isDebugEnabled():
if tableRes:
rows = tableRes.getRowCount()
cols = tableRes.getColumnCount()
mam_utils.debug('Found ', rows, ' rows, ', cols, ' columns.')
return tableRes
# 4 ##############################
try:
sqlAgent = Framework.getAgent(AgentConstants.ORACLE_AGENT, ip , credential_id, properties)
except:
stacktrace = traceback.format_exception(sys.exc_info()[0], sys.exc_info()[1], sys.exc_info()[2])
if mam_utils.isDebugEnabled():
mam_utils.debug('Unexpected Framework.getAgent() Exception:')
mam_utils.debug(stacktrace)
else:
# 5 ##############################
discoverOracle(sqlAgent, ip, oracleOSH)
