Unable to start sap hana. -Startup of Instance failed-

[Former Member]

I can not start the sap hana, if you know better how to respond, please advise.

Error:

The following is the error log at startup.

Version:

SAP HANA SPS3 Rev.22

Background:

The phenomenon began to occur after failing to recover from. However, it might not matter.

/ Usr/sap/HN1/home/startsap_HDB00.log "contents.

Thursday, January 05 01:16:26 UTC Trace of system startup / check of SAP System HN1 on 2012


Called command: / usr/sap/HN1/SYS/exe/hdb/startsap HDB00

Starting SAP Instance HDB00
------------------------------
 Instance Service on host TECTKOSV043 started

SAP-R/3-Startup Program Rel 802 V2.0 (2008/11/15)
-------------------------------------------------

Starting at 2012/01/05 01:16:26
Startup Profile: "/ usr/sap/HN1/SYS/profile/HN1_HDB00_tectkosv043.tecnos.jp"

Setup Environment Variables
---------------------------
(8972) SETENV PATH = / usr/sap/HN1/HDB00/exe: / usr/sap/HN1/HDB00/tectkosv043.tecnos.jp: / usr/sap/HN1/HDB00: / usr/sap/HN1/HDB00 / exe: / usr/sap/HN1/HDB00/exe/Python/bin: / usr / local / bin: / bin: / usr / bin: / usr/bin/X11: / usr/X11R6/bin: / usr / games : / usr / lib / mit / bin: / usr / lib / mit / sbin: / opt / dell / srvadmin / bin: / usr / sap / tools / bin: / bin: / usr / bin: / usr / ucb: / sbin
(8972) SETENV SAP_RETRIEVAL_PATH = / usr/sap/HN1/HDB00/tectkosv043.tecnos.jp
(8972) SETENV PYTHONPATH = / usr/sap/HN1/HDB00/tectkosv043.tecnos.jp: / usr/sap/HN1/HDB00/exe: / usr/sap/HN1/SYS/global/hdb/custom/python_support: / usr/sap/HN1/HDB00/exe/python_support
(8972) SETENV DIR_LIBRARY = / usr/sap/HN1/HDB00/exe
(8972) SETENV LD_LIBRARY_PATH = / usr/sap/HN1/HDB00/exe: / usr/sap/HN1/HDB00/exe: / usr/sap/HN1/HDB00/exe: / usr/sap/HN1/HDB00/exe / Python / lib: / usr/sap/HN1/HDB00/exe/filter: / usr/sap/HN1/HDB00/exe/AFL
(8972) SETENV SHLIB_PATH = / usr/sap/HN1/HDB00/exe:
(8972) SETENV LIBPATH = / usr/sap/HN1/HDB00/exe:

Execute Pre-Startup Commands
----------------------------
(8973) Local: rm-f / usr/sap/HN1/HDB00/tectkosv043.tecnos.jp/trace/py.sapHN1_HDB00
(8974) Local: ln-s-f / usr/sap/HN1/HDB00/exe/Python/bin/python / usr/sap/HN1/HDB00/tectkosv043.tecnos.jp/trace/py.sapHN1_HDB00
(8975) Local: rm-f / usr/sap/HN1/HDB00/tectkosv043.tecnos.jp/trace/HDB.sapHN1_HDB00
(8976) Local: ln-s-f / usr/sap/HN1/HDB00/exe/hdbdaemon / usr/sap/HN1/HDB00/tectkosv043.tecnos.jp/trace/HDB.sapHN1_HDB00

Starting Programs
-----------------

05.01.2012 01:16:26
ShmDetach
OK
(8979) Starting: local / usr/sap/HN1/HDB00/tectkosv043.tecnos.jp/trace/HDB.sapHN1_HDB00-d-nw-f / usr/sap/HN1/HDB00/tectkosv043.tecnos.jp/daemon.ini pf = / usr/sap/HN1/SYS/profile/HN1_HDB00_tectkosv043.tecnos.jp
(8972) Waiting for Child Processes to terminate.
(8972) **** 2012/01/05 01:16:31 Child 8979 terminated with Status 0. ****
(8979) **** 2012/01/05 01:16:31 No RestartProgram command for program 2 ****
(8972) **** No more Child Processes to wait for.
(8972) Parent Shutdown at 2012/01/05 01:16:31

Execute Post-Shutdown Commands
------------------------------

05.01.2012 01:16:31
ShmDetach
OK
(8972) Exiting with Return-Code 3. (No more child processes)
 Startup of Instance failed

[Former Member]

I have "SQL file for recovery (recoverInstance.sql)" was deleted.

As a result, the problem was solved.

When I start the HANA, SQL file for recovery (recoverInstance.sql) will be referred to.

Considered to be able to start because it does not work properly SQL.

However, when the recovery "point in tme" If selected, an error cause is unknown.

[Former Member]

Hi,

Can you also try restarting by logging with <SID>adm user and giving following command(in csh shell):

> HDB start

regards, Rahul

[Former Member]

You must be on HANASVR-02, If so, I can assure you , will keep struggling with these issues!!!

[Former Member]

Dear All,

Where you can download the HANA IDES software ?

please provide me the link.

[Vitaliy-R]

There is no such a thing as HANA IDES currently. People on this thread are discussing Developer Sandbox - please have a look at www.experiencesaphana.com.

[Former Member]

This question is not related to the HANA developer center sandboxes - no user can stop/start these systems...

If the issue happened after a failed restore, your database is probably corrupted and cannot be started. Try to restore another backup. You can also try to restore the same backup again, and choose to not replay the log (recover from data files only). You will probably loose some changes, but at least have a consistent state...

--Juergen

[Former Member]

Hi, Rahul Pant .

Thanks for the message.

But I tried the method could not be resolved.

The result was the same.

[Former Member]

Hi,

Try this another way

Step 1. cd /usr/sap/HAN/exe/linuxx86_64/<your hanaveriosn eg HDB_>/

Step 2. ./sapcontrol -nr <yourinstance number eg 79> -function Start

Regards,

Manoj.

[Former Member]

Hi, Manoj4BWBODS.

Thanks for the message.

But I tried the method could not be resolved.

The result was the same.