Name Null? Type
----------------------------------------- -------- ----------------------------
MANDT NOT NULL VARCHAR2(9)
BNAME NOT NULL VARCHAR2(36)
BCODE RAW(8)
GLTGV NOT NULL VARCHAR2(24)
GLTGB NOT NULL VARCHAR2(24)
USTYP NOT NULL VARCHAR2(3)
CLASS NOT NULL VARCHAR2(36)
LOCNT NOT NULL NUMBER(3)
UFLAG NOT NULL NUMBER(3)
ACCNT NOT NULL VARCHAR2(36)
ANAME NOT NULL VARCHAR2(36)
ERDAT NOT NULL VARCHAR2(24)
TRDAT NOT NULL VARCHAR2(24)
LTIME NOT NULL VARCHAR2(18)
OCOD1 RAW(8)
BCDA1 NOT NULL VARCHAR2(24)
CODV1 NOT NULL VARCHAR2(3)
OCOD2 RAW(8)
BCDA2 NOT NULL VARCHAR2(24)
CODV2 NOT NULL VARCHAR2(3)
OCOD3 RAW(8)
BCDA3 NOT NULL VARCHAR2(24)
CODV3 NOT NULL VARCHAR2(3)
OCOD4 RAW(8)
BCDA4 NOT NULL VARCHAR2(24)
CODV4 NOT NULL VARCHAR2(3)
OCOD5 RAW(8)
BCDA5 NOT NULL VARCHAR2(24)
CODV5 NOT NULL VARCHAR2(3)
VERSN NOT NULL VARCHAR2(9)
CODVN NOT NULL VARCHAR2(3)
TZONE NOT NULL VARCHAR2(18)
ZBVMASTER NOT NULL VARCHAR2(3)
PASSCODE RAW(20)
PWDCHGDATE NOT NULL VARCHAR2(24)
PWDSTATE NOT NULL NUMBER(3)
RESERVED NOT NULL NUMBER(3)
PWDHISTORY NOT NULL NUMBER(3)
PWDLGNDATE NOT NULL VARCHAR2(24)
PWDSETDATE NOT NULL VARCHAR2(24)
PWDINITIAL NOT NULL NUMBER(3)
PWDLOCKDATE NOT NULL VARCHAR2(24)
PWDSALTEDHASH NOT NULL VARCHAR2(765)
SECURITY_POLICY NOT NULL VARCHAR2(120)
SQL> select BNAME from sapsr3.usr02;
BNAME
------------------------------------
BASIS
DDIC
TMSADM
DDIC
SAP*
EARLYWATCH
SAP*
7 rows selected.
SQL> delete from sapsr3.usr02 where bname='SAP*' and mandt='000';
0 rows deleted.
SQL> commit;
Commit complete.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
erpdev:devadm 11> stopsap
Checking DEV Database
Database is running
-------------------------------------------
stopping the SAP instance DVEBMGS00
Shutdown-Log is written to /home/devadm/stopsap_DVEBMGS00.log
-------------------------------------------
/usr/sap/DEV/DVEBMGS00/exe/sapcontrol -prot NI_HTTP -nr 00 -function Stop
Instance on host erpdev stopped
Waiting for cleanup of resources
............
stopping the SAP instance ASCS01
Shutdown-Log is written to /home/devadm/stopsap_ASCS01.log
-------------------------------------------
/usr/sap/DEV/ASCS01/exe/sapcontrol -prot NI_HTTP -nr 01 -function Stop
Instance on host erpdev stopped
Waiting for cleanup of resources
..
Trying to stop DEV database ...
Log file: /home/devadm/stopdb.log
DEV database stopped
Checking DEV Database
Database is not available via R3trans
-------------------------------------------
erpdev:devadm 12> startsap
Checking DEV Database
Database is not available via R3trans
-------------------------------------------
Trying to start DEV database ...
Log file: /home/devadm/startdb.log
DEV database started
Starting Startup Agent sapstartsrv
OK
Instance Service on host erpdev started
-------------------------------------------
starting SAP Instance ASCS01
Startup-Log is written to /home/devadm/startsap_ASCS01.log
-------------------------------------------
/usr/sap/DEV/ASCS01/exe/sapcontrol -prot NI_HTTP -nr 01 -function Start
Instance on host erpdev started
Starting Startup Agent sapstartsrv
OK
Instance Service on host erpdev started
-------------------------------------------
starting SAP Instance DVEBMGS00
Startup-Log is written to /home/devadm/startsap_DVEBMGS00.log
-------------------------------------------
/usr/sap/DEV/DVEBMGS00/exe/sapcontrol -prot NI_HTTP -nr 00 -function Start
Instance on host erpdev started
重启服务器。
然后用SAP*,密码PASS登陆000 CLNT。
如果还是不能登录,登录另外的client,用rz10,修改参数:
login/no_automatic_user_sapstar = 0 (默认是1,打开)。