Pandora FMS Community

Pandora FMS 1.2 does it work to monitor Oracle databases

vathsan98 · 4 may 2007, 22:17 · 3 mensajes · 58 visitas

  1. Inicio del debate

    Hi, Does Pandora have monitoring capability for Oracle databases running on HPUX. Also is this Pandora FMS secure for an enterprise deployment.

  2. Hi, There are a agent to HP-UX, you must decide what parameters monitor and find the commands to monitor these parameters, integrate it with with Pandora is very easy. Perhaps anybody has this commands and can help you. Yes, Pandora is secure for an enterprise deployment. We, the develop team of Pandora, are experts in security and we have deployment Pandora FMS in important companies in Spain. Regards David

  3. Hi, Thanks to my collegue Vinicio from El Salvador, i have obtained three examples to monitro Oracle: 1) The availability of one instance. You can see if the LGWR process is up, you need the Oracle instance ID ps -ef | grep lgwr oracle 835784 1 0 May 01 - 0:17 ora_lgwr_ora1 oracle 880720 1 0 Apr 13 - 0:21 ora_lgwr_ora2 With this command: ps -ef | grep lgwr | grep ora1 | grep -v "grep" | wc -l you can know if the process ora1 exists. module_begin module_name ora1 module_type generic_proc module_exec ps -ef | grep lgwr | grep ora1 | grep -v "grep" | wc -l module_description process ora1 up module_end 2) The proccess listener state You can see if the listener process is up. (Be careful because in some configurations the listener process can be the same in all instances or this process could have a name different to database. ps -ef | grep tnslsnr oracle 421910 1 0 Apr 17 - 0:00 tnslsnr -inherit With this command: ps -ef | grep tnslsnr | grep -v "grep" | wc -l you can know if the process listener exists. module_begin module_name listener module_type generic_proc module_exec ps -ef | grep tnslsnr | grep -v "grep" | wc -l module_description process listener up module_end 3. The percentage of busy space versus free space With the following query you can know the space busy i all areas in the database, La siguiente SQL te da un vistazo de ocupacion de todas las areas en la base, denominadas tablespaces. select ts.tablespace_name tablespace_name, total.totsiz espacio,round(free.avasiz) disponible, round((1-nvl(avasiz,0)/totsiz)*100,2) "%UTILIZADO" from dba_tablespaces ts,(select tablespace_name, (sum(total.bytes)/1024)/1024 totsiz from dba_data_files total group by total.tablespace_name) total, (select tablespace_name,nvl((sum(free.bytes)/1024)/1024,0) avasiz from dba_free_space free group by free.tablespace_name) free where ts.tablespace_name=total.tablespace_name(+) and ts.tablespace_name=free.tablespace_name(+) module_begin module_name busy_Space module_type generic_data module_exec select ts.tablespace_name tablespace_name, total.totsiz espacio,round(free.avasiz) disponible, round((1-nvl(avasiz,0)/totsiz)*100,2) "%UTILIZADO" from dba_tablespaces ts,(select tablespace_name, (sum(total.bytes)/1024)/1024 totsiz from dba_data_files total group by total.tablespace_name) total, (select tablespace_name,nvl((sum(free.bytes)/1024)/1024,0) avasiz from dba_free_space free group by free.tablespace_name) free where ts.tablespace_name=total.tablespace_name(+) and ts.tablespace_name=free.tablespace_name(+) module_description Busy vrs free space module_end There are other examples and I hope that Vinicio will help us with this. You must verify this command in non production Oracle before run the pandora agent with this configuration. Regards David.

Entra en tu cuenta para publicar.