isql cannot access hana DB

[Former Member]

Our Hana based systems such as ECC/SRM/CRM are running well.

However, we cannot access the db using isql.

Find some oss notes and threads. But no fix so far.

Would you please have a look?

Thanks!

[former_member187565 · Accepted solution]

Dear Mike,

Just check if there is any port restriction on your HANA box.

Regards,

Rafikul

[Former Member · Accepted solution]

I do not see any problem on ports, please check. Thanks!

[root@SKYDBDEV101 ~]# netstat -an|grep 30015

tcp        0      0 0.0.0.0:30015               0.0.0.0:*                   LISTEN

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9581          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9557          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9564          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9556          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9604          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9598          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9569          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9580          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9559          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9593          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9543          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9596          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9613          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9576          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9605          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9567          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9583          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9603          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9547          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9545          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9589          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9571          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9609          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9568          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9592          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9588          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9600          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9560          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9579          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9553          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9612          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9561          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9608          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9590          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9582          ESTABLISHED

tcp        0      0 XX.XXX.XXX.53:30015         XX.XXX.XXX.18:9552          ESTABLISHED

[root@SKYDBDEV101 ~]# netstat -apn|grep sapstartsrv

tcp        0      0 0.0.0.0:50014               0.0.0.0:*                   LISTEN      2859/sapstartsrv

tcp        0      0 0.0.0.0:1128                0.0.0.0:*                   LISTEN      2788/sapstartsrv

tcp        0      0 0.0.0.0:1129                0.0.0.0:*                   LISTEN      2788/sapstartsrv

tcp        0      0 0.0.0.0:50013               0.0.0.0:*                   LISTEN      2859/sapstartsrv

unix  2      [ ACC ]     STREAM     LISTENING     19384  2788/sapstartsrv    /tmp/.sapstream1128

unix  2      [ ACC ]     STREAM     LISTENING     19429  2859/sapstartsrv    /tmp/.sapstream50014

unix  2      [ ACC ]     STREAM     LISTENING     19432  2859/sapstartsrv    /tmp/.sapstream50013

unix  2      [ ACC ]     STREAM     LISTENING     19382  2788/sapstartsrv    /tmp/.sapstream1129

unix  3      [ ]         STREAM     CONNECTED     19098  2788/sapstartsrv

unix  3      [ ]         STREAM     CONNECTED     19096  2788/sapstartsrv

unix  3      [ ]         STREAM     CONNECTED     19094  2788/sapstartsrv

unix  3      [ ]         STREAM     CONNECTED     19092  2788/sapstartsrv

unix  3      [ ]         STREAM     CONNECTED     19090  2788/sapstartsrv

unix  3      [ ]         STREAM     CONNECTED     19088  2788/sapstartsrv

unix  3      [ ]         STREAM     CONNECTED     19086  2788/sapstartsrv

unix  3      [ ]         STREAM     CONNECTED     19084  2788/sapstartsrv

unix  3      [ ]         STREAM     CONNECTED     19082  2788/sapstartsrv

unix  3      [ ]         STREAM     CONNECTED     19080  2788/sapstartsrv

unix  3      [ ]         STREAM     CONNECTED     19078  2788/sapstartsrv

[manish_singh13 · Accepted solution]

Hi Mike,

As per your details in very first post, these seems to be two different issues:

1. iSQL Access issue with SYSTEM User

Please try resetting SYSTEM user account to fix this

HANA Tutorials: How to reset the HANA SYSTEM User password.

2. Hana DB Studio Connectivity (System Can not be reached).

Please check if you are providing correct details in studio for your hana db (servername, port). If you have any other user which can be used (apart from SYSTEM) for creating connection entry in studio.

Thanks,

MPS

[manish_singh13]

Hi Mike,

Is your SYSTEM account password correct. Please see if you can reset the account and possibility of account being locked. You can verify this through parameter "password_lock_for_system_user" is true or false in indexserver.ini parameter file.

Thanks,

MPS

[Former Member]

above parameter is set to false in the said ini file at two places .

Some threads discussed this.

But still fails.

Please help.  Thanks!!