Disp+work.exe stopped

[Former Member]

I am trying to start the SAP BI/7.0 server using SAP MMC console. the dispatcher is getting stopped after staing in yellow for some time ( it becomes "gray"). I am copying the contents of DEV_W0 files .

I am basically a SAP BI person . Any pointers is greatly appreciated.

-

---

trc file: "dev_w0", trc level: 1, release: "700"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

B

B Fri Feb 12 00:42:53 2010

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\DEV\DVEBMGS03\exe\dboraslib.dll' ...

B Library 'D:\usr\sap\DEV\DVEBMGS03\exe\dboraslib.dll' loaded

B Version of 'D:\usr\sap\DEV\DVEBMGS03\exe\dboraslib.dll' is "700.08", patchlevel (0.107)

B New connection 0 created

M sysno 03

M sid DEV

M systemid 560 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 114

M intno 20050900

M make: multithreaded, Unicode, optimized

M pid 1676

M

M kernel runs with dp version 229000(ext=109000) (@(#) DPLIB-INT-VERSION-229000-UC)

M length of sys_adm_ext is 576 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 1676) [dpxxdisp.c 1301]

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M

M Fri Feb 12 00:42:54 2010

M DpShMCreate: sizeof(wp_adm) 15800 (1436)

M DpShMCreate: sizeof(tm_adm) 4232256 (21056)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

M DpShMCreate: sizeof(comm_adm) 528064 (1048)

M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M DpShMCreate: sizeof(slock_adm) 0 (96)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1536)

M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 06A40040, size: 4889440)

M DpShMCreate: allocated sys_adm at 06A40040

M DpShMCreate: allocated wp_adm at 06A42090

M DpShMCreate: allocated tm_adm_list at 06A45E48

M DpShMCreate: allocated tm_adm at 06A45E78

M DpShMCreate: allocated wp_ca_adm at 06E4F2B8

M DpShMCreate: allocated appc_ca_adm at 06E55078

M DpShMCreate: allocated comm_adm at 06E56FB8

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 06ED7E78

M DpShMCreate: allocated gw_adm at 06ED7EB8

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 06ED7EE8

M DpShMCreate: allocated wall_adm at 06ED7EF0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M ThInit: running on host sapdev

M

M Fri Feb 12 00:42:55 2010

M calling db_connect ...

C Prepending D:\usr\sap\DEV\DVEBMGS03\exe to Path.

C

C Fri Feb 12 00:43:15 2010

C Oracle Client Version: '10.2.0.1.0'

C

C Fri Feb 12 00:43:17 2010

C Client NLS settings: AMERICAN_AMERICA.UTF8

C Logon as OPS$-user to get SAPSM1's password

C Connecting as /@DEV on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 06775828 0677ADC4 0677A64C

C Attaching to DB Server DEV (con_hdl=0,svchp=0677A598,srvhp=0678C184)

C

C Fri Feb 12 00:43:20 2010

C Starting user session (con_hdl=0,svchp=0677A598,srvhp=0678C184,usrhp=067D7C88)

C Now '/@DEV' is connected (con_hdl 0, nls_hdl 0).

C

C Fri Feb 12 00:43:21 2010

C *** ERROR => ORA-1403 when accessing table SAPUSER

[dbsloci.c 11429]

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=0677A598,usrhp=067D7C88)

C Now I'm disconnected from ORACLE

C Try to connect with default password

C Connecting as SAPSM1/<pwd>@DEV on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 06775828 0677ADC4 0677A64C

C Starting user session (con_hdl=0,svchp=0677A598,srvhp=0678C184,usrhp=067D7C88)

C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017

[dboci.c 4532]

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 11042]

B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error 1017 performing CON [dblink#3 @ 431] [dblink 0431 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#3 @ 431] [dblink 0431 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1426]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10283]

M

M Info for wp 0

M

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source =

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M req.vm = no VM

M attachedVm = no VM

M

M *****************************************************************************

M *

M * LOCATION SAP-Server sapdev_DEV_03 on host sapdev (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Fri Feb 12 00:43:21 2010

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10486

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M Fri Feb 12 00:43:22 2010

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 720]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 260]

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 1676) [dpnttool.c 327]

[Former Member · Accepted solution]

make sure the database is running - try r3trans -d and check trans.log file. Also check to see listener is running

[Former Member · Accepted solution]

thanks Bill.

Please find the R3trans-d file contents.

4 ETW000 R3trans version 6.14 (release 700 - 29.05.07 - 13:40:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 11.12.2009 - 22:14:28

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] Fri Dec 11 22:14:28 2009 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 7194 0.007194

4 ETW000 [dev trc ,00000] using "D:\usr\sap\DEV\DVEBMGS03\exe\dboraslib.dll"

4 ETW000 35 0.007229

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 16 0.007245

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

4 ETW000 25 0.007270

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

4 ETW000 113 0.007383

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

4 ETW000 24 0.007407

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

4 ETW000 32 0.007439

4 ETW000 [dev trc ,00000] New connection 0 created 30 0.007469

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 34 0.007503

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

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

4 ETW000 23 0.007545

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 32 0.007577

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 193 0.007770

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 23576 0.031346

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

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 7451 0.038836

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPDEV's password 34 0.038870

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

4 ETW000 34 0.038904

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

4 ETW000 32 0.038936

4 ETW000 [dev trc ,00000] 0 UTF8 1 02D63F00 003399AC 00339234

4 ETW000 100 0.039036

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

4 ETW000 [dev trc ,00000] Allocating server context handle 21 0.039082

4 ETW000 [dev trc ,00000] Attaching to DB Server DEV (con_hdl=0,svchp=00339180,srvhp=02D7749C)

4 ETW000 47 0.039129

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

4 ETW000 21451 0.060580

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

4 ETW000 28 0.060608

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12518 18 0.060626

4 ETW000 [dev trc ,00000] Try to connect with default password 87 0.060713

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

4 ETW000 28 0.060741

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

4 ETW000 29 0.060770

4 ETW000 [dev trc ,00000] 0 UTF8 1 02D63F00 003399AC 00339234

4 ETW000 30 0.060800

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=02D7749C) 18 0.060818

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=00339180,srvhp=02D7749C)

4 ETW000 25 0.060843

4 ETW000 [dev trc ,00000] Deallocating server context handle 02D7749C 21 0.060864

4 ETW000 [dev trc ,00000] Allocating server context handle 20 0.060884

4 ETW000 [dev trc ,00000] Attaching to DB Server DEV (con_hdl=0,svchp=00339180,srvhp=02D7749C)

4 ETW000 36 0.060920

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

4 ETW000 20466 0.081386

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

4 ETW000 27 0.081413

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12518 16 0.081429

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

4 ETW000 128 0.081557

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12518: TNS:listener could not hand off client connection [dblink#3 @ 431]

4 ETW000 26 0.081583

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

[Former Member · Accepted solution]

check the listener is running, if not start it. Check the listener.log

[Former Member · Accepted solution]

hi bill , thanks for your reply. I am pasting the listener .log.

System parameter file is D:\oracle\SM1\102\network\admin\listener.ora

Log messages written to D:\oracle\SM1\102\network\log\listener.log

Trace information written to D:\oracle\SM1\102\network\trace\listener.trc

Trace level is currently 0

Started with pid=2236

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\DEV.WORLDipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\DEVipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sapdev.visu.com)(PORT=1527)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\ECC.WORLDipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\ECCipc)))

Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

11-FEB-2010 23:48:37 * (CONNECT_DATA=(SID=ECC)(GLOBAL_NAME=ECC.WORLD)(CID=(PROGRAM=D:\usr\sap\ECC\DVEBMGS04\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceECC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2987)) * establish * ECC * 0

11-FEB-2010 23:48:37 * (CONNECT_DATA=(SID=ECC)(GLOBAL_NAME=ECC.WORLD)(CID=(PROGRAM=D:\usr\sap\ECC\DVEBMGS04\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceECC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2988)) * establish * ECC * 0

11-FEB-2010 23:48:37 * (CONNECT_DATA=(SID=ECC)(GLOBAL_NAME=ECC.WORLD)(CID=(PROGRAM=D:\usr\sap\ECC\DVEBMGS04\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceECC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2989)) * establish * ECC * 0

11-FEB-2010 23:48:37 * (CONNECT_DATA=(SID=ECC)(GLOBAL_NAME=ECC.WORLD)(CID=(PROGRAM=D:\usr\sap\ECC\DVEBMGS04\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceECC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2990)) * establish * ECC * 0

11-FEB-2010 23:48:37 * (CONNECT_DATA=(SID=ECC)(GLOBAL_NAME=ECC.WORLD)(CID=(PROGRAM=D:\usr\sap\ECC\DVEBMGS04\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceECC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2991)) * establish * ECC * 0

11-FEB-2010 23:48:37 * (CONNECT_DATA=(SID=ECC)(GLOBAL_NAME=ECC.WORLD)(CID=(PROGRAM=D:\usr\sap\ECC\DVEBMGS04\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceECC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2992)) * establish * ECC * 0

11-FEB-2010 23:48:37 * (CONNECT_DATA=(SID=ECC)(GLOBAL_NAME=ECC.WORLD)(CID=(PROGRAM=D:\usr\sap\ECC\DVEBMGS04\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceECC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2993)) * establish * ECC * 0

11-FEB-2010 23:48:37 * (CONNECT_DATA=(SID=ECC)(GLOBAL_NAME=ECC.WORLD)(CID=(PROGRAM=D:\usr\sap\ECC\DVEBMGS04\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceECC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2995)) * establish * ECC * 0

11-FEB-2010 23:48:37 * (CONNECT_DATA=(SID=ECC)(GLOBAL_NAME=ECC.WORLD)(CID=(PROGRAM=D:\usr\sap\ECC\DVEBMGS04\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceECC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2996)) * establish * ECC * 0

11-FEB-2010 23:48:38 * (CONNECT_DATA=(SID=ECC)(GLOBAL_NAME=ECC.WORLD)(CID=(PROGRAM=D:\usr\sap\ECC\DVEBMGS04\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceECC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2997)) * establish * ECC * 0

11-FEB-2010 23:48:38 * (CONNECT_DATA=(SID=ECC)(GLOBAL_NAME=ECC.WORLD)(CID=(PROGRAM=D:\usr\sap\ECC\DVEBMGS04\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceECC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2998)) * establish * ECC * 0

11-FEB-2010 23:48:38 * (CONNECT_DATA=(SID=ECC)(GLOBAL_NAME=ECC.WORLD)(CID=(PROGRAM=D:\usr\sap\ECC\DVEBMGS04\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceECC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2999)) * establish * ECC * 0

11-FEB-2010 23:48:38 * (CONNECT_DATA=(SID=ECC)(GLOBAL_NAME=ECC.WORLD)(CID=(PROGRAM=D:\usr\sap\ECC\DVEBMGS04\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceECC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=3000)) * establish * ECC * 0

12-FEB-2010 00:43:18 * (CONNECT_DATA=(SID=DEV)(GLOBAL_NAME=DEV.WORLD)(CID=(PROGRAM=D:\usr\sap\DEV\DVEBMGS03\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceDEV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2810)) * establish * DEV * 0

12-FEB-2010 00:43:19 * (CONNECT_DATA=(SID=DEV)(GLOBAL_NAME=DEV.WORLD)(CID=(PROGRAM=D:\usr\sap\DEV\DVEBMGS03\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceDEV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2811)) * establish * DEV * 0

12-FEB-2010 00:43:19 * (CONNECT_DATA=(SID=DEV)(GLOBAL_NAME=DEV.WORLD)(CID=(PROGRAM=D:\usr\sap\DEV\DVEBMGS03\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceDEV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2812)) * establish * DEV * 0

12-FEB-2010 00:43:19 * (CONNECT_DATA=(SID=DEV)(GLOBAL_NAME=DEV.WORLD)(CID=(PROGRAM=D:\usr\sap\DEV\DVEBMGS03\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceDEV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2813)) * establish * DEV * 0

12-FEB-2010 00:43:19 * (CONNECT_DATA=(SID=DEV)(GLOBAL_NAME=DEV.WORLD)(CID=(PROGRAM=D:\usr\sap\DEV\DVEBMGS03\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceDEV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2814)) * establish * DEV * 0

12-FEB-2010 00:43:19 * (CONNECT_DATA=(SID=DEV)(GLOBAL_NAME=DEV.WORLD)(CID=(PROGRAM=D:\usr\sap\DEV\DVEBMGS03\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceDEV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2816)) * establish * DEV * 0

12-FEB-2010 00:43:19 * (CONNECT_DATA=(SID=DEV)(GLOBAL_NAME=DEV.WORLD)(CID=(PROGRAM=D:\usr\sap\DEV\DVEBMGS03\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceDEV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2817)) * establish * DEV * 0

12-FEB-2010 00:43:19 * (CONNECT_DATA=(SID=DEV)(GLOBAL_NAME=DEV.WORLD)(CID=(PROGRAM=D:\usr\sap\DEV\DVEBMGS03\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceDEV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2818)) * establish * DEV * 0

12-FEB-2010 00:43:19 * (CONNECT_DATA=(SID=DEV)(GLOBAL_NAME=DEV.WORLD)(CID=(PROGRAM=D:\usr\sap\DEV\DVEBMGS03\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceDEV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2815)) * establish * DEV * 0

12-FEB-2010 00:43:19 * (CONNECT_DATA=(SID=DEV)(GLOBAL_NAME=DEV.WORLD)(CID=(PROGRAM=D:\usr\sap\DEV\DVEBMGS03\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceDEV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2819)) * establish * DEV * 0

12-FEB-2010 00:43:19 * (CONNECT_DATA=(SID=DEV)(GLOBAL_NAME=DEV.WORLD)(CID=(PROGRAM=D:\usr\sap\DEV\DVEBMGS03\exe\disp+work.EXE)(HOST=SAPDEV)(USER=SAPServiceDEV))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2820)) * establish * DEV * 0

12-FEB-2010 00:43:38 * (CONNECT_DATA=(SID=DEV)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2849)) * establish * DEV * 0

12-FEB-2010 00:43:43 * (CONNECT_DATA=(SID=DEV)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2858)) * establish * DEV * 0

12-FEB-2010 00:43:47 * (CONNECT_DATA=(SID=DEV)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2862)) * establish * DEV * 0

The problem is with the DEV system.

[Former Member · Accepted solution]

Hello-

Have you done any kernel upgrade?

there are some issues with new kernel hope this helps you...

The dialog work process may crash sporadically when you reprint from the graphic display of a spool request from transaction SP01. The same problem may also occur for the raw display of a spool request. When you forward or download a spool request, a dump ASSIGN_TYPE_ILLEGAL_CAST occurs in the function RSPO_SPOOLDATA_WRITE.

Check for the following Kernel Patch level for the respective release:

SAP KERNEL 7.00 32-BIT SP239

SAP KERNEL 7.10 32-BIT SP184

SAP KERNEL 7.00 64-BIT SP239

SAP KERNEL 7.00 64-BIT UNICODE SP239

SAP KERNEL 7.10 64-BIT UNICODE SP184

SAP KERNEL 7.10 64-BIT SP184

SAP KERNEL 7.01 64-BIT SP077

SAP KERNEL 7.01 64-BIT UNICODE SP077

SAP KERNEL 7.11 64-BIT SP071

SAP KERNEL 7.11 64-BIT UNICODE SP071

Please do not apply the following kernel patches which have been created between 23.12.2009 and 14.01.2010:

6.40 315

7.00 237, 238

7.01 75, 76

7.10 183

7.11 69, 70

The following fixed kernels are available:

6.40 Check OSS

7.00 239

7.01 77

7.10 183

7.11 71

Also check the following notes:

Note 1422843 - Wrong deletion date in spool request

Note 1425811 - Dialog work process crashes for spool display

Thanks,

George Rayi

[Former Member · Accepted solution]

Hi,

There is a problem with your SAPDEV or OPS$ user. Please see the below and other relevant notes.

[400241 - Problems with ops$ or sapr3 connect to Oracle|https://service.sap.com/sap/support/notes/400241]

Can you also post the content of tnsnames.ora and sqlnet.ora from the location

/oracle/SID/102_64/dbs/network/admin

and

/sapmnt/SID/profile/oracle

1. Are you able to ping SID (tnsping SID) from user SIDadm ?

2. Are you able to start and stop the database at OS level ?

2. Paste the content of trans.log also...

4. Paste the output of "lsnrctl status"

Regards.

Rajesh Narkhede

[former_member227283 · Accepted solution]

Hi venkat,

You application stopped automatic or you stoppped it manually ??

Did you made any changes in system , after which this error started coming.

Thanks

Anil

[Former Member]

Problem has been resloved .. Issue was CPU usage 100% so.. I added one more core for that..Now it cpu usage has reduced upto 50 -- 60%..Now i didn't get any issue to start sap server.

[Former Member]

this question has been answered

[Former Member]

Dear Venkata,

I am same problem, Please let me know ,how solved it.

Regards,

Faheem

[p330068]

Hi Venkataramana,

Check your database in the service file and change the properties with 'automatic' and start it from service.

for starting from serivce - goto control panel-administrative tool-service-here you can find you database in the list.

After checking service, try to start your server.

thanks

Arun

[Former Member]

Hi,

First of all can you let us know. What was the trigger for restarting the server. Was there any change made, or you are trying to start the server for the first time after installation. The R3trans log which you have pasted clearly points to there is some issue in your Database access.

As suggested, have you check if the Database is up and running. If so please issue the command "lsnrctl status" and paste the result. Also please provide the SID of the system you are trying to start.

Regards,

Sanujit