User guide

5-18
Cisco Media Gateway Manager 5.0 User Guide
OL-5461-02
Chapter 5 Maintaining an Efficient Network
How Do I Manage the Database?
Step 5 Enter the following command to start the Cisco MGM server:
mgms-start
5.1.7 Enhancing Database Performance
To improve database performance when Cisco MGM clients access Cisco MGM data, tune the Oracle
database as outlined in “Part IV: Optimizing Oracle Instance Performance” in the Oracle9i Tuning
Guide.
5.1.8 Removing an Old Version of the Cisco MGM Database
If necessary, remove all Cisco MGM schema objects from the database. However, all Cisco MGM
information from the database will be deleted. An example of when to remove all Cisco MGM schema
objects from the database is during reinstallation of the Cisco MGM server when data from a previously
installed version is irrelevant.
To remove all Cisco MGM schema objects from the database:
Step 1 Shut down the Cisco MGM server and all Cisco MGM clients.
Step 2 On the Sun Solaris workstation running Oracle, log in as the Oracle owner user. Use the username that
was used when installing Oracle9i.
Note To verify the username, enter the id command on the shell.
Step 3 Enter the following commands to shut down the Cisco MGM database:
%sqlplus /nolog << EOF
SVRMGR> connect sys/change_on_install as sysdba
SVRMGR> shutdown abort;
SVRMGR> EOF
Step 4 Enter the following commands:
cd /db01
/bin/rm -rf
ORACLE_SID
Step 5 Change the directory to the location of the Cisco MGM Data1 tablespace (/db02).
Step 6 At the UNIX shell prompt, enter the following command:
ls -alR mgmdata1
Step 7 Enter the following commands:
/bin/rm -rf ORACLE_SID
/bin/rm -rf mgmdata1/ORACLE_SID*
Step 8 Change the directory to the location of the Cisco MGM Data2 tablespace (/db03).
Step 9 Enter the following command:
/bin/rm -rf mgmdata2/ORACLE_SID*