Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

SQL error in NBU Master v7.1.0.4

Created: 21 Sep 2012 | 1 comment

Hi all,

I performed gracefully reboot on my NBU master server today, after server rebooted, found few NBU daemon was failed to started and some SQL error was getting during NBU database validation, i found one of DB daemon(NB_dbsrv) was missing and i was unable to bring it up. Seeking your assistant and advice to start it back.

SQL error during DB validation

# /usr/openv/db/bin/nbdb_admin -validate NBDB -full
SQL error (-100) -- Database server not found
SQL error (-100) -- Database server not found
SQL Anywhere Validation Utility Version 11.0.1.2745
Database [NBDB] validation failed.
 

NBU daemon list

# /usr/openv/netbackup/bin/bpps -a
NB Processes
------------
root     30641     1  0 11:12 ?        00:00:00 /usr/openv/netbackup/bin/vnetd -standalone
root     30646     1  0 11:12 ?        00:00:00 /usr/openv/netbackup/bin/bpcd -standalone
root     30767     1  1 11:12 ?        00:00:00 /usr/openv/netbackup/bin/nbaudit
root     30954     1  1 11:12 ?        00:00:00 /usr/openv/netbackup/bin/nbemm
root     30986     1  0 11:12 ?        00:00:00 /usr/openv/netbackup/bin/nbrb
root     31012     1  0 11:12 pts/3    00:00:00 /usr/openv/netbackup/bin/bprd
root     31019     1  0 11:12 ?        00:00:00 /usr/openv/netbackup/bin/bpcompatd
root     31024     1  0 11:12 pts/3    00:00:00 /usr/openv/netbackup/bin/bpdbm
root     31026     1  0 11:12 ?        00:00:00 /usr/openv/netbackup/bin/nbjm
root     31037 31024  2 11:12 pts/3    00:00:00 /usr/openv/netbackup/bin/bpjobd
root     31102     1  1 11:12 ?        00:00:00 /usr/openv/netbackup/bin/nbpem
root     31149 31102  2 11:12 ?        00:00:00 /usr/openv/netbackup/bin/nbproxy dblib nbpem
root     31177 31102  2 11:12 ?        00:00:00 /usr/openv/netbackup/bin/nbproxy dblib nbpem_cleanup
root     31180     1  2 11:12 ?        00:00:00 /usr/openv/netbackup/bin/nbrmms
root     31204 30646  0 11:12 ?        00:00:00 /usr/openv/netbackup/bin/bpcd -standalone
root     31209 31204  0 11:12 ?        00:00:00 sh -c /usr/openv/netbackup/bin/bptm -delete_all_expired 1>/dev/null 2>/dev/null
root     31211 31209  3 11:12 ?        00:00:00 /usr/openv/netbackup/bin/bptm -delete_all_expired
root     31264     1  1 11:12 ?        00:00:00 /usr/openv/netbackup/bin/nbsl
root     31317     1  2 11:12 ?        00:00:00 /usr/openv/netbackup/bin/nbars
root     31398     1  2 11:12 ?        00:00:00 /usr/openv/netbackup/bin/nbsvcmon

MM Processes
------------
root     30991     1  0 11:12 pts/3    00:00:00 /usr/openv/volmgr/bin/ltid
root     31333     1  0 11:12 pts/3    00:00:00 vmd
 

Comments 1 CommentJump to latest comment

Marianne's picture

Please check if Install_path\VERITAS\NetBackupDB\conf\server.conf file is intact.

There should be something like the following in this file:

-n NB_server_name -x tcpip(LocalOnly=YES;ServerPort=13785) -gd DBA -gk DBA -gl DBA -gp 4096 -ti 0 -c 25M -ch 500M -cl 25M -zl -os 1M -o "C:\Program Files\Veritas\NetBackupDB\log\server.log"
 
 
Please also check the 'server.log' for errors.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links