cancel
Showing results for 
Search instead for 
Did you mean: 

Netbackup 7.0 Installation - SQL Problems

archie01
Not applicable

Hi, I have a fresh installation of NBU 7 on Solaris 10 x86 (2-node cluster). Installation is failing with SQL errors. Anyone else had this issue? Any help would be much appreciated.  

Installed SQL Anywhere Version 11.0.1.2279

Installation completed successfully
Database server is NB_elecnwmstr
Creating the NetBackup database.
Creating NetBackup data files in: /catalog/db/data
Creating NetBackup index files in: /catalog/db/data
Creating NetBackup transaction log file in: /catalog/db/data
Creating NetBackup staging directory in: /catalog/db/staging
Creating the NetBackup database files.
Creating the NetBackup EMM schema.
Error in file "/usr/openv/db/scripts/NBDB.sql" at line 23
Cannot drop or modify object 'DARS_Oracle_Datafile' because at least one other o bject ( MAT VIEW 'DARS_Oracle_Controlfile_Schema') depends upon it

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.

************************************************************

NBDB Log Errors:

15:56:17.816 [8136] <16> NBDBsystem: System call failed with status: 768
15:56:17.816 [8136] <16> run_nbdb_cmd: . /usr/openv/db/vxdbms_env.sh && "/usr/openv/db/bin/dbinit" -q -b -c -z UTF8 -p 4096 -t "/catalog/db/data/NBDB.log" "/catalog/db/data/NBDB.db" >/dev/null 2>/dev/null failed.
15:56:17.816 [8136] <4> run_nbdb_cmd: Exiting with rc = 77

15:56:18.111 [8136] <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_elecnwmstr;DBN=NBDB" "/usr/openv/db/scripts/NBDB.sql" >"/usr/openv/db/scripts/NBDB.sql.log"
15:56:18.336 [8136] <16> NBDBsystem: System call failed with status: 256
15:56:18.336 [8136] <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_elecnwmstr;DBN=NBDB" "/usr/openv/db/scripts/NBDB.sql" >"/usr/openv/db/scripts/NBDB.sql.log" failed.
15:56:18.336 [8136] <4> run_sql_script: Exiting with rc = 77
15:56:18.336 [8136] <4> createdb: Exiting with rc = 77
15:56:18.336 [8136] <4> create_nbdb: Exiting with rc = 77  

1 REPLY 1

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

A bit more background, please...

Which cluster sofware and version?

Are you trying to install a clustered master server?

Is 'elecnwmstr' the physical node name or the virtual name? If so, do you have /etc/hosts entry for the virtual ip and host name?

 

Please post the installation log (install_trace.####) under /usr/openv/tmp