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*
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8433094/viewspace-965568/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8433094/viewspace-965568/