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