Forgot Password for user id SAP*

First make sure the profile includes the parameter: login/no_automatic_user_sapstar = 0, which means in a client, user sap* will be created automatically if there is no user sap* in this client.

Then delete the user sap* from the user table in sqlplus in command environment, the commands are as following:

C:>set ORACLE_SID = S01

C:>sqlplus /nolog

SQL*Plus: Release 9.0.1.0.1 - Production on 星期三 1月 12 19:42:08 2005

(c) Copyright 2001 Oracle Corporation. All rights reserved.

SQL> connect / as sysdba

Connected.

SQL> select bname, mandt from sapsr3.usr02 where bname=’SAP*’ and mandt=’800’;

//***SAPR3.usr02 if R/3****//

BNAME

---------------------------------------------------------------

MANDT

------------------------------------------

SAP*

800

SQL> delete from sapsr3.usr02 where bname=’SAP*’ and mandt=’800’;

One row is deleted

SQL>exit.

OK, now the user SAP* will be created with password ‘PASS’.

[@more@]

Forgot Password for user id SAP*