Forum Discussion

fjacquet's avatar
fjacquet
Level 3
15 years ago
Solved

netbackup 7 install fails on fresh solaris 10 u8

hello

Does anybody already face this at netbackup 7 end of install

Installed SQL Anywhere Version 11.0.1.2222

Installation completed successfully
Database server is NB_srvsback01
Creating the NetBackup database.
Creating NetBackup data files in: /usr/openv/db/data
Creating /usr/openv/db/data
Creating NetBackup index files in: /usr/openv/db/data
Creating NetBackup transaction log file in: /usr/openv/db/data
Creating NetBackup staging directory in: /usr/openv/db/staging
Creating /usr/openv/db/staging
Starting the NetBackup database.
Database [NBDB] can't be started on server [NB_srvsback01].
Creating the NetBackup database files.
Error at line 1
Invalid user ID or password


Unable to create/upgrade the NB database.  Refer to the
log file in /usr/openv/netbackup/logs/nbdb for more
information.  Rerun /usr/openv/netbackup/bin/install_bp
when the problem has been resolved.


NetBackup server installation complete.

System is a t5240 with latest patches installed.


nbdb log says
07:37:19.964 [8507] <4> create_nbdb: Entering.
07:37:19.964 [8507] <4> create_nbdb: /usr/openv/db/bin/create_nbdb -force -data /usr/openv/db/data -index /usr/openv/db/data -tlog /usr/openv/db/data -staging /usr/openv/db/staging
07:37:19.967 [8507] <4> create_nbdb: SQLANY = /usr/openv/db
07:37:19.967 [8507] <4> create_nbdb: SQLANY11 = /usr/openv/db
07:37:19.967 [8507] <4> create_nbdb: LD_LIBRARY_PATH = /usr/openv/db/lib
07:37:19.967 [8507] <4> create_nbdb: ASTMP = /usr/openv/tmp/sqlany
07:37:19.967 [8507] <4> create_nbdb: SATMP = /usr/openv/tmp/sqlany
07:37:19.971 [8507] <4> pingDBServer: Entering.
07:37:19.971 [8507] <4> pingDBServer: Running . /usr/openv/db/vxdbms_env.sh && "/usr/openv/db/bin/dbping" -q -c "ENG=NB_srvsback01;LINKS=shmem,tcpip{PORT=13785}"
07:37:20.394 [8507] <4> pingDBServer: Database server [NB_srvsback01] is available.
07:37:20.394 [8507] <4> pingDBServer: Exiting. rc = 0
07:37:20.394 [8507] <4> getExistingDBFile: Entering.
07:37:20.401 [8507] <4> getExistingDBFile: Exiting with rc = 0
07:37:20.401 [8507] <4> createdb: Entering.
07:37:20.401 [8507] <4> createdb: Creating the NetBackup database.
07:37:20.401 [8507] <4> createdbdir: Entering.
07:37:20.401 [8507] <4> createdbdir: Creating NetBackup data files in: /usr/openv/db/data
07:37:20.402 [8507] <4> createdbdir: Creating /usr/openv/db/data
07:37:20.402 [8507] <4> createdbdir: Exiting with rc = 0
07:37:20.402 [8507] <4> createdbdir: Entering.
07:37:20.402 [8507] <4> createdbdir: Creating NetBackup index files in: /usr/openv/db/data
07:37:20.402 [8507] <4> createdbdir: Exiting with rc = 0
07:37:20.402 [8507] <4> createdbdir: Entering.
07:37:20.403 [8507] <4> createdbdir: Creating NetBackup transaction log file in: /usr/openv/db/data
07:37:20.403 [8507] <4> createdbdir: Exiting with rc = 0
07:37:20.403 [8507] <4> createdbdir: Entering.
07:37:20.403 [8507] <4> createdbdir: Creating NetBackup staging directory in: /usr/openv/db/staging
07:37:20.403 [8507] <4> createdbdir: Creating /usr/openv/db/staging
07:37:20.403 [8507] <4> createdbdir: Exiting with rc = 0
07:37:20.403 [8507] <4> run_nbdb_cmd: Entering.
07:37:20.404 [8507] <4> run_nbdb_cmd: Running . /usr/openv/db/vxdbms_env.sh && "/usr/openv/db/bin/dbinit" -q -b -c -z UTF8 -p 4096 -t "/usr/openv/db/data/NBDB.log" "/usr/openv/db/data/NBDB.db" >/dev/null 2>/dev/null
07:37:35.854 [8507] <4> run_nbdb_cmd: . /usr/openv/db/vxdbms_env.sh && "/usr/openv/db/bin/dbinit" -q -b -c -z UTF8 -p 4096 -t "/usr/openv/db/data/NBDB.log" "/usr/openv/db/data/NBDB.db" >/dev/null 2>/dev/null successful.
07:37:35.854 [8507] <4> run_nbdb_cmd: Exiting with rc = 0
07:37:35.860 [8507] <16> ReadVxDBMS_ConfFile: Can't open configuration file:  /usr/openv/db/data/vxdbms.conf
07:37:35.860 [8507] <4> UpdateSettinginHostConfig: Entering.
07:37:35.947 [8507] <2> WriteConfigFile: Param = SERVER, modified = 0
07:37:35.947 [8507] <2> WriteConfigFile: Copying = SERVER entry
07:37:35.947 [8507] <2> WriteConfigFile: Param = CLIENT_NAME, modified = 0
07:37:35.947 [8507] <2> WriteConfigFile: Copying = CLIENT_NAME entry
07:37:35.947 [8507] <2> WriteConfigFile: Param = USE_VXSS, modified = 0
07:37:35.947 [8507] <2> WriteConfigFile: Copying = USE_VXSS entry
07:37:35.948 [8507] <2> WriteConfigFile: Param = VXSS_SERVICE_TYPE, modified = 0
07:37:35.948 [8507] <2> WriteConfigFile: Copying = VXSS_SERVICE_TYPE entry
07:37:35.948 [8507] <2> WriteConfigFile: Param = EMMSERVER, modified = 0
07:37:35.948 [8507] <2> WriteConfigFile: Copying = EMMSERVER entry
07:37:35.950 [8507] <2> WriteConfigFile: Adding VXDBMS_NB_DATA
07:37:35.951 [8507] <2> UpdateLocalHostConfig: UpdateConfigFile completed <0>
07:37:35.951 [8507] <4> UpdateSettinginHostConfig: Exiting with rc = 0
07:37:35.953 [8507] <4> createdb: Starting the NetBackup database.
07:37:35.953 [8507] <4> startup_nb_databases: Starting up ASA locally on srvsback01
07:37:36.130 [8507] <4> create_util_db_file: Creating /usr/openv/db/bin/util_db.ini
07:37:36.159 [8507] <16> startup_nb_databases: ODBC connection failed.
07:37:36.159 [8507] <16> startup_nb_databases: ErrMsg [Sybase][ODBC Driver][SQL Anywhere]Unable to start specified database: unable to start database "utility_db", ErrCode -1, Sqlstate 08001
07:37:36.159 [8507] <4> startup_nb_databases: Removing /usr/openv/db/bin/util_db.ini
07:37:36.165 [8507] <4> createdb: Database [NBDB] can't be started on server [NB_srvsback01].
07:37:36.165 [8507] <4> create_nbdb_dbspaces: Creating the NetBackup database files.
07:37:36.165 [8507] <4> run_sql_script: Entering.
07:37:36.166 [8507] <4> run_sql_script: Running . /usr/openv/db/vxdbms_env.sh && "/usr/openv/db/bin/dbisqlc"  -q -nogui -c "CS=utf8;UID=dba;PWD=******;LINKS=shmem,tcpip{PORT=13785};ENG=NB_srvsback01;DBN=NBDB" "/usr/openv/db/scripts/create_nbdbspaces.sql" >"/usr/openv/db/scripts/create_nbdbspaces.sql.log"
07:37:36.592 [8507] <16> NBDBsystem: System call failed with status: 1024
07:37:36.592 [8507] <16> run_sql_script: . /usr/openv/db/vxdbms_env.sh && "/usr/openv/db/bin/dbisqlc"  -q -nogui -c "CS=utf8;UID=dba;PWD=******;LINKS=shmem,tcpip{PORT=13785};ENG=NB_srvsback01;DBN=NBDB" "/usr/openv/db/scripts/create_nbdbspaces.sql" >"/usr/openv/db/scripts/create_nbdbspaces.sql.log" failed.
07:37:36.592 [8507] <4> run_sql_script: Exiting with rc = 77
07:37:36.592 [8507] <4> createdb: Exiting with rc = 77
07:37:36.592 [8507] <4> create_nbdb: Exiting with rc = 77


I
  • if fact was more funny : a server with same db name (i am preparing a db restore) was existing on the subnet and sybase anywhere was trying to contact it instead of creating locally... solution has been to install on console port with ethernet disabled 
  • There seems to be no reference to user name in nbdb log. The message might be a red herring.

    The 1st error in this log is the following:
    <16> ReadVxDBMS_ConfFile: Can't open configuration file:  /usr/openv/db/data/vxdbms.conf

    After this, the installation process seems to create the config file and exists with status 0:
    07:37:35.951 [8507] <2> UpdateLocalHostConfig: UpdateConfigFile completed <0>
    07:37:35.951 [8507] <4> UpdateSettinginHostConfig: Exiting with rc = 0

    The startup of the database seem to be the problem:
    07:37:36.159 [8507] <16> startup_nb_databases: ODBC connection failed.
    07:37:36.159 [8507] <16> startup_nb_databases: ErrMsg [Sybase][ODBC Driver][SQL Anywhere]Unable to start specified database: unable to start database "utility_db", ErrCode -1, Sqlstate 08001

    We have successfully installed NBU7 on a test  Solaris 10 server after carefully reading and complying with requirements in the Installation Guide.
    Extract reflecting some of the requirements (more in Installation Guide):

    ■ Master and media servers in a production environment with several database agents enabled, should have a minimum of 2 GB of memory each.

    Special guidelines for Solaris systems:
    The following examples show how you may need to modify certain parameters for Solaris 10 systems:
    Message Queue parameters:
    ■ It may be necessary to increase the system’s message queue resources to avoid having NetBackup daemons hang.
    For example, you may need to edit the /etc/system file to include or change the following parameters:
    set msgsys:msginfo_msgmap=512
    set msgsys:msginfo_msgmax=8192
    set msgsys:msginfo_msgmnb=65536
    set msgsys:msginfo_msgmni=256
    set msgsys:msginfo_msgssz=16
    set msgsys:msginfo_msgtql=512
    set msgsys:msginfo_msgseg=8192
    After editing the file, you must reboot the NetBackup server.

    Semaphore parameters
    ■ You must allocate enough semaphores on UNIX systems, or errors may occur. System requirements vary, but the following changes to the /etc/system file should be sufficient for an average system:
    set semsys:seminfo_semmap=64
    set semsys:seminfo_semmni=1024
    set semsys:seminfo_semmns=1024
    set semsys:seminfo_semmnu=1024
    set semsys:seminfo_semmsl=300
    set semsys:seminfo_semopm=32
    set semsys:seminfo_semume=64
    After editing the file, you must reboot the NetBackup server.



  • I have a very similar config, even a bit higher, it is also recommended to disable tcp_fusion in case of multiple nics
    * Added for NetBackup
    * Message queues
    set msgsys:msginfo_msgmap=500
    set msgsys:msginfo_msgmax=8192
    set msgsys:msginfo_msgmnb=65536
    set msgsys:msginfo_msgmni=1024
    set msgsys:msginfo_msgssz=32
    set msgsys:msginfo_msgtql=1024
    set msgsys:msginfo_msgseg=8192

    * Semaphores
    set semsys:seminfo_semmap=64
    set semsys:seminfo_semmni=2048
    set semsys:seminfo_semmns=2048
    set semsys:seminfo_semmnu=1024
    set semsys:seminfo_semmsl=300
    set semsys:seminfo_semopm=128
    set semsys:seminfo_semume=64

    set ip:do_tcp_fusion = 0
    set ip:ip_soft_rings_cnt=8


    I am installing a 6.5 to upgrade to 7.0 ... will see



  • Any "funny" permissions around /usr/openv/db or its subdirectories?

    (It's not a link to some NFS mount somewhere else, I trust!) 

    How big is /usr?  Not 100% full, is it?

    Your errors just give me a "something not right with that file system" vibe.
  • if fact was more funny : a server with same db name (i am preparing a db restore) was existing on the subnet and sybase anywhere was trying to contact it instead of creating locally... solution has been to install on console port with ethernet disabled