cancel
Showing results for 
Search instead for 
Did you mean: 

SAP HANA Database not start

0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

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.

0 Kudos

Hi,

I changed "/run/media/root" folder permissions (chmod -R 777 root) and now HANA database starts.

If I reboot the server the "root" folder misses permissions !

Answers (1)

Answers (1)

yakcinar
Active Contributor
0 Kudos

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

jitendra_kumar01
Explorer
0 Kudos

Hi Stanianos,

Can you attach the nameserver and indexserver trace files and daemon_hostname.trc.

Regards

Jitendra