on 03-20-2015 5:36 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.