Skip to Content
avatar image
Former Member

sap dispatcher is going down simultaniously

Hi all,

current we are facing some issues related to Dispatcher its going down simultaneously.

pfl related to r3trans -d

4 ETW000 r3trans version 6.14 (release 700 - 10.09.07 - 09:57:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 25.05.2015 - 10:06:46

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d

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

4 ETW000 [dev trc ,00000] Mon May 25 10:06:49 2015 0 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000

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

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

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

4 ETW000 [dev trc ,00000] using "F:\usr\sap\ABD\SYS\exe\uc\NTAMD64\dboraslib.dll"

4 ETW000 76 0.009015

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 21 0.009036

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

4 ETW000 40 0.009076

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

4 ETW000 188 0.009264

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

4 ETW000 36 0.009300

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

4 ETW000 50 0.009350

4 ETW000 [dev trc ,00000] New connection 0 created 32 0.009382

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 52 0.009434

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

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

4 ETW000 34 0.009499

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 39 0.009538

4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or

4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.

4 ETW000 assuming using instant client with unspecified location.

4 ETW000 313 0.009851

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 10433 0.020284

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 60 0.020344

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 3514 0.023858

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 66 0.023924

4 ETW000 [dev trc ,00000] Connecting as /@ABD on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000 46 0.023970

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 41 0.024011

4 ETW000 [dev trc ,00000] 0 UTF8 1 00000000076F4090 0000000003B6E1C0 0000000003B73988

4 ETW000 135 0.024146

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 33 0.024179

4 ETW000 [dev trc ,00000] Allocating server context handle 27 0.024206

4 ETW000 [dev trc ,00000] Attaching to DB Server ABD (con_hdl=0,svchp=0000000003B73848,srvhp=00000000077130E8)

4 ETW000 69 0.024275

4 ETW000 [dev trc ,00000] Assigning server context 00000000077130E8 to service context 0000000003B73848

4 ETW000 27352 0.051627

4 ETW000 [dev trc ,00000] Allocating user session handle 75 0.051702

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0000000003B73848,srvhp=00000000077130E8,usrhp=0000000003B6E9D8)

4 ETW000 69 0.051771

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

4 ETW000 48021 0.099792

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

4 ETW000 44 0.099836

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 27 0.099863

4 ETW000 [dev trc ,00000] Try to connect with default password 64 0.099927

4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@ABD on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000 38 0.099965

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 38 0.100003

4 ETW000 [dev trc ,00000] 0 UTF8 1 00000000076F4090 0000000003B6E1C0 0000000003B73988

4 ETW000 42 0.100045

4 ETW000 [dev trc ,00000] Assigning username to user session 0000000003B6E9D8

4 ETW000 36 0.100081

4 ETW000 [dev trc ,00000] Assigning password to user session 0000000003B6E9D8

4 ETW000 49 0.100130

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0000000003B73848,srvhp=00000000077130E8,usrhp=0000000003B6E9D8)

4 ETW000 43 0.100173

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

4 ETW000 42853 0.143026

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

4 ETW000 41 0.143067

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 22 0.143089

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1017 performing CON [dblink#5 @ 431]

4 ETW000 128 0.143217

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#5 @ 431]

4 ETW000 37 0.143254

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

kindly do the needful asap.

Thanks,

Abdul

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    May 25, 2015 at 05:25 AM

    Hi all,

    kindly do the needful.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 26, 2015 at 10:48 AM

    Hi,

    Adding to Ram and Sriram.....

    Please check the ORAARCH folder as well. It may require cleaning to avoid space issue..

    Let the group know how your issue resolved.

    Thanks,

    Garry

    Add comment
    10|10000 characters needed characters exceeded

  • May 26, 2015 at 12:50 PM

    Hello,

    There are some recent scenarios in which we see dispatcher crashes just after the startup. On its traces, we see database related errors but R3trans -d returns 0.

    At the end, the issue was caused because the environment variables could not be determined correctly by sapstartsrv. OS level command "sapcontrol -nr <instance_nr> -function GetEnvironment" was returning only the LD_LIBRARY_PATH env variable.

    Cheers,
    Ian Segóbio.

    Add comment
    10|10000 characters needed characters exceeded