cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

sap dispatcher is going down simultaniously

Former Member

on ‎05-25-2015 5:07 AM

0 Kudos

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

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (3)

Answers (3)

IanSegobio
Advisor
Advisor
‎05-26-2015 1:50 PM
0 Kudos

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.

Show replies
Show replies
Former Member
‎05-26-2015 11:48 AM
0 Kudos

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

Show replies
Show replies
Former Member
‎05-25-2015 6:25 AM
0 Kudos

Hi all,

kindly do the needful.

Show replies
Show replies
Former Member
‎05-25-2015 7:23 AM
0 Kudos

Hi abdul,

Good morning, You need to check below environment of your user id.

From the error its clear that environment for oracle client is not available.



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.

Also at the same time if your using OPS$ mechanism, do check and verify if the right users are defined like OPS$<SID>ADM. As form the user is not able to connect using OPS$ and failing with username/password issue. can be seen below:-



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


4 ETW000                                                                              44  0.099836


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]

Let us know if this helped you.

Regards,

ram

Former Member
‎05-25-2015 10:01 AM
0 Kudos

Thanks Ram for ur response.

Thanks,

Abdul

Former Member
‎05-25-2015 1:22 PM
0 Kudos

Hi Abdul,

Did the reply helped you. Let us know the details.

Regards,

Ram

Sriram2009
Active Contributor
‎05-26-2015 6:24 AM
0 Kudos

Hi Abdul

1. Are you executing the R3trans -d on SAP SIDADM user id?

2. On SAP SIDADM user check the environment variable settings based on your DB, as mention in the SAP Note

556232 - Environment settings for R/3/Oracle on Windows


BR

SS

Ask a Question