Reser SAP* password in MAXDB

[Former Member]

Hi,

I forgot SAP* user password in 000 client i want to reset the SAP * password.Mine Environment is Linux with Maxdb.whats the command to reset password in maxdb.

Thanku

[Former Member · Accepted solution]

Hi Raju,

In MaxDB Version 7.5 and higher you can use the "SQLStudio" or the command

line tool "sqlcli" to run the SQL statement, if you are logged on to the OS as <sid>adm or user in the group sdba:

sqlcli -d <Database name> -u sap<sid>,<Password>

<enter>

"delete from usr02 where mandt='<Client>' and bname='SAP*'"

Please read the SAP notes 68048 and 2383 for more information and better understanding and if this doesnot work pls open an OSS call on component BC-DB-SDB to solve this issue.

All the best !

[Former Member · Accepted solution]

HI,

Thanks,I logged with sidadm and run the below commands,iam getting below message.how to rectify the same.

testsolman:sreadm 53> sqlcli -d lgstest -u sapsre,welcome8

• -10709: Connection failed (RTE:database not running: no request pipe)

Welcome to the MaxDB interactive terminal.

Type: \h for help with commands

\q to quit

sqlcli=> "delete from usr02 where mandt='100' and bname='SAP*'"

• -10709: Connection failed (RTE:database not running: no request pipe)

Thanku

[lbreddemann · Accepted solution]

> testsolman:sreadm 53> sqlcli -d lgstest -u sapsre,welcome8

>

> * -10709: Connection failed (RTE:database not running: no request pipe)

>

> sqlcli=> "delete from usr02 where mandt='100' and bname='SAP*'"

>

> * -10709: Connection failed (RTE:database not running: no request pipe)

Ok, just by reading the error message... what do you think could possibly be the reason for the error?

Is the database up and running?

And, no, if the database is not up and running then just entering the delete command won't work.

So, please start up your database first and try to delete the data again.

cheers,

Lars

[Former Member · Accepted solution]

Hi it seems your DB is not up... Make it up and issue the command with dbcli- Also pls check the below file for any errors during startup for your MAXDB KnlMsg file

To start MaxDb

dbmcli u2013d <db_name> -u <dbm_user>,<password> db_online

Opening the KnkMsg file:

dbmcli -d <dbname> -u <dbmusr>,<pwd> -nohold file_getfirst KNLMSG

It Consists of three parts: startup messages, runtime information and shutdown/crash messages.. Once connected you can change issue the command to reset SAP*

All the best !

[Former Member · Accepted solution]

Hi,

Thanks for inputs,database is in ONLINE mode only,still iam getting same error.guide me for the same.

Thanku

[former_member229109 · Accepted solution]

Hello,

1. Please see my reply at

Pay attention to hint:

It is sufficient to temporarily set the login/no_automatic_user_sapstar

parameter to the value 0 on the application server < SAP note 68048>.

This application server should be restarted after the value of the profile

parameter was changed.

And you try to log on to this application server as user 000/SAP*/PASS.

SAP strongly recommends that you reset the profile parameter login/no_automatic_user_sapstar to value 1 afterwards.

2. Please post additional information:

->What is the version of your system?

->What is the version of the MAXDB database?

->Update with output of the following commands:

dbmcli db_enum

dbmcli u2013d <SID> -u <dbm-user>,<pwd> db_state

xinstinfo <SID>

Thank you and best regards, Natalia Khlopina

[Former Member]

Hi kumarraju,

You can just try to set profile parameter login/no_automatic_user_sapstar to 0, and then restart application server.

then logon sap system with user SAP* password 'pass'.

Hope it works.

Best regards,

Nick