locallhost 30015 [Connection refused] -813

[Former Member]

Hi All,

We have started testing on HANA server of Fujitsu.

In linux server when we add a system on SAP HANA Studio we receive the error message [cannot connect to host locallhost 30015 [Connection refused] -813.

When we execute GetProssessList command only hdbnameserver and hdbreprocessor are running.

Please advise

Best Regards

Vasilis Korolis

[AtulKumarJain · Accepted solution]

Hi Vassillis,

Please check the command hostname at os and provide the same hostname while doing connection.

And please make sure HANA is up and running .

BR

Atul

[Former Member · Accepted solution]

Hi Atul,

Thanks for your quick responce.

I checked the hostname by command which is correct.

How to check if the HANA is up and running? When I execute GetProssessList command only hdbnameserver and hdbreprocessor are running all other Prossess are RED. Is there any other way to test that the HANA is up and running? (I already Stop and Start SAP HANA from command line).

BR

Vasilis

[Trinidad · Accepted solution]

Hi,

You need all SAP HANA services running, specially hbdindexserver is very important.

Try to restart the HANA Linux server and see if all the services are running afterwards.

SAP HANA was preinstalled in your Linux appliance?

If not all services are running please create a ticket for support so they can check your SAP HANA installation.

Regards,

Trinidad.

[Former Member · Accepted solution]

Hi Trinidad,

Thank you for your response.

We restarted the HANA Linux server, but only hdbnameserver and hdbreprocessor are running.

The hbdindexserver service is stopped.The SAP HANA was preinstalled in the Linux server.

I will create a ticket for support in order to check the SAP HANA installation

Best Regards

Vasilis Korolis

[duncanspeidel · Accepted solution]

Hi,

I would suggest the following:

• Use the command HDB stop to HANA DB
• Execute "cleanipc 00" remove to free all memory segments
• use "ps -ef|grep ndb" to see what processes are running as ndbadm
  • It is very likely that you will see "sapstart pf=/usr/sap/NDB/SYS/profile/NDB_HDB00_usphlvm2179" and /usr/sap/NDB/HDB00/usphlvm2179/trace/HDB.sapNDB_HDB00 -d -nw -f /usr/sap/NDB/HDB00/usphlvm2179/daemon.ini pf=/usr/sap/NDB/SYS/profile/NDB_HDB00_usphlvm2179
• use "kill -9 <process ID>" to kill any leftover processes.  The two shown above will be restarted when we start HANA
• use "ipcs" to see if there are any more shared memory segments owned by ndbadm
• use icprm to free any segments not release
  • ipcrm -m is used for shared memory segments
  • ipcrm -s is used for Semaphore Arrays
  • the command looks something like ipcrm -m 98304
• start HANA use HDB start
• Verify the system started using " ps -ef|grep hdb"
  • Expect to see

• ndbadm     809   783  1 Jun12 ?        04:10:02 hdbnameserver

• ndbadm     869   783  0 Jun12 ?        03:05:49 hdbpreprocessor

• ndbadm     901   783  2 Jun12 ?        06:58:15 hdbstatisticsserver

• ndbadm     933   783  1 Jun12 ?        04:00:18 hdbxsengine

• ndbadm    1258   783  0 Jun12 ?        00:01:00 sapwebdisp_hdb pf=/usr/sap/NDB/HDB00/usphlvm2179/wdisp/sapwebdisp.pfl -f /usr/sap/NDB/HDB00/usphlvm2179/trace/dev_webdisp

• ndbadm    3457   783  3 Jun24 ?        01:23:34 hdbindexserver

• ndbadm   14048 13922  0 07:25 pts/0    00:00:00 grep hdb

• If the processes are still missing open a customer message.  Include the steps to replicate the problem and the trace files from /usr/sap/ndb/HDB00/<hostname>/trace

Best regards,

Duncan

[AtulKumarJain]

Hi Vasillis,

You can check hana db status using

HDB info command and also from

/usr/sap/<SID>/HDB00/<server>/trace/daemon*

Best Regards,

Atul