Dispatcher Not running

[Former Member]

Hi Experts,

Recently we have upgrade database (oracle 9.2.0.4.0 t0 10.2.0.2.0) in our development server,but after oracle upgradation the dispatcher not getting open.We have done lot of troubleshooting but still not abe to find out the solution .We will appreciate if someone guide us accordingly.

We r using ECC 5.0 on Windows 2003 Advance Server.

Thanks in advance.

[Former Member · Accepted solution]

How anyone can do troubleshooting without any logs ??

[Former Member]

Hi,

ECCADM & SAPSERVICEECC are the OS level accounts you cant unlock them from SQL.

Goto My Computer>Right click>Manage>Local users & groups->Users> Seletc sidadm & sapserviceadm user id & try to unlock them.

Hope this helps

Thanks

Sushil

[Former Member]

Hello Sushil,

I have already done this but still shows locked in dba level.

Also find the retrans log may be it would help us.

D:\usr\sap\ECC\SYS\exe\run>r3trans -d

This is r3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).

unicode enabled version

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

r3trans finished (0012).

D:\usr\sap\ECC\SYS\exe\run>

[Former Member]

Hi,

Check this note 556232 Environment settings for R/3/Oracle on Windows.

Thanks

Sushil

[Former Member]

Hi,

Pls check the parameter value..

log_archive_start=true in initsid.ora

or

check the log file of alert_SID.log

Regards,

Mani

[Former Member]

Hi,

Check account status by

SQL>select username, lock_date, account_status expired_date from dba_users;

& unlock it by

SQL>ALTER USER <username> ACCOUNT UNLOCK;

Also check SAP Note 400241.

Hopw this helps

Thanks

Sushil

[Former Member]

Hi Rohit,

I m able to lock all the user under dba_user but facing prob while unlock the OPS$ user.

So pls suggest how we can unlock the users start with OPS$.

Thanks in advance.

[Former Member]

is OPS$ user locked?whats the problem you are facing unlocking it

[Former Member]

Hi Rohit,

I m able to lock all the user under dba_user but facing prob while unlock the OPS$ user.

So pls suggest how we can unlock the users start with OPS$.

Thanks in advance.

[Former Member]

Hi,

can you check whether OPS$ user locked?

SQL> select username,user_id,account_status,expiry_date from dba_users;

Please refer SAP Note 400241, 50088 & below mentioned links

http://www.sap-img.com/basis/information-on-how-the-ops-users-work.htm

Hope this helps

Thanks

Sushil

[Former Member]

Hi Sushil,

Thanks fo your helping hand but still below mention user not getting unlocked.KIndly suggest me that in which way we need to proceed to resolve this issue.....

In below log ECC is SID and ASHISH is the host name.

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\Administrator>sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Apr 30 18:33:15 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL> select username,accout_status from dba_users;

select username,accout_status from dba_users

*

ERROR at line 1:

ORA-00904: "ACCOUT_STATUS": invalid identifier

SQL> select username,account_status from dba_users;

USERNAME ACCOUNT_STATUS

-

---

-

---

SYSTEM OPEN

SYS OPEN

OPS$ASHISH\SAPSERVICEECC LOCKED

SYSMAN OPEN

SAPECC OPEN

DBSNMP OPEN

MGMT_VIEW OPEN

OPS$ASHISH\ECCADM LOCKED

DIP OPEN

OUTLN OPEN

TSMSYS OPEN

11 rows selected.

SQL> select username,account_status from dba_users;

USERNAME ACCOUNT_STATUS

-

---

-

---

SYSTEM OPEN

SYS OPEN

OPS$ASHISH\SAPSERVICEECC LOCKED

SYSMAN OPEN

SAPECC OPEN

DBSNMP OPEN

MGMT_VIEW OPEN

OPS$ASHISH\ECCADM LOCKED

DIP OPEN

OUTLN OPEN

TSMSYS OPEN

11 rows selected.

SQL> select username,account_status from dba_users;

USERNAME ACCOUNT_STATUS

-

---

-

---

SYSTEM OPEN

SYS OPEN

OPS$ASHISH\SAPSERVICEECC LOCKED

SYSMAN OPEN

SAPECC OPEN

DBSNMP OPEN

MGMT_VIEW OPEN

OPS$ASHISH\ECCADM LOCKED

DIP OPEN

OUTLN OPEN

TSMSYS OPEN

11 rows selected.

SQL> alter user OPS$ASHISH\SAPSERVICEECC account unlock;

alter user OPS$ASHISH\SAPSERVICEECC account unlock

*

ERROR at line 1:

ORA-00911: invalid character

SQL> alter user OPS$ASHISH account unlock;

alter user OPS$ASHISH account unlock

*

ERROR at line 1:

ORA-01918: user 'OPS$ASHISH' does not exist

SQL> alter user SAPSERVICEECC account unlock;

alter user SAPSERVICEECC account unlock

*

ERROR at line 1:

ORA-01918: user 'SAPSERVICEECC' does not exist

SQL> p807345

SP2-0042: unknown command "p807345" - rest of line ignored.

SQL> alter user OPS$ASHISH\ECCADM account unlock;

alter user OPS$ASHISH\ECCADM account unlock

*

ERROR at line 1:

ORA-00911: invalid character

SQL> alter user OPS$ASHISH account unlock;

alter user OPS$ASHISH account unlock

*

ERROR at line 1:

ORA-01918: user 'OPS$ASHISH' does not exist

SQL> alter user ECCADM account unlock;

alter user ECCADM account unlock

*

ERROR at line 1:

ORA-01918: user 'ECCADM' does not exist

SQL>

[Former Member]

i guess those two users should be like this

OPS$SAPSERVICEECC

OPS$ECCADM

[Former Member]

First, How did you know that the dispatcher is not running ??

Check the output of dev_disp in the work directory and that should give you some clue.

Of course, R3trans -d should be successful as someone pointed it out

Pravin

[Former Member]

Hi,

try connectivity with R3trans

sidadm> r3trans -d -v

this will create trans.log file

please paste it here.

also give latest file section of alert_log file

Regards,

Nitin Salunkhe

[Former Member]

Hi Nitin ,

Thanks for prompt reply.Kindly go through the below mention log of trans.log file.

4 ETW000 r3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 27.04.2009 - 18:31:37

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d -v

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Mon Apr 27 18:31:37 2009 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0.000000

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0.000000

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0.000000

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 7007 0.007007

4 ETW000 [dev trc ,00000] using "D:\usr\sap\ECC\SYS\exe\run\dboraslib.dll"

4 ETW000 30 0.007037

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 14 0.007051

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 23 0.007074

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "640.00", patchlevel (0.39)

4 ETW000 88 0.007162

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 23 0.007185

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 34 0.007219

4 ETW000 [dev trc ,00000] New connection 0 created 21 0.007240

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 31 0.007271

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 19 0.007290

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 21 0.007311

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 28 0.007339

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=D:\oracle\product\10.2.0\db_1 from environment

4 ETW000 209 0.007548

4 ETW000 [dev trc ,00000] -->oci_initialize 16 0.007564

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 31935 0.039499

4 ETW000 [dev trc ,00000] Got TNS_ADMIN=D:\usr\sap\ECC\SYS\profile\Oracle from environment

4 ETW000 41 0.039540

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPECC's password 15 0.039555

4 ETW000 [dev trc ,00000] Connecting as /@ECC on connection 0 ... 21 0.039576

4 ETW000 [dev trc ,00000] Allocating service context handle 29 0.039605

4 ETW000 [dev trc ,00000] Allocating server context handle 19 0.039624

4 ETW000 [dev trc ,00000] Attaching to DB Server ECC (con_hdl=0,svchp=01E197B0,svrhp=01E2B024)

4 ETW000 44 0.039668

4 ETW000 [dev trc ,00000] Assigning server context 01E2B024 to service context 01E197B0

4 ETW000 18880 0.058548

4 ETW000 [dev trc ,00000] Allocating user session handle 35 0.058583

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=01E197B0,srvhp=01E2B024,usrhp=01E4DD50)

4 ETW000 49 0.058632

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 28000

4 ETW000 88592 0.147224

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=01E2B024) 33 0.147257

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=01E197B0,srvhp=01E2B024)

4 ETW000 35 0.147292

4 ETW000 [dev trc ,00000] Deallocating server context handle 01E2B024 483 0.147775

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '28000'

4 ETW000 60 0.147835

4 ETW000 [dev trc ,00000] Try to connect with default password 76 0.147911

4 ETW000 [dev trc ,00000] Connecting as SAPECC/<pwd>@ECC on connection 0 ...

4 ETW000 23 0.147934

4 ETW000 [dev trc ,00000] Allocating server context handle 15 0.147949

4 ETW000 [dev trc ,00000] Attaching to DB Server ECC (con_hdl=0,svchp=01E197B0,svrhp=01E2B024)

4 ETW000 43 0.147992

4 ETW000 [dev trc ,00000] Assigning server context 01E2B024 to service context 01E197B0

4 ETW000 13014 0.161006

4 ETW000 [dev trc ,00000] Assigning username to user session 01E4DD50 23 0.161029

4 ETW000 [dev trc ,00000] Assigning password to user session 01E4DD50 24 0.161053

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=01E197B0,srvhp=01E2B024,usrhp=01E4DD50)

4 ETW000 33 0.161086

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 28000

4 ETW000 40507 0.201593

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=01E2B024) 20 0.201613

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=01E197B0,srvhp=01E2B024)

4 ETW000 23 0.201636

4 ETW000 [dev trc ,00000] Deallocating server context handle 01E2B024 512 0.202148

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '28000'

4 ETW000 33 0.202181

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 28000 performing CON [dblink#1 @ 419]

4 ETW000 96 0.202277

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-28000: the account is locked [dblink#1 @ 419]

4 ETW000 24 0.202301

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'ECC'"

[Former Member]

Hello Parul

Referring to logs:

it gives ORA-28000: the account is locked

refer to Note 951167

This should solve your issue

Rohit

[Former Member]

In Sqlplus

Do

Alter user <User> account unlock

and try R3trans -d again

Pravin