cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot find startdb, DB startup failed

Former Member
0 Kudos

Hi experts,

I am able to HDB start but unable to stratsap my S/4HANA system due to error cannot find startdb, DB startup failed.

Please help.

dellsaphana01:hdbadm 51> HDB start

StartService

Impromptu CCC initialization by 'rscpCInit'.

  See SAP note 1266393.

OK

OK

Starting instance using: /usr/sap/HDB/SYS/exe/hdb/sapcontrol -prot NI_HTTP -nr 02 -function StartWait 2700 2

07.09.2016 14:39:43

Start

OK

07.09.2016 14:39:53

StartWait

OK

dellsaphana01:hdbadm 52> HDB info

USER       PID  PPID %CPU    VSZ   RSS COMMAND

hdbadm   25917 25916  1.0  14372  3132 -csh

hdbadm   26056 25917  0.0  12900  1744  \_ /bin/sh /usr/sap/HDB/HDB02/HDB info

hdbadm   26079 26056  0.0   4948   876      \_ ps fx -U hdbadm -o user,pid,ppid,

hdbadm   23301 23300  0.0  14372  3128 -csh

root     23459 23301  0.0  54332  1796  \_ su - root

hdbadm    4107     1  0.0  22084  1572 sapstart pf=/usr/sap/HDB/SYS/profile/HDB_

hdbadm    4423  4107  0.0 483668 287948  \_ /usr/sap/HDB/HDB02/dellsaphana01/tra

hdbadm    4573  4423  0.4 8011972 1223004      \_ hdbnameserver

hdbadm    4660  4423  0.9 7274224 1846312      \_ hdbcompileserver

hdbadm    4662  4423  0.2 4374160 384916      \_ hdbpreprocessor

hdbadm    4688  4423 25.3 89152668 84984228      \_ hdbindexserver

hdbadm    4690  4423  0.6 8056232 1439752      \_ hdbxsengine

hdbadm    5108  4423  0.2 7329380 454524      \_ hdbwebdispatcher

hdbadm    3740     1  0.0 165168 22084 /usr/sap/HDB/HDB02/exe/sapstartsrv pf=/us

dellsaphana01:hdbadm 53> whoami

hdbadm

dellsaphana01:hdbadm 55> su - root

Password:

Directory: /root

Wed Sep  7 14:46:58 SGT 2016

dellsaphana01:~ # startsap

If 'startsap' is not a typo you can run the following command to lookup the package that contains the binary:

    command-not-found startsap

-bash: startsap: command not found

dellsaphana01:~ # su - s4hadm

dellsaphana01:s4hadm 51> startsap

^CChecking HDB Database

Database is not available via R3trans

-------------------------------------------

Cannot find startdb, DB startup failed

please send the tracefile /home/s4hadm/startsap.trc to support

dellsaphana01:s4hadm 52>

dellsaphana01:s4hadm 52> cd /home/s4hadm

dellsaphana01:s4hadm 53> cat startsap.trc

Trace of system startup/check of SAP System S4H on Wed Sep  7 14:49:43 SGT 2016

{14:49:43 ## Main() start: @=/usr/sap/S4H/SYS/exe/uc/linuxx86_64/startsap

@(#) $Id: //bas/745_REL/src/krn/startscripts/startsap#1 $

BASENAME=startsap

{14:49:43 ## check_user() start: @=s4hadm

}14:49:43 ## check_user() done

#=0

@=

{14:49:43 ## setPlatform() start

  PLATFORM=linuxx86_64

}14:49:43 ## setPlatform() done

{14:49:43 ## setPing() start

  PING=/bin/ping

}14:49:43 ## setPing() done

{14:49:43 ## setIfconfig() start

  IFCONFIG=/sbin/ifconfig

}14:49:43 ## setIfconfig() done

{14:49:43 ## setIp() start

  IP=/sbin/ip

}14:49:43 ## setIp() done

{14:49:43 ## setRootDir() start: @=

  USR_SAP=/usr/sap

  USR_SAP_SID=/usr/sap/S4H

  PROFILE_DIR=/usr/sap/S4H/SYS/profile

  DIR_LIBRARY=/usr/sap/S4H/SYS/exe/run

}14:49:43 ## setRootDir() done

{14:49:43 ## setDbUser() start: @=

}14:49:44 ## setDbUser() done

{14:49:44 ## setVHostArray() start

  _PROFILES=/usr/sap/S4H/SYS/profile/S4H_ASCS01_dellsaphana01 /usr/sap/S4H/SYS/profile/S4H_ASCS01_vhcals4hcs /usr/sap/S4H/SYS/profile/S4H_D10_dellsaphana01 /usr/sap/S4H/SYS/profile/S4H_D10_dellsaphana01.1 /usr/sap/S4H/SYS/profile/S4H_D10_dellsaphana01.2 /usr/sap/S4H/SYS/profile/S4H_D10_dellsaphana01.3

  _nrProfiles=6

  {14:49:44 ## pushVHostsFromProfile() start: @=/usr/sap/S4H/SYS/profile/S4H_ASCS01_dellsaphana01 /usr/sap/S4H/SYS/profile/S4H_ASCS01_vhcals4hcs /usr/sap/S4H/SYS/profile/S4H_D10_dellsaphana01 /usr/sap/S4H/SYS/profile/S4H_D10_dellsaphana01.1 /usr/sap/S4H/SYS/profile/S4H_D10_dellsaphana01.2 /usr/sap/S4H/SYS/profile/S4H_D10_dellsaphana01.3

   _DUMMY=S4H_ASCS01_dellsaphana01

   _VHOST=dellsaphana01

   {14:49:44 ## isVHostLocal() start: dellsaphana01

    VHOST=dellsaphana01

    _IS_LOCAL=1

   }14:49:44 ## isVHostLocal() done: 1

   _DUMMY=S4H_ASCS01_vhcals4hcs

   _VHOST=vhcals4hcs

   {14:49:44 ## isVHostLocal() start: vhcals4hcs

    VHOST=vhcals4hcs

    _IS_LOCAL=0

   }14:49:54 ## isVHostLocal() done: 0

   _DUMMY=S4H_D10_dellsaphana01

   _VHOST=dellsaphana01

   {14:49:54 ## isVHostLocal() start: dellsaphana01

    VHOST=dellsaphana01

    _IS_LOCAL=1

   }14:49:54 ## isVHostLocal() done: 1

   _DUMMY=S4H_D10_dellsaphana01.1

   _VHOST=dellsaphana01.1

   {14:49:54 ## isVHostLocal() start: dellsaphana01.1

    VHOST=dellsaphana01.1

    _IS_LOCAL=0

   }14:50:04 ## isVHostLocal() done: 0

   _DUMMY=S4H_D10_dellsaphana01.2

   _VHOST=dellsaphana01.2

   {14:50:04 ## isVHostLocal() start: dellsaphana01.2

    VHOST=dellsaphana01.2

    _IS_LOCAL=0

   }14:50:14 ## isVHostLocal() done: 0

   _DUMMY=S4H_D10_dellsaphana01.3

   _VHOST=dellsaphana01.3

   {14:50:14 ## isVHostLocal() start: dellsaphana01.3

    VHOST=dellsaphana01.3

    _IS_LOCAL=0

   }14:50:18 ## isVHostLocal() done: 0

   VHOSTS= dellsaphana01

  }14:50:18 ## pushVHostsFromProfile() done

  VHOSTS= dellsaphana01

}14:50:18 ## setVHostArray() done

{14:50:18 ## set_instance() start

  _PROFILES=/usr/sap/S4H/SYS/profile/S4H_SCS??_dellsaphana01

  _nrProfiles=1

  _Iset_instance=SCS

  {14:50:18 ## pushProfiles() start: @=SCS /usr/sap/S4H/SYS/profile/S4H_SCS??_dellsaphana01

   _TEMPINST=SCS??

  }14:50:18 ## pushProfiles() done

  _PROFILES=/usr/sap/S4H/SYS/profile/S4H_ASCS01_dellsaphana01

  _nrProfiles=1

  _Iset_instance=ASCS

  {14:50:19 ## pushProfiles() start: @=ASCS /usr/sap/S4H/SYS/profile/S4H_ASCS01_dellsaphana01

   _TEMPINST=ASCS01

   {14:50:19 ## setInstanceDo() start: @=ASCS01 /usr/sap/S4H/SYS/profile/S4H_ASCS01_dellsaphana01:

    setInstanceDo: INSTascs=ASCS01:

    setInstanceDo: PROFILEascs=/usr/sap/S4H/SYS/profile/S4H_ASCS01_dellsaphana01:

    setInstanceDo: INST=ASCS01:

    setInstanceDo: INSTFOUND=1:

   }14:50:19 ## setInstanceDo() done: 1:

  }14:50:19 ## pushProfiles() done

  _PROFILES=/usr/sap/S4H/SYS/profile/S4H_ERS??_dellsaphana01

  _nrProfiles=1

  _Iset_instance=ERS

  {14:50:19 ## pushProfiles() start: @=ERS /usr/sap/S4H/SYS/profile/S4H_ERS??_dellsaphana01

   _TEMPINST=ERS??

  }14:50:19 ## pushProfiles() done

  _PROFILES=/usr/sap/S4H/SYS/profile/S4H_SMDA??_dellsaphana01

  _nrProfiles=1

  _Iset_instance=SMDA

  {14:50:19 ## pushProfiles() start: @=SMDA /usr/sap/S4H/SYS/profile/S4H_SMDA??_dellsaphana01

   _TEMPINST=SMDA??

  }14:50:19 ## pushProfiles() done

  _PROFILES=/usr/sap/S4H/SYS/profile/S4H_D?*??_dellsaphana01

  _nrProfiles=1

  _Iset_instance=D?*

  {14:50:19 ## pushProfiles() start: @=D?* /usr/sap/S4H/SYS/profile/S4H_D?*??_dellsaphana01

   _TEMPINST=D?*??

  }14:50:19 ## pushProfiles() done

  _PROFILES=/usr/sap/S4H/SYS/profile/S4H_JC??_dellsaphana01

  _nrProfiles=1

  _Iset_instance=JC

  {14:50:19 ## pushProfiles() start: @=JC /usr/sap/S4H/SYS/profile/S4H_JC??_dellsaphana01

   _TEMPINST=JC??

  }14:50:19 ## pushProfiles() done

  _PROFILES=/usr/sap/S4H/SYS/profile/S4H_D10_dellsaphana01

  _nrProfiles=1

  _Iset_instance=D

  {14:50:19 ## pushProfiles() start: @=D /usr/sap/S4H/SYS/profile/S4H_D10_dellsaphana01

   _TEMPINST=D10

   {14:50:19 ## setInstanceDo() start: @=D10 /usr/sap/S4H/SYS/profile/S4H_D10_dellsaphana01:

    setInstanceDo: INSTd=D10:

    setInstanceDo: PROFILEd=/usr/sap/S4H/SYS/profile/S4H_D10_dellsaphana01:

    setInstanceDo: INST=D10:

    setInstanceDo: INSTFOUND=2:

   }14:50:19 ## setInstanceDo() done: 2:

  }14:50:19 ## pushProfiles() done

  _PROFILES=/usr/sap/S4H/SYS/profile/S4H_J??_dellsaphana01

  _nrProfiles=1

  _Iset_instance=J

  {14:50:19 ## pushProfiles() start: @=J /usr/sap/S4H/SYS/profile/S4H_J??_dellsaphana01

   _TEMPINST=J??

  }14:50:19 ## pushProfiles() done

  _PROFILES=/usr/sap/S4H/SYS/profile/S4H_JMS??_dellsaphana01

  _nrProfiles=1

  _Iset_instance=JMS

  {14:50:19 ## pushProfiles() start: @=JMS /usr/sap/S4H/SYS/profile/S4H_JMS??_dellsaphana01

   _TEMPINST=JMS??

  }14:50:19 ## pushProfiles() done

  _PROFILES=/usr/sap/S4H/SYS/profile/S4H_G??_dellsaphana01

  _nrProfiles=1

  _Iset_instance=G

  {14:50:19 ## pushProfiles() start: @=G /usr/sap/S4H/SYS/profile/S4H_G??_dellsaphana01

   _TEMPINST=G??

  }14:50:19 ## pushProfiles() done

  _PROFILES=/usr/sap/S4H/SYS/profile/S4H_TRX??_dellsaphana01

  _nrProfiles=1

  _Iset_instance=TRX

  {14:50:19 ## pushProfiles() start: @=TRX /usr/sap/S4H/SYS/profile/S4H_TRX??_dellsaphana01

   _TEMPINST=TRX??

  }14:50:19 ## pushProfiles() done

  _PROFILES=/usr/sap/S4H/SYS/profile/S4H_W??_dellsaphana01

  _nrProfiles=1

  _Iset_instance=W

  {14:50:19 ## pushProfiles() start: @=W /usr/sap/S4H/SYS/profile/S4H_W??_dellsaphana01

   _TEMPINST=W??

  }14:50:19 ## pushProfiles() done

  _PROFILES=/usr/sap/S4H/SYS/profile/S4H_V??_dellsaphana01

  _nrProfiles=1

  _Iset_instance=V

  {14:50:19 ## pushProfiles() start: @=V /usr/sap/S4H/SYS/profile/S4H_V??_dellsaphana01

   _TEMPINST=V??

  }14:50:19 ## pushProfiles() done

  NINST=

  INSTFOUND=2

  NINSTFOUND=0

  hasABAP=1

  hasJava=0

  hasSpecial=1

}14:50:20 ## set_instance() done

{14:50:20 ## prepare() start

  {14:50:20 ## set_sapdbhost() start

   _PROFILE=/usr/sap/S4H/SYS/profile/S4H_D10_dellsaphana01

   SAPDBHOST=dellsaphana01

  }14:50:20 ## set_sapdbhost() done

  {14:50:20 ## set_db_local() start

   VHOST=dellsaphana01

   set_dblocal: _DB_LOCAL=1

   SAPDBHOST=dellsaphana01

  }14:50:20 ## set_db_local() done: 1

  {14:50:20 ## set_db_sid() start: @=1

   DB_SID=HDB

  }14:50:20 ## set_db_sid() done

  {14:50:20 ## set_db_running() start

   Checking HDB Database

   {14:50:20 ## getExePath() start: @=R3trans D10

    {14:50:20 ## set_path() start: @=/usr/sap/S4H/D10/exe

     N_PATH=/usr/sap/S4H/D10/exe

     LD_LIBRARY_PATH=/usr/sap/S4H/D10/exe:/usr/sap/S4H/SYS/exe/run:/usr/sap/S4H/SYS/exe/uc/linuxx86_64:/usr/sap/S4H/SYS/exe/uc/linuxx86_64/hdbclient

     O_LD_LIBRARY_PATH=/usr/sap/S4H/SYS/exe/run:/usr/sap/S4H/SYS/exe/uc/linuxx86_64:/usr/sap/S4H/SYS/exe/uc/linuxx86_64/hdbclient

    }14:50:20 ## set_path() done

    _DIR_EXECUTABLE=/usr/sap/S4H/D10/exe

    {14:50:20 ## restore_path() start

     LD_LBRARY_PATH=/usr/sap/S4H/SYS/exe/run:/usr/sap/S4H/SYS/exe/uc/linuxx86_64:/usr/sap/S4H/SYS/exe/uc/linuxx86_64/hdbclient

    }14:50:20 ## restore_path() done

    EXEDIR=/usr/sap/S4H/D10/exe

    EXECMD=/usr/sap/S4H/D10/exe/R3trans

   }14:50:20 ## getExePath() done: 0

   DBCONNECT_TEST=/usr/sap/S4H/D10/exe/R3trans -d -w

   {14:50:20 ## set_path() start: @=/usr/sap/S4H/D10/exe

    N_PATH=/usr/sap/S4H/D10/exe

    LD_LIBRARY_PATH=/usr/sap/S4H/D10/exe:/usr/sap/S4H/SYS/exe/run:/usr/sap/S4H/SYS/exe/uc/linuxx86_64:/usr/sap/S4H/SYS/exe/uc/linuxx86_64/hdbclient

    O_LD_LIBRARY_PATH=/usr/sap/S4H/SYS/exe/run:/usr/sap/S4H/SYS/exe/uc/linuxx86_64:/usr/sap/S4H/SYS/exe/uc/linuxx86_64/hdbclient

   }14:50:20 ## set_path() done

   {14:50:20 ## restore_path() start

    LD_LBRARY_PATH=/usr/sap/S4H/SYS/exe/run:/usr/sap/S4H/SYS/exe/uc/linuxx86_64:/usr/sap/S4H/SYS/exe/uc/linuxx86_64/hdbclient

   }14:50:20 ## restore_path() done

   Database is not available via R3trans

   DB_RUNNING=0

   JDB_RUNNING=

  }14:50:20 ## set_db_running() done: 0

  {14:50:20 ## set_sapjdbhost() start

   SAPJDBHOST=

  }14:50:20 ## set_sapjdbhost() done

  {14:50:20 ## set_jdb_local() start

   VHOST=dellsaphana01

   set_jdb_local: _JDB_LOCAL=0

   SAPJDBHOST=

  }14:50:20 ## set_jdb_local() done: 0

  {14:50:20 ## set_jdb_running() start

   JDB_RUNNING=0

   _INST=

   _PROFILE=

   SAPSYSTEMNAME=S4H

  }14:50:20 ## set_jdb_running() done: 0

}14:50:20 ## prepare() done

DB_LOCAL=1

DB_RUNNING=0

hasABAP=1

hasJava=0

hasSpecial=1

TASK=ALL

{14:50:20 ## Database() start: @=start

  {14:50:20 ## getExePath() start: @=startdb

   EXEDIR=

   EXECMD=

  }14:50:20 ## getExePath() done: 1

Cannot find startdb, DB startup failed

Accepted Solutions (1)

Accepted Solutions (1)

former_member185239
Active Contributor
0 Kudos

Hi Zulfadzly,

Maintain the environment variable SAPDBHOST at OS level and then try to start the system.

With Regards

Ashutosh Chaturvedi

Former Member
0 Kudos

Hi,

Did you try with startsap r3 command? Check if that helps.

Also Check R3trans -d if it successful and attach the trans.log file.

Regards

Prithviraj

Former Member
0 Kudos

Thanks,

From trans.log, it shows that HANA DB temporary license was expired.

I have applied permanent license and HDB is now up and running.

Regards,

Fadzly Iqbal

Answers (1)

Answers (1)

0 Kudos

Hi Zulfadzly,

Please open HANA Studio -> SQL console and perform this from your systemDB:

alter system start database <database_name>;


I hope this can help you.


Regards,


Shinglon