SAP* 无法登陆解决办法

SQL> desc sapsr3.usr02
 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,打开)。


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值