<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
<pre><br></pre><div><br>
<style><!--
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}
-</style>Hello;<br><div dir="ltr"><br><br>
i want to check the following from nagios server; i read abt your check_remote_plugin as well.<br><br><br><u><b>My Oracle DB server details</b></u><br><br>
operating System: Solaris<br>
database: oracle<br>IP: 192.168.1.2 (not real ip)<br><br><br><u><b>My Nagios Server details</b></u><br>OS : Ubuntu<br>i have configured nagios 3.x<br><br><br>i connect to my db server from my nagios as follow:<br><br><br> <font style="" face="Courier New"><i>ssh -Y root@192.168.1.2</i></font><br><font style="" face="Courier New"><i>Password: xxxxxxxxx</i></font><br><font style="" face="Courier New"><i>[root@vboxdb /]# su - oracle</i></font><br><font style="" face="Courier New"><i><br></i></font><br><font style="" face="Courier New"><i>Sun Microsystems Inc. SunOS 5.10 Generic January 2005<br>[oracle@vboxdb ~]$ sqlplus / as sysdba</i></font><br><font style="" face="Courier New"><i><br>SQL*Plus: Release 11.2.0.1.0 Production on Wed May 30 04:53:48 2012<br><br>Copyright (c) 1982, 2009, Oracle. All rights reserved.<br><br><br>Connected to:<br>Oracle Database 11g Release 11.2.0.1.0 - 64bit Production<br><br><br></i></font><br><font style="" face="Courier New"><i><br></i></font><br>
<font style="" face="Arial"><b><font style="">what i want to do i will list below ;</font></b></font><br><font style="" face="Courier New"><i><br></i></font><br>
<font style="" face="Courier New"><i><br></i></font><br>
<font style="" face="Courier New"><i>SQL> select current_utilization, max_utilization, limit_value from v$resource_limit where resource_name ='sessions';</i></font><br><font style="" face="Courier New"><i><br></i></font><br>
<font style="" face="Courier New"><i>CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE</i></font><br><font style="" face="Courier New"><i>
------- ----- --------- ----- <br></i></font><br><font style="" face="Courier New"><i>386 404 1528</i></font><br><br><br>
<b>if the current utilization reaches 1500 alert critical, 1450 warning state.
else normal.</b><br>
<b>can you tell me how i can do this. <br></b><br><br><br>i have
nagios installed on a different machine to monitor systems.<br><br><br><br><br><br>best regards,<br> Nashrah<br><br><br> </div></div> </div></body>
</html>