Procedure:
1. To Activate the SAP* in abap system set the parameter login/no_automatic_user_sapstar=0 in RZ10.
2. Take the restart of the application server.
If SAP* is enable but still unable to login fllow the below procedure.
1. Logon to database server and switch to database user.
2. Start the sqlplus with the command:
root > sqlplus / as sysdba
3. View the entries of the SAP* with following command:
SQL > select * from "<SCHEMA_NAME>".usr02 where mandt = '<CLIENT_NO>' and bname = 'SAP*';
4. Delete the SAP* user
SQL > delete from "<SCHEMA_NAME>".usr02 where mandt = '<CLIENT_NO>' and bname = 'SAP*';
SQL > commit;
1. Logon to database server and switch to database user.
2. Start the sqlplus with the command:
root > sqlplus / as sysdba
3. View the entries of the SAP* with following command:
SQL > select * from "<SCHEMA_NAME>".usr02 where mandt = '<CLIENT_NO>' and bname = 'SAP*';
4. Delete the SAP* user
SQL > delete from "<SCHEMA_NAME>".usr02 where mandt = '<CLIENT_NO>' and bname = 'SAP*';
SQL > commit;
Note :
<SCHEMA_NAME> = SAPSR3 in Oracle
<SCHEMA_NAME> = SAPABAP1 or SAPHANADB in HANA
I think there is no need to restart SAP instances.
ReplyDeleteI would like to say this is a well-informed article as we have seen here. Your way of writing is very impressive and also it is a beneficial article for us. Thanks for sharing an article like this.SAP PDF training handbooks ebooks
ReplyDeleteSQL > delete from "SAPSR3".usr02 where mandt = '000' and bname = 'SAP*'
ReplyDeleteSAPSR3= oracle Schema
It helped! excellent!
ReplyDelete