Chapter 10 Oracle 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 SQLNet 2.2; Performance Manager supports release 7.2 and later.

Oracle7 GUI support

There are two display categories and one threshold category:

Display categories
Oracle Ratios

This category displays the most useful ratios for tuning the performance of an Oracle7 database instance.

RDBMS Tables

These are 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 Tru64 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 TRU64 UNIX's native eSNMP master agent on a private port, and then reregisters all its MIB registrations to Peer master agent through Peer encapsulator. These relationships are diagrammed in the following drawing.
SNMP diagram
Configuration procedure

To configure the agent:

  1. Log in as root with Oracle7 installed.
  2. Stop eSNMP master agent if it's up running by entering the following command:

# /sbin/init.d/snmp stop

  1. Start Peer master agent by entering the following command:

# start_peer -m

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

  1. Start eSNMP master agent on a private port by entering the following command:
  2. For DIGITAL UNIX version 3.2 or lower:

# native_snmpd.sh

  • See Oracle commands for the full script.
  • For DIGITAL UNIX version 3.2C or higher:

# native_esnmpd.sh

  • See Oracle commands for the full script.

You need the eSNMP patch 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.

  1. Restart all the eSNMP subagents, if necessary.
  2. 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/snmp dump
  1. Reformat the dumped contents into CONFIG.encap file format with the same port number as the new NEW_SMNPD_PORT above.
  2. Start Peer encapsulator by running the following command.:
start_peer -e
  1. Start the desired SNMP services offered by Oracle7 Server.

Peer encapsulator does not always function correctly in Tru64 UNIX. If this problem occurs, you have to give up the services 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 Tru64 UNIX, Installation and Configuration Guide, release 7.2.3 or higher.
Oracle commands

These are the scripts you need for configuring Oracle7 support.

The native_esnmp.sh script for DIGITAL UNIX 3.2C or higher

#!/bin/sh
#

# variables for modifying /etc/services

#

ORG_SNMPD_PORT=161 # port that snmpd listens to. Don't modify.

ORG_TRAPD_PORT=162 # port that snmpd send trap to. Don't modify.

NEW_SNMPD_PORT=1611 # new port that snmpd listens to. Make sure this is # the same as the one you use in CONFIG.encap

NEW_TRAPD_PORT=1612 # peer encapsulator port that snmpd sends trap to.

ETC_SERVICES=/etc/services

SAV_SERVICES=/etc/services.org.$$

TMP_SERVICES=/tmp/services.$$

CLRCMD="/bin/rm -f $TMP_SERVICES $SAV_SERVICES"

TRPCMD="if [ -x $SAV_SERVICES ]

then

mv $SAV_SERVICES $ETC_SERVICES;

fi

$CLRCMD;

exit 1"

$CLRCMD

trap "$TRPCMD" 1 2 3 9 15

sed "s/$ORG_SNMPD_PORT\/udp/$NEW_SNMPD_PORT\/udp/g;

s/$ORG_TRAPD_PORT\/u dp/$NEW_TRAPD_PORT\/udp/g" $ETC_SERVICES

$TMP_SERVICES

echo "Modifying $ETC_SERVICES for snmpd startup..."

echo "cp $ETC_SERVICES $SAV_SERVICES"

cp $ETC_SERVICES $SAV_SERVICES

echo "cp $TMP_SERVICES $ETC_SERVICES"

cp $TMP_SERVICES $ETC_SERVICES

echo "Starting snmpd ..."

echo "/sbin/init.d/snmpd start 2&1"

/sbin/init.d/snmpd start 2&1

echo "Restoring $ETC_SERVICES ..."

echo "mv $SAV_SERVICES $ETC_SERVICES"

mv $SAV_SERVICES $ETC_SERVICES

echo "Done!"

echo

$CLRCMD

The native_snmpd.sh script for DIGITAL UNIX 3.2 or lower

#!/bin/sh

#

# variables for modifying /etc/services

#

ORG_SNMPD_PORT=161 # port that snmpd listens to. Don't modify.

ORG_TRAPD_PORT=162 # port that snmpd send trap to. Don't modify.

NEW_SNMPD_PORT=1611 # new port that snmpd listens to. Make sure this is
# the same as the one you use in CONFIG.encap

NEW_TRAPD_PORT=1612 # peer enscapsulator port that snmpd sends trap to.

ETC_SERVICES=/etc/services

SAV_SERVICES=/etc/services.org.$$

TMP_SERVICES=/tmp/services.$$

CLRCMD="/bin/rm -f $TMP_SERVICES $SAV_SERVICES"

TRPCMD="if [ -x $SAV_SERVICES ]

then

mv $SAV_SERVICES $ETC_SERVICES;

fi

$CLRCMD;

exit 1"

$CLRCMD

trap "$TRPCMD" 1 2 3 9 15

sed "s/$ORG_TRAPD_PORT\/udp/$NEW_TRAPD_PORT\/udp/g" $ETC_SERVICES

$TMP_SERVICES

echo "Modifying $ETC_SERVICES for snmpd startup..."

echo "cp $ETC_SERVICES $SAV_SERVICES"

cp $ETC_SERVICES $SAV_SERVICES

echo "cp $TMP_SERVICES $ETC_SERVICES"

cp $TMP_SERVICES $ETC_SERVICES

echo "Starting snmpd ..."

echo "/usr/sbin/snmpd -p $NEW_SNMPD_PORT 2&1"

/usr/sbin/snmpd -p $NEW_SNMPD_PORT 2&1

echo "Restoring $ETC_SERVICES ..."

echo "mv $SAV_SERVICES $ETC_SERVICES"

mv $SAV_SERVICES $ETC_SERVICES

echo "Done!"

echo

$CLRCMD
Go to Main   Go to Previous   Go to Next