Installing the Database
This section includes the following topics:
Restrictions
- If you are installing Cisco SAN-OS Release 3.1(2b) or later, you can also use Oracle Database 10g Express. Your other choice is PostgreSQL.
- If you are installing Cisco NX-OS Release 5.0(1a) or later, you can also use Oracle Database 10g Express, or Oracle Database 10g. Your other choice is PostgreSQL.
- Be sure to back up all of the rrd file in $INSTALL/pm/db before the upgrade.
- If you want to use Oracle Database 10g Express, you must install the database and create a user name and password before continuing with the DCNM-SAN installation.
- We recommend the Oracle Database 10g Express option for all users who are running Performance Manager on large fabrics (1000 or more end devices).
Directory Structure
Starting from Cisco MDS NX-OS Release 4.1(3a), the directory structure has changed to accommodate its future integration with Nexus 5000 products. By default, the DCNM-SAN components are installed on your computer’s hard drive, in the C:\Program Files\ folder. The installation path is the root directory on your computer, such as C:\Program Files\Cisco Systems. DCNM-SAN and databases are installed in application directories, such as C:\Program Files\Cisco Systems\DCM\FM. Table 1-1 and Table 1-2 describe the directory structure for Windows, UNIX and Solaris operating systems.
Table 1-1 Directory Structure (Windows)
|
|
C:\Program Files\Cisco Systems\ |
Home directory for Cisco products. |
C:\Program Files\Cisco Systems\DCM\ |
Home directory for Cisco Data Center Management products. |
C:\Program Files\Cisco Systems\DCM\FM |
Home directory for DCNM-SAN and Device Manager. |
C:\Program Files\Cisco Systems\DCM\JBOSS-4.2.2.GA |
Home directory for JBoss (DCNM-SAN Server infrastructure). |
C:\Program Files\Cisco Systems\DCM\DB |
Home directory for database (Oracle and PostgreSQL). |
C:\Program Files\Cisco Systems\DCM\JRE |
Home directory for Java Runtime Environment. |
C:\Program Files\Cisco Systems\DCM\JBOSS-4.2.2.GA\SERVER\FM |
Home directory for DCNM-SAN Server. |
Table 1-2 Directory Structure (Unix and Solaris)
|
|
/usr/local/cisco |
Home directory for Cisco products. |
/usr/local/cisco/dcm/ |
Home directory for Cisco Data Center Management products. |
/usr/local/cisco/dcm/fm |
Home directory for DCNM-SAN and Device Manager. |
/usr/local/cisco/dcm/jboss-4.2.2.GA |
Home directory for JBoss (DCNM-SAN Server infrastructure). |
/usr/local/cisco/dcm/db |
Home directory for database (Oracle and PostgreSQL). |
/usr/local/cisco/dcm/jboss-4.2.2.GA/server/fm |
Home directory for DCNM-SAN Server. |
Installing Oracle
To install the Oracle database, follow these steps:
Step 1 Click the following link to install Oracle Database 10g Express or Oracle Database 11g.
http://www.oracle.com/technology/software/products/database/xe/index.html
Note If you have another instance of Oracle already installed on a PC, we recommend that you do not install the Oracle database on the same PC. In such cases, DCNM-SAN can only use the PostgreSQL database.
Step 2 Run OracleXE.exe to install the Oracle database. Set the password for the system user. The database administrator uses the password to manage and administer Oracle Database 10g Express server, which is installed by the Oracle installer.
Step 3 Finish the installation and verify that both services (OracleServiceXE and OracleXETNSListener) are running from the Services window.
Step 4 Run the following script to
a. Change the default Oracle admin port to 8082, and
b. To create a database account. This example creates a new user 'scott' with a password 'tiger'. You need to keep this login credentials as it is required at a later point in the installation process.
C:\> cd c:\oraclexe\app\oracle\product\10.2.0\server\bin
C:\oraclexe\app\oracle\product\10.2.0\server\bin>sqlplus / as sysdba
SQL> exec dbms_xdb.sethttpport(8082);
SQL> GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO SCOTT IDENTIFIED BY
Note The Oracle Database 10g Express option is only supported on Microsoft Windows. It is not supported on UNIX systems.
Note For information about backing up the Oracle database, go to this location:
http://download.oracle.com/docs/cd/B25329_01/doc/admin.102/b25107/backrest.htm#i1004902.
You can also use the exp/imp utility at this location:
http://download.oracle.com/docs/cd/B25329_01/doc/admin.102/b25107/impexp.htm#BCEEDCIB.
If you are using the Oracle database, you need to install the Oracle JDBC (Java Database Connectivity) component for DCNM-SAN to connect to the database.
Increasing UDP Buffer Size
If the DCNM-SAN SNMP packet log shows an SNMP VarBind decode error, the UDP buffer size is low and the buffer size needs to be increased.
To increase the UDP buffer size, do the following:
Step 1 For Solaris, ensure that the UDP buffer size is at least 64 K.
ndd -set /dev/udp udp_recv_hiwat 65535
ndd -set /dev/udp udp_xmit_hiwat 65535
Step 2 Add the following setting in /etc/system, so that the buffer size will be in effect even after a reboot.
set ndd:udp_recv_hiwat=65535
set ndd:udp_xmit_hiwat=65535
Note Before starting the installation, make sure that you have logged in as a Superuser.
Backing up Database
The DCNM-SAN uses PostgresSQL Database as the default database. The DCNM-SAN backup utility uses PostgresSQL pg_dump utility to dump all of the database content to an ASCII dump file. Restore utility uses PostgresSQL to recreate data using the dump file.
The dump file represents a snapshot of the database at the time of backup.
To perform a backup of the DCNM-SAN database, enter these commands on Linux/Solaris. Assume INSTALLDIR is the top directory of DCNM-SAN installation.
/pgbackup.sh 02252008.data
The backup file 02252008.data will be created in $INSTALLDIR/bin directory. If you want to create it in a standard backup director provide the full path name of the dump file.
To perform a backup of the DCNM-SAN database, enter these commands on Windows. Assume INSTALLDIR is the top directory of DCNM-SAN installation.
/pgbackup.bat 02252008.data
The backup file 02252008.data will be created in $INSTALLDIR/bin directory. If you want to create it in a standard backup director provide the full path name of the dump file.
Note When PostgreSQL is chosen as the database, ensure that the Microsoft Windows user installing the software has administrative privileges and not the domain admin privileges. This is a prerequisite for successful installation.
For information about backing up the PostgreSQL database, run the pg_dump utility to have a good backup. For more information, go to this location: http://www.postgresql.org/docs/8.1/static/app-pgdump.html.
Restoring Database
To restore DCNM-SAN database, you must have a good backup file, and you must stop the DCNM-SAN server before restoration. Run restore and enter these commands on Linux Solaris. Assume INSTALLDIR is the top directory of the DCNM-SAN installation.
./pgrestore.sh 02252008.data
To restore DCNM-SAN database, you must have a good backup file, and you must stop the DCNM-SAN server before restoration. Run restore and enter these commands on Windows. Assume INSTALLDIR is the top directory of the DCNM-SAN installation.
./pgrestore.bat 02252008.data