Chapter 8 Diagnosing Problems With CiscoWorks Server
Frequently Asked Questions
8-14
User Guide for CiscoWorks Common Services
78-16571-01
Step 3
Make sure no database processes are running and there is no database log file. For
example, if the database file is /opt/CSCOpx/databases/rme/rme.db, the database
log file is /opt/CSCOpx/databases/rme/rme.log. This file is not present if the
database process shuts down cleanly.
Step 4
(UNIX only) Check if the database files(s) and the transaction log file (*.log) are
owned by user casuser. If not, change the ownership of these files to user casuser
and group casusers.
Step 5
Run the command:
cd
NMSROOT/objects/db/conf
NMSROOT/bin/perl configureDb.pl action=validate dsn=<cmf>
The dbvalid command displays a list of tables being validated. The Validation
utility scans the entire table, and looks up each record in every index and key
defined on the table. If there are errors, the utility displays something like:
Validating DBA.xxxx
run time SQL error -- Foreign key parent_is has invalid or duplicate
index
entries 1 error reported
If the above command reports any error, you may try:
•
Restoring from a previous good backup
or
•
Reinitializing database
Caution
All the current data will be lost.
To do this, you have to run the following command:
NMSROOT\bin\perl NMSROOT\bin\dbRestoreOrig.pl dsn=dsn
dmprefix
=dmprefix
For Common Services, dsn is cmf and dmprefix is Cmf.