I do not have the SAP* user in the client "000",
I do not have the SAP* user in the client "000", i need recovery it. Please somebody can help me. Thanks.
first of all u have to check USR02 Table in that u can see SAP* and all other users. i believe sap* will definately there please check. if not try to delet that from OS level. if sap* is not there in database then it will tell user doesn't exist.
but before deletion u have to set parameter login/automatic_user_sapstar=0
then it will create new sap* with password pass.
u have to delete sap* from the database level it means u have to enter in to the sql with user ORASID then use this command.
Delete from<databasehostname>.usr02 where MANDT=000 and BNAME='SAP*';
but be careful it will match u r requirement but its very dangerous procedure otherwise take security person help in this case in my view u have to take security people help.
If the above solution is helpful for you please reward point for me!