User guide

5-5
Cisco Media Gateway Manager 5.0 User Guide
OL-5461-02
Chapter 5 Maintaining an Efficient Network
How Do I Manage the Database?
Configuration Mode Configuration Mode tells the Cisco MGM server the values to use to log into the Oracle database.
When set to Auto, the Cisco MGM server uses the configuration that was set when Cisco MGM was
installed. When set to Manual, the After Restart fields can be edited, and the Cisco MGM server
will use the edited values when the server is rebooted.
Note If you change the configuration mode to Manual, enter the following commands to set the
ORACLE_HOME and ORACLE_SID environment variables before logging into
Cisco MGM again:
setenv ORACLE_HOME Oracle home directory
setenv ORACLE_SID MGM5_0
setenv LD_LIBRARY_PATH $ORACLE_HOME/lib
setenv PATH $PATH:$ORACLE_HOME/bin
Restart the Cisco MGM server after setting these environment variables.
Caution If you set the configuration mode to Auto and restart the Cisco MGM server, the
MGMServer.cfg file is overwritten with the default values for username, password,
location, port, system ID, and SQL network alias.
Username Displays the username that the Cisco MGM server uses to access the Oracle database.
Password Displays the password that gives the username access to the Oracle database.
Location Displays the IP address that the Cisco MGM server uses to connect to the database.
Port Displays the port number that is used to connect to the database.
System ID Displays the Oracle system ID. The ORACLE_SID specifies the system identifier (SID) value of
the database instance that you create with the Cisco MGM installer. For a single-instance database,
the SID value should be the same as the name of the database it manipulates (initialization
parameter DB_NAME), and no more than four characters.
Note During Cisco MGM installation, the default system ID is MGM5_0.
SQL Network Alias Displays the SQL*Net listener alias set in the system listener.ora file. When the listener is running,
entering the ps command displays the following output (not all systems display listener_alias):
tnslsnr [listener_alias] [-inherit]
Shadow processes (dedicated servers) spawned by the SQL*Net listener have the following syntax:
oracleSID [(LOCAL=NO)]
Table 5-1 Field Descriptions for the Database Properties—Configuration Tab (continued)
Field Description