on 09-07-2016 8:27 AM
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
Hi Zulfadzly,
Maintain the environment variable SAPDBHOST at OS level and then try to start the system.
With Regards
Ashutosh Chaturvedi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.