How to change the password of user 'DBACOCKPIT' correctly?

[Former Member]

Hi, Colleagues

There is a SAP ERP on HANA system in our department.

The ERP on a 96G linux server and HANA on another 256G linux server(gshana.pvgl.sap.corp).

I’m doing a System Copy (Export & Import) of SAP ERP on HANA system. During Import process, the password of user ‘DBACOCKPIT’ is required, but I forgot it.

So I changed the password through the following steps:
1.       Change the password of ‘DBACOCKPIT’ to ‘Abc12345’ via HANA studio in 256G linux server(HANA DB).
2.       Change the password via command on 96G linux Server (ERP).
            “hdbuserstore SET default "gshana.pvgl.sap.corp":"30015" DBACOCKPIT Abc12345”

After the changing password, the sap startup failed.
*-------------------------------------------------------------------------------------------------*
hana-gs-china:~ # su - bepadm
hana-gs-china:bepadm 51> startsap
Checking db Database
Database is not available via R3trans
-------------------------------------------
Database db must be started first
Log on to remote server and start database
hana-gs-china:bepadm 52> R3trans -d
This is R3trans version 6.24 (release 741 - 04.02.14 - 20:14:02 ).
unicode enabled version
2EETW169 no connect possible: "DBMS = HDB                              ---  SERVER = '' PORT = ''"
R3trans finished (0012).

*-------------------------------------------------------------------------------------------------*

hana-gs-china:bepadm 66> hdbuserstore list
DATA FILE       : /home/bepadm/.hdb/hana-gs-china/SSFS_HDB.DAT

KEY DEFAULT
  ENV : gshana.pvgl.sap.corp:30015
USER: DBACOCKPIT
*-------------------------------------------------------------------------------------------------*

Do you know how to change the password of user 'DBACOCKPIT' correctly?

Thanks a lot in advance!

Best regards,
Daniel

[Former Member · Accepted solution]

HANA DB has started successfully via HANA studio. but sap system startup failed.

Best regards,
Daniel

[lbreddemann · Accepted solution]

Why are you setting the hdbuserstore key DEFAULT?

This one is used by the NetWeaver work processes to connect to the database, in this case to SAP HANA. So, it really shouldn't be DBACOCKPIT but SAP<SID>.

For DBACOCKPIT setup, why not simply use the help.sap.com documentation ??

Authorizations for Using DBA Cockpit - DBA Cockpit for SAP HANA - SAP Library

Cheers,

Lars

[Former Member · Accepted solution]

Thanks a lot!

SAP startup successfully after setting DEFAULT with SAP<SID>.

Best regards,
Daniel

[srinivasan_vinayagam]

Hi Daniel,

Try this.

> alter password required for user XXXXXXXXX

If user does not exit CREATE USER DBACOCKPIT PASSWORD <the password> and GRANT DBA_COCKPIT TO DBACOCKPIT

Regards,

V Srinivasan