How to reload the SpectroSERVER Database (SSdb) in NetOps Spectrum?
searchcancel
How to reload the SpectroSERVER Database (SSdb) in NetOps Spectrum?
book
Article ID: 191684
calendar_today
Updated On: 04-04-2024
Products
Network ObservabilitySpectrum
Issue/Introduction
When there is a Spectrum crash or when the database needs to be reloaded, how is it done?
Environment
All Supported Releases
Resolution
There are two ways to do this, The first is via the GUI (Spectrum Control Panel - SCP) and the second is through the command line interface (CLI).
Reload via CLI
Go to the command line on the SpectroSERVER (bash -login in Windows)
Go to the $SPECROOT/SS-DB-Backup/ directory. $ cd $SPECROOT/SS-DB-Backup
Extract the SSdb backup file. $ gunzip db_yyyymmdd_hhmm.SSdb.gz
Go to the $SPECROOT/SS/ directory. $ SPECROOT/SS/
Delete the .VNMDB.LOCK file:
rm -f .VNMDB.LOCK
This file is created when the SpectroSERVER is started and removed when shutdown. However, if the SpectroSERVER crashes, then the file will be left behind and this prevents access to the SSdb (from SSdbload, SpectroSERVER, mte.exe ...etc) and must be removed before the SSdb can be reloaded.
This will reload the database and the server can then be started back up.
* IMPORTANT:the SSdbload must be run from the SS folder otherwise the database will not load properly * IMPORTANT: the SSdbload must be run as the Spectrum user and not as the root
Reload by SCP
In the Spectrum Control Panel, click on the Restore Database button.
Click on Yes to initialize the SpectroSERVER database.
Choose the most recent backup file and click on the Open button to start the restore.
If the .VNMDB.LOCK exists, you have to click on Yes to remove it.
After the SSdb database is successfully restored, you can start the SpectroSERVER application in Spectrum Control Panel.