Cacti (home)ForumsDocumentation

Differences

This shows you the differences between two versions of the page.

usertemplate:graph:oracle [2010/07/07 14:11]
jerrison created
usertemplate:graph:oracle [2014/07/25 23:02] (current)
BSOD2600 [Oracle Graphs]
Line 1: Line 1:
-====== Cisco CPU Usage ======+====== Oracle Graphs ======
 ---- dataentry plugin_style ---- ---- dataentry plugin_style ----
 type:user_template_graph type:user_template_graph
-usertemplate_nspage:usertemplate:graph:oracle +usertemplate_nspage:graph:oracle 
-author_page:Jerrison +author_page: Jerrison 
-description: Lots of Oracle-DB Graphs +description: Oracle - DB Graphs 
-Cacti_Version: 0.87e+Cacti_Version: 0.8.7e
 homepage_url: http://forums.cacti.net/viewtopic.php?p=193684 homepage_url: http://forums.cacti.net/viewtopic.php?p=193684
 date: 2010-07-07 date: 2010-07-07
Line 15: Line 15:
 ===== Download ===== ===== Download =====
 ^Version^File^ ^Version^File^
-|0.8.7b|{{:usertemplate:graph:oracle-templates_and_scripts.zip|}}|+|0.8.7e|{{:usertemplate:graph:oracle-templates_and_scripts.zip|}}|
  
 ===== Installation ===== ===== Installation =====
Line 31: Line 31:
 It doesn´t matter if your Oracle-DB is 10.**1**! I could not get the "Win32_Grid_Control_agent_only_10_1_0_6_0." to work,\\  Oracle messed the whole subagent-business seriously up. It doesn´t matter if your Oracle-DB is 10.**1**! I could not get the "Win32_Grid_Control_agent_only_10_1_0_6_0." to work,\\  Oracle messed the whole subagent-business seriously up.
  
-===== 02 Oracle-SNMPO - Setting it up =====+===== 02 Oracle-SNMP - Setting it up =====
  
 The following is a mixture of Oracle-guides, forum searches and simple try and error of how i got the emsubagent working. There is almost\\  nothing out there concerning the subagent and problems started as early as "where the heck is emsubagent.exe" (which was left out in some agent-installation packs). The following is a mixture of Oracle-guides, forum searches and simple try and error of how i got the emsubagent working. There is almost\\  nothing out there concerning the subagent and problems started as early as "where the heck is emsubagent.exe" (which was left out in some agent-installation packs).
Line 43: Line 43:
   * Start Oracle MasterAgent-SNMP-Service (it´s called sth. like ".....SNMPPeerMasterAgent" at the end)   * Start Oracle MasterAgent-SNMP-Service (it´s called sth. like ".....SNMPPeerMasterAgent" at the end)
   * Start the agent-installation 10.2.05 or the root folder from a previous agent installation, i´ll call the root folder from the agent installation "OracleHomes" from now on   * Start the agent-installation 10.2.05 or the root folder from a previous agent installation, i´ll call the root folder from the agent installation "OracleHomes" from now on
-  * Configure the Targets.xml file under \OracleHomes\agent10g\sysman\emd -> put in the correct servername, DB-instance-name and username+passwort for the SNMP-user\\  For username and password: this is the DB-User that connects to the database to answer an SNMP-Query. The default is:\\ //    \\       //\\  You can choose any password you like, but we need to keep in mind to change the password of the user DBSNMP accordingly later on.\\  To give you an example targets.xml: \\ //\\ \\      \\      \\      \\      \\      \\      \\      \\ //\\ \\ //\\ //In some instances the unencrypted values were encrypted at some point so the password was not clear text. I really do not know what\\  kind of mechanism works the magic, you guess is as good as mine (oh, and i did not spend a lot of time figuring that one out, to be honest).+  * Configure the Targets.xml file under \OracleHomes\agent10g\sysman\emd -> put in the correct servername, DB-instance-name and username+passwort for the SNMP-user\\  For username and password: this is the DB-User that connects to the database to answer an SNMP-Query. The default is: 
 +\\   
 +   <Property NAME="UserName" VALUE="DBSNMP" ENCRYPTED="false"/
 +   <Property NAME="password" VALUE="DBSNMP" ENCRYPTED="false"/
 + 
 +You can choose any password you like, but we need to keep in mind to change the password of the user DBSNMP accordingly later on.\\  To give you an example targets.xml: \\ 
 +\\ 
 +  <Targets> 
 +  <Target TYPE="oracle_database" NAME="ORACLE_someserver.org"> 
 +   <Property NAME="OracleHome" VALUE="E:\oracle\product\10.1.0\Db_1"/
 +   <Property NAME="UserName" VALUE="DBSNMP" ENCRYPTED="false"/
 +   <Property NAME="password" VALUE="DBSNMP" ENCRYPTED="false"/
 +   <Property NAME="MachineName" VALUE="someserver.org"/
 +   <Property NAME="Port" VALUE="1521"/
 +   <Property NAME="SID" VALUE="ORACLE"/
 +   <Property NAME="ServiceName" VALUE="oracle"/> 
 +  </Target> 
 +  </Targets> 
 +\\ 
 +In some instances the unencrypted values were encrypted at some point so the password was not clear text. I really do not know what\\  kind of mechanism works the magic, you guess is as good as mine (oh, and i did not spend a lot of time figuring that one out, to be honest).
  
   * Now alter the DBSNMP-User password in your DB: SQL> __ALTER USER DBSNMP IDENTIFIED BY **DBSNMP**;__ (last part is the password, i used the default)\\  To get an SQL prompt, be a member of the local group called "ORA_DBA" and execute: "sqlplus / as sysdba" (DB-Admins know that, i didn´t, might save someone some time).   * Now alter the DBSNMP-User password in your DB: SQL> __ALTER USER DBSNMP IDENTIFIED BY **DBSNMP**;__ (last part is the password, i used the default)\\  To get an SQL prompt, be a member of the local group called "ORA_DBA" and execute: "sqlplus / as sysdba" (DB-Admins know that, i didn´t, might save someone some time).





Personal Tools