reninitdb.pl on RME3.5

Unanswered Question
Nov 28th, 2007
User Badges:

It looks like I need to reinitdb.pl on 1 of my 3 RME servers. I have a recent export of all the devices that can be reimported to get the device attributes back.


When I run the reinitdb.pl command,

what else will be lost?

what files can I make copies of before running the reinitdbb.pl command to be able to get the created users back and such?



  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (3 ratings)
Loading.
Joe Clarke Wed, 11/28/2007 - 14:56
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

reinitdb.pl only reinitializes the ANI database. If you want to reinitialize RME, you will need to run dbRestoreOrig.pl. When you reinitialize the RME database, you will lose inventory, configurations, syslogs, software images, and change audit records. While the configs and software images will be left on the disk, they will not be usable as the database no longer has records for them.

getwithrob Wed, 11/28/2007 - 19:00
User Badges:

Let me mnake sure I have this right -

If I have RME running on a single server w/ no other apps, there is 1) an ANI DB and 2)an RME DB.


reinitdb.pl will reinitialize ANI where dbRestoreOrig.pl will reinitialize RME?


Is this correct?


Martin Ermel Thu, 11/29/2007 - 05:41
User Badges:
  • Blue, 1500 points or more

no, not in all points ...

ANI db is the db from Campus Manager,

RMENG (or just RME in previous versions of LMS) is the db from Resource Manager and

CMF is the db from Common Services


so having just RME installed on a server and thus also Common Services you will have the following databases:

rmeng, cmf


for solaris

cd /opt/CSCOpx/bin

./perl ./dbpasswd.pl listdsn

or windows

cd C:\Progra~1\CSCOpx\bin

.\perl.exe .\dbpasswd.pl listdsn


will give you a list of the installed databases on the server

(assuming that LMS is installed in the default paths)

without any args, it shows how to use it


to reinit just the RME db you will have to run

/opt/CSCOpx/perl /opt/CSCOpx/bin/dbRestoreOrig.pl dsn=rmeng dmprefix=RME npwd=your_new_PW


where the last option (npwd=...) is optional but will set the DB password as you define


In most cases it is not necessary to reinit the Common Services db (cmf db)


You are correct, that reinitdb.pl will reinitialize ANI database or with the -ut option it will just whipe out the User Tracking tables from ANI db

and dbRestoreOrig.pl can reinitialze the RME db (or any other LMS db when used with the correct values for the arguments, use it with no args to see the help)


Joe Clarke Thu, 11/29/2007 - 09:11
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

A few corrections. This is RME 3.5, so the RME database is called simply "rme". In LMS 2.2, the CMF database only really holds the JRM entries and the Campus Manager topology groups, so reinitializing it is cheap.


Using reinitdb.pl with any arguments other than -restore is a BAD IDEA. The extra arguments to reinitdb.pl only really became safe in LMS 3.0.

Actions

This Discussion