创建client之后sap*无法登陆解决办法

sale创建逻辑系统  scc4新建clinet 发现sap*无法登陆 rz10检查参数login/no_automatic_user_sapstar值为1正常 如果为0 修改参数重启 然后就可以用sap*登陆

> exp

Export: Release 10.2.0.1.0 - Production on Tue Nov 18 16:40:46 2008

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

Username: system/system as sysdba

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning and Data Mining options
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp > usr02

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > t

Export table data (yes/no): yes > yes

Compress extents (yes/no): yes > yes

Export done in UTF8 character set and UTF8 NCHAR character set

About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > sapsr3.usr02

Current user changed to SAPSR3
. . exporting table                          USR02         55 rows exported
Table(T) or Partition(T:P) to be exported: (RETURN to quit) >

Export terminated successfully without warnings.

 

sql /nolog

conn system

delete from sapsr3.usr02 where bname="sap*" and mandt="clinet"