Skip to Content
0
Former Member
Jul 05, 2016 at 08:17 AM

How to start sapstartsrv and sapstart?

8096 Views

Hello experts,

I have a problem regarding start sap after I changed the IP's for HANA Instance and ECC APP server Instance.

First of all I checked firewalls to be disabled and I maintained the new IPs to /etc/host . The PING works between HANA OS and ECC OS and I can to connect to HDB with HANA Studio.

But when I run with <SID>adm the command startsap all pf=/usr/sap/HD1/profile/HD1_DVEBMGS00_awssap1 I receive the following message:

Database db must be started first

Log on to remote server and start database

How should I start sap in this case?

Best regards,

Teodor

This is the trans.log file

awssap1:hd1adm 21> cat trans.log

4 ETW000 R3trans version 6.25 (release 742 - 11.02.15 - 14:06:42).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 05.07.2016 - 07:29:46

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [ dev trc,00000] Tue Jul 5 07:29:46 2016 36 0.000036

4 ETW000 [ dev trc,00000] db_con_init called 10 0.000046

4 ETW000 [ dev trc,00000] set_use_ext_con_info(): usage of ssfs switched off (rsdb/ssfs_connect=0)

4 ETW000 13 0.000059

4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 7 0.000066

4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 7 0.000073

4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/HD1/SYS/exe/run/dbhdbslib.so' ... 16 0.000089

4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/HD1/SYS/exe/run/dbhdbslib.so"), hdl 0, count 1, addr 1de1530

4 ETW000 3672 0.003761

4 ETW000 [ dev trc,00000] Library '/usr/sap/HD1/SYS/exe/run/dbhdbslib.so' loaded 11 0.003772

4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/HD1/SYS/exe/run/dbhdbslib.so

4 ETW000 10 0.003782

4 ETW000 [ dev trc,00000] Version of '/usr/sap/HD1/SYS/exe/run/dbhdbslib.so' is "742.06", patchlevel (0.38)

4 ETW000 42 0.003824

4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/HD1/SYS/exe/run/dbhdbslib.so

4 ETW000 9 0.003833

4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/HD1/SYS/exe/run/dbhdbslib.so

4 ETW000 16 0.003849

4 ETW000 [ dev trc,00000] } DbSlHDBControl(rc=0) 15 0.003864

4 ETW000 [ dev trc,00000] { DbSlHDBControl(con_hdl=-1,command=39,arg_p=(nil)) 7 0.003871

4 ETW000 [ dev trc,00000] } DbSlHDBControl(rc=0) 6 0.003877

4 ETW000 [ dev trc,00000] { DbSlHDBControl(con_hdl=-1,command=10,arg_p=7fff37dc0500) 7 0.003884

4 ETW000 [ dev trc,00000] } DbSlHDBControl(rc=0) 5 0.003889

4 ETW000 [ dev trc,00000] New connection 0 created 5 0.003894

4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , oc = 000, hc = NO , perm = YES, reco = NO , info = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000 19 0.003913

4 ETW000 [ dev trc,00000] { DbSlHDBControl(con_hdl=-1,command=10,arg_p=1896960) 11 0.003924

4 ETW000 [ dev trc,00000] } DbSlHDBControl(rc=0) 5 0.003929

4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 5 0.003934

4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 16 0.003950

4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 5 0.003955

4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , oc = 000, hc = NO , perm = YES, reco = NO , info = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000 11 0.003966

4 ETW000 [ dev trc,00000] { DbSlHDBConnect(con_info_p=(nil)) 21 0.003987

4 ETW000 [ dev trc,00000] DBHDBSLIB : version 742.06, patch 0.038 (Make PL 0.101) 12 0.003999

4 ETW000 [ dev trc,00000] HDB shared library (dbhdbslib) patchlevels (last 10) 8 0.004007

4 ETW000 [ dev trc,00000] (0.038) Close all result sets (note 2124493) 8 0.004015

4 ETW000 [ dev trc,00000] (0.038) Initialization of deferred LOB writing for ZDO changed (note 2106186)

4 ETW000 10 0.004025

4 ETW000 [ dev trc,00000] (0.032) DBSL supports deferred lob writing with HANA SP9 (note 2106186)

4 ETW000 11 0.004036

4 ETW000 [ dev trc,00000] (0.031) Read last SQL message after the connection is closed (note 2104804)

4 ETW000 11 0.004047

4 ETW000 [ dev trc,00000] (0.031) Check Enable_Select_Into_Scalar_UDF before the ALTER call (note 2105480)

4 ETW000 9 0.004056

4 ETW000 [ dev trc,00000] (0.029) Certain SAP applications hang for several minutes (note 888312)

4 ETW000 9 0.004065

4 ETW000 [ dev trc,00000] (0.029) Structure DBSL_CA initialized (note 2094457) 8 0.004073

4 ETW000 [ dev trc,00000] (0.027) Data aging for the service connection (note 2090613) 7 0.004080

4 ETW000 [ dev trc,00000] (0.026) Use prepared statements for R3szchk (note 1952609) 7 0.004087

4 ETW000 [ dev trc,00000] (0.025) Use bulk fetch on a result set of a procedure call (note 2082661)

4 ETW000 9 0.004096

4 ETW000 [ dev trc,00000] 4 0.004100

4 ETW000 [ dev trc,00000] -> init() 8 0.004108

4 ETW000 [ dev trc,00000] STATEMENT_CACHE_SIZE = 1000 28 0.004136

4 ETW000 [ dev trc,00000] -> init() 389 0.004525

4 ETW000 [ dev trc,00000] -> loadClientRuntime() 8 0.004533

4 ETW000 [ dev trc,00000] Loading SQLDBC client runtime ... 6 0.004539

4 ETW000 [ dev trc,00000] SQLDBC Module : /usr/sap/HD1/hdbclient/libSQLDBCHDB.so 2465 0.007004

4 ETW000 [ dev trc,00000] SQLDBC Runtime : libSQLDBCHDB 1.00.097.00 Build 1434028111-1530 31 0.007035

4 ETW000 [ dev trc,00000] SQLDBC client runtime is 1.00.097.00.1434028111 13 0.007048

4 ETW000 [ dev trc,00000] -> quiesceConnection() 7 0.007055

4 ETW000 [ dev trc,00000] -> getNewConnection() 7 0.007062

4 ETW000 [ dev trc,00000] <- getNewConnection(con_hdl=0) 37 0.007099

4 ETW000 [ dev trc,00000] -> checkEnvironment(con_hdl=0) 11 0.007110

4 ETW000 [ dev trc,00000] -> connect(con_info_p=(nil)) 12 0.007122

4 ETW000 [ dev trc,00000] Try to connect via secure store (DEFAULT) on connection 0 ... 23 0.007145

4 ETW000 [ dev trc,00000] Tue Jul 5 07:29:49 2016 3003044 3.010189

4 ETW000 [dbhdbsql.cpp,00000] *** ERROR => Connect to database failed, rc=1, rcSQL=-10709 25 3.010214

4 ETW000 [ dev trc,00000] SQLCODE : -10709 11 3.010225

4 ETW000 [ dev trc,00000] SQLERRTEXT : Connection failed (RTE:[89006] System call 'connect' failed, rc=113:No route to host)

4 ETW000 10 3.010235

4 ETW000 [ dev trc,00000] -> SetSdbDbslCA(errcode=-10709) 8 3.010243

4 ETW000 [ dev trc,00000] -> freeConnection(con_hdl=0) 15 3.010258

4 ETW000 [ dev trc,00000] close all opened locators of connection 0 8 3.010266

4 ETW000 [ dev trc,00000] } DbSlHDBConnect(rc=99) 26 3.010292

4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error -10709 performing CON 28 3.010320

4 ETW000 [ dblink ,00000] ***LOG BY0=>Connection failed (RTE:[89006] System call 'connect' failed, rc=113:No route to host)

4 ETW000 11 3.010331

4 ETW000 [ dev trc,00000] { DbSlHDBControl(con_hdl=0,command=41,arg_p=d774d8) 20 3.010351

4 ETW000 [ dev trc,00000] } DbSlHDBControl(rc=0) 11 3.010362

4 ETW000 [ dev trc,00000] { DbSlHDBControl(con_hdl=0,command=14,arg_p=7fff37db6ef0) 10 3.010372

4 ETW000 [ dev trc,00000] } DbSlHDBControl(rc=0) 6 3.010378

4 ETW000 [ dev trc,00000] { DbSlHDBControl(con_hdl=0,command=50,arg_p=7fff37db6f08) 6 3.010384

4 ETW000 [ dev trc,00000] } DbSlHDBControl(rc=0) 13 3.010397

4 ETW000 [ dev trc,00000] { DbSlHDBControl(con_hdl=0,command=13,arg_p=7fff37db6e60) 9 3.010406

4 ETW000 [ dev trc,00000] } DbSlHDBControl(rc=0) 7 3.010413

4 ETW000 [ dev trc,00000] { DbSlHDBControl(con_hdl=0,command=52,arg_p=7fff37db6eb0) 8 3.010421

4 ETW000 [ dev trc,00000] } DbSlHDBControl(rc=0) 9 3.010430

2EETW169 no connect possible: "DBMS = HDB --- SERVER = '' PORT = ''"

4 ETW000 [ dev trc,00000] release memory of the SIBU buffers 61 3.010491

4 ETW000 [ dev trc,00000] release memory of the STATEMENT CACHE 11 3.010502

awssap1:hd1adm 22> startsap all pf=/usr/sap/HD1/profile/HD1_DVEBMGS00_awssap1

Database db must be started first

Log on to remote server and start database