How to know the SUPERDBA password or reset it

[Former Member]

I am a complete newbie to SAP Netweaver Application server. We have upgraded our application server from 7.1 to 7.4. After the upgrade we are facing an issue, the database log is full.

To resolve this issue, we found a solution through dbmcli. Below are the steps to resolve the log is full issue.

Steps

    1. dbmcli -d <database name> -u <username,password>

    2. db_admin

    3. util_connect

    4. util_execute clear log

    5. db_online

    6. exit

All fine, but in the first step itself I am facing exception, because I am not sure of the database password. Below is my command and error message in detail

dbmcli -d J2E -u SUPERDBA,<mypassword entered here>

Error! Connection failed to node(local) for database J2E:

-24950, ERR_USRFAIL: User authorization failed.

Please help resolve this issue.

[Former Member · Accepted solution]

This issue got resolved now. Password should be given in quotes if it has special characters in it.

Example:

dbmcli Syntax : dbmcli -d <databaseName> -u <username>,<password>

If your password = $123abc, and issuing the below command

dbmcli -d ABC -u srk,$123abc

will not work rather it shows you the error,

Error! Connection failed to node(local) for database J2E:
-24950, ERR_USRFAIL: User authorization failed.

The same will work if the password is given in quotes as shown below.

dbmcli -d ABC -u srk,'$123abc'

Thanks

Srk

[Former Member]

Hello sr,

In that note, you'll find useful dbmcli commands in solution section. Apply them regarding to your system:

1761308 - Unkown password for DBM or SYSDBA user

For some general information about the structure, have a look at that note:

25591 - Password change for DBM and DBA users

I hope they're useful.

Regards,

Serhat

[Former Member]

I am not authenticated to open those links.

[Former Member]

If you can not view SAP Notes, you'd better quit this work

Ask your team for an S-User, to be able to see notes.