sap* 忘记密码，找回方法

使用数据库用户进入sqlplus

R3QAS01:orax01 2% sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Wed Aug 13 20:09:25 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

查询当前用户
SQL> select bname,mandt from sapsr3.usr02;

BNAME                                MANDT
------------------------------------ ---------
DDIC                                 000
SAP*                                 000
SAPCPIC                              000
DDIC                                 001
SAP*                                 001
SAPCPIC                              001
EARLYWATCH                           066
SAP*                                 066

8 rows selected.

SQL>

将sap*一行记录删掉
SQL> delete from sapsr3.usr02 where bname='SAP*' and mandt=001;

1 row deleted.

现在可以使用sap* 密码pass登录了

如果当前sap版本默认就不允许sap*登录，需要先修改实例参数

login/no_automatic_user_sapstar = 0

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27771627/viewspace-1250793/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27771627/viewspace-1250793/