User guide

5-16
Cisco Media Gateway Manager 5.0 User Guide
OL-5461-02
Chapter 5 Maintaining an Efficient Network
How Do I Manage the Database?
5.1.5 Using the SQL*PLUS Client to Manage the Database
To access the database and Cisco MGM schema objects, use the SQL*PLUS client that ships with Oracle
products. The SQL*PLUS client is available for Microsoft Windows 2000 or NT 4.0 PCs or
Sun Solaris 8 workstations. Refer to the Oracle documentation to install and run the SQL*PLUS client
on a Windows 2000 or NT 4.0 PC.
On a Sun Solaris workstation, the SQL*PLUS client is installed as part of the Oracle server installation.
The following guidelines are for logging into SQL*PLUS as a Cisco MGM user and managing
Cisco MGM schema objects and data. Refer to the SQL*PLUS User Guide for a complete description.
Step 1 On the Sun Solaris machine 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 2 Verify that the following UNIX environment variables for the Oracle user are set correctly:
• ORACLE_HOME
• ORACLE_SID
• PATH variable has $ORACLE_HOME/bin in the path
• LD_LIBRARY_PATH
Remove an NE (prune_ne.sh)
(continued)
???_table
????_tableoss_alarm_fltr_tid_d
eny_tbl
pm_historical_appointments
proxy_server_table
server_monitor_table
sway_user_port_table
tca_event_table
transaction_log_table
unmanaged_ne_inventory_table
user_map_table
circuit_dest_tbl
circuit_span_tbl
link_table
ne_info_table
NE SYS ID Removes all information about the
NE from the database. Use this script
with extreme caution.
Prune server monitoring data
(prune_server_monitor.sh)
server_monitor_table Number of days
1–31
Removes all server monitoring data.
Table 5-6 Database Pruning (continued)
What to Prune
(Script Name) Tables Affected Input Parameters Remarks