Skip to Content

SAP HANA Database not start

Hi,

We have installed a Suse linux Enterprise Server for SAP Application 12 SP1 on a virtual machne (vmware vsphere infrustructure).

VM Characteristics:

Disks:

40 GB OS

16 GB Swap

200 GB Database files

30 GB Logs

35 GB fro sap files

RAM 196 GB

vCPUs: 2 soccets with 6 vcores each

We have installed SAP HANA using SP HANA platform Edition 1.0 SPS12 (SAP HANA DB 1.00.121.0). After installation we have installed on same machine SAP HANA client and SAP HANA studio. SAP HANA studio connected succesfully to SAP HANA Database.

After the succefull connection we have restarted the server (Virtual Machine).

After restart we have run the command "sapcontrol -nr 00 function Start" succefully.

When we are trying to run the commend "HDB start" we get the following error:

FAIL: process hdbdeamon HDB Deamon not running

We can't connect to SAP HANA database (with for example sap HANA studio).

How can we find and resolve the issue.

We want to install SAP ERP on this SAP HANA server.

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jul 25, 2016 at 06:40 AM

    Hi I have found the following in nameserver_<hostname> trace file:

    ============================================================================

    [8818]{-1}[-1/-1] 2016-07-25 08:46:28.770620 i Basis TraceStream.cpp(00467) : ==== Starting hdbnameserver, version 1.00.121.00.1466466057 (fa/hana1sp12), build linuxx86_64 c2be2aaf4b39603589c0db86f2d769302d2b15de 2016-06-21 01:54:21 ld7272 gcc (SAP release 20151217, based on SUSE gcc48-4.8.5-24.1) 4.8.5

    [8818]{-1}[-1/-1] 2016-07-25 08:46:28.770968 i Basis TraceStream.cpp(00469) : MaxOpenFiles: 1048576

    [8818]{-1}[-1/-1] 2016-07-25 08:46:28.770973 i Basis TraceStream.cpp(00471) : Server Mode: L2 Delta

    [8818]{-1}[-1/-1] 2016-07-25 08:46:28.770988 i Basis ProcessorInfo.cpp(00733) : Using GDT segment limit to determine current CPU ID

    [8818]{-1}[-1/-1] 2016-07-25 08:46:28.770989 i Basis Timer.cpp(00642) : Using RDTSC for HR timer

    [8818]{-1}[-1/-1] 2016-07-25 08:46:28.770991 i Memory AllocatorImpl.cpp(00481) : Allocators activated

    [8818]{-1}[-1/-1] 2016-07-25 08:46:28.770993 i Memory AllocatorImpl.cpp(00497) : Using big block segment size 268435456

    [8835]{-1}[-1/-1] 2016-07-25 08:46:29.006809 i assign TREXNameServer.cpp(02144) : assign as master nameserver. assign to volume 1 started

    [8835]{-1}[-1/-1] 2016-07-25 08:46:29.008504 w FileIO FileSystem.cpp(00103) : Unknown file system "rootfs" for "/usr/sap/HN1/SYS/global/hdb/backint/"

    [8835]{-1}[-1/-1] 2016-07-25 08:46:29.008575 i FileIO FileStatistics.cpp(00357) : FileFactoryConfiguration::initial(path="/usr/sap/HN1/SYS/global/hdb/backint/"[DATA_BACKUP], async_write_submit_active=auto,async_write_submit_blocks=all,async_read_submit=on,num_submit_queues=1,num_completion_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64,min_submit_batch_size=16,max_submit_batch_size=64)

    [8835]{-1}[-1/-1] 2016-07-25 08:46:29.008656 i FileIO FileStatistics.cpp(01159) : SubmitQueueConfiguration::initial(path="/usr/sap/HN1/SYS/global/hdb/backint/"[DATA_BACKUP], num_submit_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64,min_submit_batch_size=16,max_submit_batch_size=64)

    [8835]{-1}[-1/-1] 2016-07-25 08:46:29.009156 i FileIO FileStatistics.cpp(01370) : CompletionQueueConfiguration::initial(path="/usr/sap/HN1/SYS/global/hdb/backint/"[DATA_BACKUP], num_completion_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64)

    [8835]{-1}[-1/-1] 2016-07-25 08:46:29.009713 i FileIO FileStatistics.cpp(00357) : FileFactoryConfiguration::initial(path="/usr/sap/HN1/SYS/global/hdb/backint/"[LOG_BACKUP], async_write_submit_active=auto,async_write_submit_blocks=all,async_read_submit=on,num_submit_queues=1,num_completion_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64,min_submit_batch_size=16,max_submit_batch_size=64)

    [8835]{-1}[-1/-1] 2016-07-25 08:46:29.009773 i FileIO FileStatistics.cpp(01159) : SubmitQueueConfiguration::initial(path="/usr/sap/HN1/SYS/global/hdb/backint/"[LOG_BACKUP], num_submit_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64,min_submit_batch_size=16,max_submit_batch_size=64)

    [8835]{-1}[-1/-1] 2016-07-25 08:46:29.010266 i FileIO FileStatistics.cpp(01370) : CompletionQueueConfiguration::initial(path="/usr/sap/HN1/SYS/global/hdb/backint/"[LOG_BACKUP], num_completion_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64)

    [8835]{-1}[-1/-1] 2016-07-25 08:46:29.012744 f topology Topology.cpp(00265) : persistence does not exist @ /run/media/root/1c8c39cb-5184-48f0-8f65-2049cf1ea3e8/hana/data/HN1/mnt00001/hdb00001/

    [8835]{-1}[-1/-1] 2016-07-25 08:46:29.012833 f NameServer TREXNameServer.cpp(03884) : persistence initialization failed -> stopping instance ...

    [8818]{-1}[-1/-1] 2016-07-25 08:46:29.013166 i Service_Shutdown TrexService.cpp(00803) : Preparing for shutting service down

    [8835]{-1}[-1/-1] 2016-07-25 08:46:29.016061 e Basis TREXNameServer.cpp(03917) : Process exited due to an error via explicit exit call with exit code 1 , no crash dump will be written

    [8844]{-1}[-1/-1] 2016-07-25 08:46:29.018104 i assign TREXNameServer.cpp(03540) : shutdown, unassign from volume 1

    [8844]{-1}[-1/-1] 2016-07-25 08:46:29.018231 i failover TREXNameServer.cpp(04532) : setinactive(saphn1) but no failover manager

    ============================================================================

    I searched and I found that the path:

    /run/media/root/1c8c39cb-5184-48f0-8f65-2049cf1ea3e8/hana/data/HN1/mnt00001/hdb00001/

    exists on server.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 24, 2016 at 08:19 PM

    Hello Stalianos,

    If you can connect using Hana Studio check the latest diagnosis files. There should be some errors in diagnosis files.

    What are the statuses of the services? Which ones are green?

    If you cannot connect using HANA Studio can you check the latest files in "/usr/sap/<SID>/HDB<nn>/<hostname>/trace" folder.

    You can attacht the erronous files to this discussion.

    Regards,

    Yuksel AKCINAR

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.