Conference turris::digital_unix

	Performance Manager provides access to several daemons.  The metrics 
you are having trouble accessing are provided by the pm daemon "pmgrd".  Check 
to make sure it (pmgrd) is running.  You should not need a license unless you 
are tring to access a remote machine.

    Thanks. The pmgrd daemon is in the /sbin/rc3.d directory but somehow
    failed to run during the bootup.
    
    /joeljosol

	I am seeing a similar error message -- timeout -- attempting
	to access Oracle RDBMS data from PM.

		    Digital UNIX V4.0B
		    Oracle V7.3.2

	Any ideas on how to debug link to Oracle via SNMP?  Has anyone
	made the PM -- Oracle link work?

	jk

	
	Information on PM Oracle support from oracle.html which included in the PM html docs.


Oracle7 Database Support

Performance Manager's support of Oracle7 enables you to manage the database server and its services with
GUI tools and SNMP configuration. Oracle SNMP support is a new feature introduced in Oracle7 Server
release 7.2 with SQL�Net 2.2; Performance Manager supports release 7.2 and later. 

Oracle7 GUI Support

There are two display categories: 

       Oracle Ratios 
       Displays the most useful ratios for tuning the performance of an Oracle7 database instance. 
       RDBMS Tables 
       Easy-to-read tables that contain the most important information about an Oracle7 database. 

Threshold Category: 

       Oracle Ratios 
       Set up thresholds over some of the most useful ratios for tuning the performance of an Oracle7
       database instance. 

Agent Configuration

Oracle7 SNMP services are based on Peer Networks' SNMP master technology; however, in Digital UNIX,
eSNMP master technology is native. These two technologies are not compatible in nature, but Peer offers a
mechanism called Peer encapsulator that can connect any third-party SNMP agents to Peer master agent. 

This method puts Digital UNIX's native eSNMP master agent on a private port, and then reregisters all its
MIB registrations to Peer master agent through Peer encapsulator. 



Configuration Procedure

    1.Log in as rootwith Oracle7 installed. 

    2.Stop eSNMP master agent if it's up running by entering the following command. 
       /sbin/init.d/snmpd stop 

    3.Start Peer master agent by entering the following command. 
       start_peer -m 

              Note: If you are not concerned about configuring eSNMP, skip to step 10. 

    4.Start eSNMP master agent on a private port by entering the following command. 
       native_snmpd.sh (for Digital UNIX Version 3.2 or lower.) 
       See Oracle Commands for the full script. 
       native_esnmp.sh (for Digital UNIX Version 3.2c or higher.) 
       See Oracle Commands for the full script. 

              Note: You need the eSNMP patch to be able to sit the eSNMP master agent on a
              private port if you are using Digital UNIX versions 3.2C, 3.2D, 3.2E, 3.2F or 4.0. The
              patch is not needed for versions 3.2G, 4.0x or later versions. 

    5.Restart all the eSNMP subagents, if necessary. 

    6.Dump out all the MIB registrations of the eSNMP master agent, which causes the eSNMP master
       agent (snmpd) to dump the contents of its registry into /var/tmp/snmpd_dump.log. Do this by running
       the following command. 
       /sbin/init.d/snmpd dump 

    7.Reformat the dumped contents into CONFIG.encap file format with the same port number as the new
       NEW_SNMPD_PORT above. 

    8.Start Peer encapsulator by running the following command. 
       start_peer -e 

    9.Start the desired SNMP services offered by Oracle7 Server. 

       Note: Peer encapsulator does not always function correctly in Digital UNIX. If this problem
       occurs, you have to give up the seervices offered by eSNMP master agent if you choose to
       monitor Oracle7 Service via SNMP. 

For more information, see the following: 

       Oracle SNMP Support Reference Guide, release 2.2 or higher. 

       Oracle7 for Digital UNIX, Installation and Configuration Guide, release 7.2.3 or higher. 

	Thanks for the pointer to the documentation -- I found it
	on the CDROM.  Note, the DU V4.0B Documentation CD has 
	an entry for PM that indicates there is no HTML 
	documentation for PM just Bookreader?!

	Back to PM and Oracle -- We followed the procedure 
	outlined in 8899.4 (the HTML documentation).  We still
	see -- SNMP Request Timed Out for hostname RDBMS SVR 
	At this point, our concern is focused on step #7 from
	the documentation.  

7.Reformat the dumped contents into CONFIG.encap file format with the same port
number as the new NEW_SNMPD_PORT above. 

	The Peer encapsulator mechanism relies on the file "CONFIG.encap" 
	but we are not sure what the format/content should be.  We tried
	creating a "CONFIG.encap" and essentially made SNMP non-functional 
	on our test machine.  Any examples what a CONFIG.encap should
	contain?

	

Hi jk,
	I don't think the problem is on the step 7 since you still
aren't able to retrieve the RDBMS MIB variables.  The step 7 is
just let you reregister all the MIB entries under eSNMP to Peer's
Encapsulator.  CONFIG.encap is used by the encapsulator, and it
basicly consists of a set of port-to-mib_entry pairs.  I don't have
the example of the file with me since I don't have access to any
Oracle7 system at this moment, but I think you should be able to
find its templet in the directory where start_peer resides.

	I think that your problem may be that you haven't started
the SNMP service within the listener.  It's not on automatically,
so you have to turn it on.  Please refer to the Oralce7 installation
guide or a manual called Understanding SQL*Net(look for SNMP related
topics).

	After you've done and checked the above, issue a simple SNMP
query against the Oracle7 server with a RDBMS variable from the
management station(which pmgr gui is installed), such as:
   getmany the-oracle7-node public rdbmsDbTable
you should see a list of RDBMS information returned.

	If you still have any questions, please feel free to contact
me directly.


Ed Sun
Performance Manager group
[email protected]
DTN 548-8791