Zenoss Oracle Monitoring

Zenoss Oracle Monitoring

Hi guys i thought i will submit the Zenpack through which i am monitoring Oracle , i wanted to submit this to Zenoss ,but someone already came up with some other zenpack . i am working on getting Oracle Apps monitoring will release next month .


Here are some key Points for installation of this Oracle Zenpack .

Download the below files from these location .

Oracle Script ( Someone gave me the initial Script and i modified it as per my requirement .)

Oracle Zenpack



1. Install oracle Client on your zenoss server . The oracle client install should be with user zenoss so you don’t have issue with oracle library issue . ( use the latest client like 11g , I have seen some bugs on 10g with oci.dll which stop querying the database after 200 days of uptime )

2. Copy the attach script check_health_oracle to $ZENHOME/checkoracle/plugins-scripts and set the executable permission to it .

3. Ask your dba to create a user zenoss and password zenoss . I have set the template with same user and same password you can change it if you like

4. Ask him to grant the below roles

grant create session, connect, select on v_$sysstat, v_$session, v_$log, v_$instance, sys.dba_free_space, sys.dba_data_files to zenoss ;

5. When you define the tnsnames or oracle client set it as below . I have set the tnsnames as the devicename

=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = Oracle_SID)

)

)

6. Install the attach zenpack .

7. this will create a Organizer /device/server/oracle , if you need to attach the same to your Linux boxes just copy the template and copy to linux and attach multiple template to it .

Below things can be monitored using this zenpack .

connected-users

Connection-Time

Data_File_IO_Traffic

Invalid_Objects

PGA-IN-Memory

Redo_IO_Logs

SGA

SGA-cache-hit

SGA-latches-hit

Stale-statics

Tablespace-Usage