Display+work.exe : Dispatcher stopped

[Former Member]

Hello Friends ,

When I was starting SAP DEV server (SAP Netweaver 7.0 ABAP trial version) , the server does not starts ( it ends with yellow but not green)

In the process list I found 'Display+work.exe : Dispatcher stopped'

OS : windows 2003 server

Database : Oracle

Syslog :

SAP-Basis system : stop sap system,Dispatcher pid 8

SAP-Basis system : Message server disconnected

communications data : SAP gateway was closed

SAP-Basis system: stop workproc 4, PID 1544

SAP-Basis system : Initialization DB-connect Failed , Return code 000256

Database : ORA-28000: the account is locked

Database : Database error 28000 at CON

Database : ORA - 28000: the account is locked

Database : Database error 28000 at CON

Is it Database problem??????? if so

Could you please help me to fix this problem...

[Former Member · Accepted solution]

Hi,

Please refer the Note 951167 - ORA-28000: the account is locked which should resolve your issue.

Regards,

Sharath

[Former Member]

Hi,

Were u able to start the SAP instance earlier ?

Have u installed the ABAP trial version on Oracle DB ? (I guess the ABAP trial version is bundled with MaxDB.)

Can u list the installation procedure which u have followed ?

Regards,

Varadharajan M

[Former Member]

Hello,

Check your user vairable ? how this parameters are set.

DBMS_TYPE = ora

dbs_ora_schema = SAPSR3 or sidadm

dbs_ora_tnsname = SID

PATH = E:\oracle\product\10.2.0\db_1;D:\usr\sap\SID\SYS\exe\uc\NTAMD64

Please refer this note to set variables SAP NOTE:- 556232

what is mentioned on your listener.ora under (SID_NAME = SID) ?

Can you tell me how do you login to your DB form CMD? sqlplus.

Regards

JUDE.

[Former Member]

Hi,

Can you check whether SYSTEM user is locked or not?

If not, check for OP$ mechanism and its users.

Please check for the note 400241 and see whether the issue is fixed.

Kindly update.

[Former Member]

Hello,

Please have a look at note 951167 (ORA-28000: the account is locked) as commented before, and if the issue persists try to read note 997510 (Troubleshooting J2EE Engine 6.40/7.0 Bootstrap Issues).

If any of these solve your issue please paste here the content of dev_jcontrol, dev_boostrap and dev_dispatcher so we can have a better idea of what is happening.

Regards,

Jonas

[Former Member]

hi,

Go to sql/plus

SQL>ALTER USER SAPSR3 IDENTIFIED BY SAP;

ALTER USER SAPSR3 ACCOUNT UNLOCK;

Execute this commands then restart your DB, this should resolve your issue.

Regards

JUDE

[Former Member]

unlock your schemaid

ALTER USER <sapschema name> ACCOUNT UNLOCK

[Former Member]

Thanks Mr Melvin,

when I was trying to access Sql plus(Release :10.2.0.1.0) with user ID- scott, psswd - tiger (or) Tiger , Host string - orcl (or) ora, there is an error.

Error : ORA-12154: TNS: could not resolve the connect identifier specified.

what does that mean ?????

[Former Member]

Hello friend ,

could you please elaborate ,what does this ' sapschema name' refers to ?????

because when I used

ALTER USER SAPSR3 ACCOUNT UNLOCK;

it says user 'SAPSR3' does not exist....

Edited by: Smitt.J on Oct 15, 2010 9:56 PM

Edited by: Smitt.J on Oct 15, 2010 10:24 PM

[Former Member]

Hi,

Schema is nothing but the owner of the tables in a DB. In case of SAP it is SAPSchema and it is the owner of SAP tables.

Execute the following command at the SQL prompt to list the DBA Users from where u can find the Schema Owner.

select * from dba_users;

This command will list all the DBA Users. The one starting with SAP is the SAP Schema owner.

Now execute the command ALTER USER <Schema Owner> ACCOUNT UNLOCK; and then try to start SAP.

Hope this clarifies.

Regards,

Varadharajan M

[Former Member]

Hello varadhu ,

I could find the below usernames , but not the one starting with SAP...

SYS,SYSTEM,SCOTT,BUSSOBJT,OUTLN,MGMT_VIEW,MDSYS,ORDSYS,CTXSYS,ANONYMOUS,EXFSYS ,DMSYS,

DBSNMP,WMSYS,XDB,ORDPLUGINS,SI_INFORMTN_SCHEMA,OLAPSYS,MDDATA..........