Pandora FMS 1.2 does it work to monitor Oracle databases

[villa]

Like it

Up

0

Down

Drop it

::

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

[villa]

Like it

Up

0

Down

Drop it

::

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.