Unable to connect HDB in sap hana

[Former Member]

I'm trying to connect my HDB database using below command.

hdbsql -u SYSTEM -p password -d HDB -i 00

But, is throws below error even though I have HDB (tenant) database.

* 2: general error: database 'HDB' is unavailable SQLSTATE: HY000

Here is HDB info results.

hdbadm    3329  3242  6.0 6975692 3908564      \_ hdbnameserver
hdbadm    4538  3242  2.3 3125912 474896      \_ hdbcompileserver
hdbadm    4540  3242  2.0 3577564 501452      \_ hdbpreprocessor
hdbadm    4646  3242  2.7 4576020 1308012      \_ hdbdpserver -port 30052
hdbadm    4648  3242 18.4 9134564 5475720      \_ hdbindexserver -port 30040
hdbadm    4650  3242 14.9 8452644 5007884      \_ hdbindexserver -port 30055
hdbadm    7410  3242  1.9 3159196 443576      \_ hdbdiserver
hdbadm    7412  3242  2.0 3161628 453424      \_ hdbdiserver -port 30043
hdbadm    7414  3242  2.2 3425392 642704      \_ hdbwebdispatcher

When I start database with HDB start command it's not showing any error message.

Please help me to find the root cause of this issue.

[lsubatin]

Can you connect to the system database and run: select * from "SYS"."M_DATABASES" ? It should show the status of the tenant db.

Also, you can use "alter system start database <<tenant db id>>" to start a tenant.

[yogeshpatel123]

Thanks Lucia Subatin. I started DB with your query.