Download here ====> CactiOracle v 0.1 rev1.zip
Update to revision 1 (31 Jan 2014)
- fixed missing PHP scripts files.
- Add tutorial to create Data Input Methods
Post-Installation requirement
1.Data input field in graph title. http://forums.cacti.net/viewtopic.php?f=5&t=42802
2.Target database
2.1 Create user 'cacti' password 'cacti' (If not use 'cacti', must change in step datasources/graph create)
2.2 SQL> grant select any dictionary to cacti;
Installation
1.Import host templates from zip files.
2.Update your Oracle client environment in every PHP scripts files.
putenv("ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1");
putenv("TNS_ADMIN=/u01/app/oracle/product/11.2.0/db_1/network/admin");
3.Create Data Input Methods from PHP scripts.4.Add Devices and select Host Template to ORACLE Database Monitoring.
5.Create Graph from templates.
Step to create Data Input Methods
1. Oracle Sessions Monitor
Input String = <path_cacti>/scripts/ss_oracle_sessions.php ss_oracle_sessions <tnsnames> <user> <password>
2. Oracle Tablespaces Monitor
Input String = <path_cacti>/scripts/ss_oracle_tbls.php ss_oracle_tbls <tnsnames> <user> <password> <tablespace_name>
3. Oracle Shared pool free
Input String = <path_cacti>/scripts/ss_oracle_shared_pool_free.php ss_oracle_shared_pool_free <tnsnames> <user> <password>
4. Oracle system waited events
Input String = <path_cacti>/scripts/ss_oracle_waits.php ss_oracle_waits <tnsnames> <user> <password>
5. Oracle Physicals I/O
Input String = <path_cacti>/scripts/ss_oracle_phyio.php ss_oracle_phyio <tnsnames> <user> <password>
6. Oracle Buffer Hit Ratio
Input String = <path_cacti>/scripts/ss_oracle_bhitratio.php ss_oracle_bhitratio <tnsnames> <user> <password>
7. Oracle Archived log switch
Input String = <path_cacti>/scripts/ss_oracle_arcs.php ss_oracle_arcs <tnsnames> <user> <password>
If you have any question or request new ORACLE graph/template please contact me at pitchayasak.s@gmail.com
ไม่มีความคิดเห็น:
แสดงความคิดเห็น