Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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