Can't run DBFIX - logon problems 1

[WANguy2k]

I'm running Arcserve 9.0 and all of a sudden we're getting the following error in the event log, which seems to cause the backup to fail.

The application, , generated an application error The error occurred on 01/30/2005 @ 04:11:06.843 The exception generated was c0000005 at address 0026F8C7 (d_getDbdNameFromDb)

I'm trying to run DBFIX (never did before) with the following command:

dbfix -a -L casdb;USERID;PASSWORD astpsdat

And I'm getting a logon error:

Failed to log into server 'casdb', username 'USERID': error -2005

Is there anyway to determine the logon name and password the database expects, or at least to change it to something new I can use? I never understood casdb, caroot, and all the other junk they put in here. Veritas is next for me.

Thanks in advance.

 

[vschumpy]

The username and password is always the same no matter which server this is run on, as is stated clearly in the CA document :

http://supportconnect.ca.com/sc/redir.jsp?reqPage=search&searchID=TEC268789

 

[WANguy2k]

Thanks for your reply. Unfortunately it looks like the admin password and/or ID was changed. I ran

dbfix -a -L casdb;admin;secret astpsdat

and I get

Failed to log into server 'casdb', username 'admin': error -2005.

I tried the few standard passwords we use for programs that require system access, no good. Is there any way of finding out what the correct ID and password is? I've heard talk of an "env" variable or configuration file, but don't know where it is. (Can call CA for support, I don't have 4 hours to sit on hold.)

 

[davidmichel]

Yes there sure is and it is in the document vldbutil found in the ARCserve directory.

This information can not be changed it is hardcoded into ARCserve.

 

[WANguy2k]

Thanks for your help guys, I finally got it fixed. Unfortunately the vldbutil was no help, and I found the environment variable RDSLOGIN that is supposed to tell you what login to use wasn't even present on the box. It looks like the admin/secret ID and password somehow got changed, or a database corruption was prohibiting me from even running dbfix with that ID and password.

Here's what I did to fix it, for anyone else that has these issues: I went to a working server and backed up the DATABASE folder. Then, I went into the server admin program on the working server and initialized the database, creating a blank database. I took the blank database files and copied them to the broken server, and was then able to login and use DBFIX. It also fixed my backup problem.

Now if we need to do a restore we just need to merge the backup tapes to be restored back into the database.

 

[maartenn]

That is one solution.
When you start with a new fresh database dbfix will always work.

The error -2005 means that the database is in use. When you run the vldbutilities you have to make sure that you do not access the database
If you still receive the -2005 error you can do the following:

- Stop the database engine. (check also if rds.exe is not running, else kill it)
- remove *.tmp in <arcservedir>/temp
- remove all files r*.* in <arcservedir>/database
- start up the database engine

If this does not work you can try the previous solution.