User Tools

Site Tools


dba:oracle:scripts:check_remote_oracle

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
check_remote_oracle [2013/10/11 09:21] dodgeroracle:check_remote_oracle [2018/04/27 08:55] dodger
Line 1: Line 1:
 +====== [SCRIPT] Nagios check plugin for oracle ======
 +
 ====== Description ====== ====== Description ======
 Script used as plugin for Nagios to remotely check Oracle. Script used as plugin for Nagios to remotely check Oracle.
Line 26: Line 28:
 grant CONNECT, SELECT_CATALOG_ROLE to "NAGIOS" ; grant CONNECT, SELECT_CATALOG_ROLE to "NAGIOS" ;
 </code> </code>
 +
 +Control specific grants:
 +  * SGA:
 +<code sql>
 +GRANT SELECT ON SYS.V_$SGASTAT TO VOXELADMIN ;
 +</code>
 +
 +
  
 For a better understand of the usage, this script will do something like: For a better understand of the usage, this script will do something like:
dba/oracle/scripts/check_remote_oracle.txt · Last modified: 2023/01/31 08:28 by dodger