Error while restarting SAP system

[Former Member]

Hai Experts,

We are running ECC 6.0 on Windows 2003 server with Oracle Database.This evening When we restarted the system, Iam getting an error DP_FATAL_ERROR.The SAP is not coming up.Could you please help us to solve this issue??

Here Iam pasting the trace file for your reference..

Tue May 08 18:37:49 2007

• WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds

***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 5277]

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

DpSysAdmExtInit: VMC (JAVA VM in WP) is not active

DpIPCInit2: start server >sapserver_B60_01 <

DpShMCreate: sizeof(wp_adm) 16896 (1408)

DpShMCreate: sizeof(tm_adm) 3994272 (19872)

DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

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

DpShMCreate: sizeof(comm_adm) 528064 (1048)

DpFileTableSize: max/headSize/ft

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: SHM_DP_ADM_KEY (addr: 05E60040, size: 4651960)

DpShMCreate: allocated sys_adm at 05E60040

DpShMCreate: allocated wp_adm at 05E61E40

DpShMCreate: allocated tm_adm_list at 05E66040

DpShMCreate: allocated tm_adm at 05E66070

DpShMCreate: allocated wp_ca_adm at 06235310

DpShMCreate: allocated appc_ca_adm at 0623B0D0

DpShMCreate: allocated comm_adm at 0623D010

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 062BDED0

DpShMCreate: allocated gw_adm at 062BDF10

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 062BDF40

DpShMCreate: allocated wall_adm at 062BDF48

MBUF state OFF

DpCommInitTable: init table for 500 entries

EmInit: MmSetImplementation( 2 ).

MM global diagnostic opti

chaitanya Lavu: Tue May 08 18:37:50 2007

J2EE server info

start = TRUE

state = STARTED

pid = 3632

argv[0] = D:\usr\sap\B60\DVEBMGS01\exe\jcontrol.EXE

argv[1] = D:\usr\sap\B60\DVEBMGS01\exe\jcontrol.EXE

argv[2] = pf=D:\usr\sap\B60\SYS\profile\B60_DVEBMGS01_sapserver

argv[3] = -DSAPSTART=1

argv[4] = -DCONNECT_PORT=1061

argv[5] = -DSAPSYSTEM=01

argv[6] = -DSAPSYSTEMNAME=B60

argv[7] = -DSAPMYNAME=sapserver_B60_01

argv[8] = -DSAPPROFILE=D:\usr\sap\B60\SYS\profile\B60_DVEBMGS01_sapserver

argv[9] = -DFRFC_FALLBACK=ON

argv[10] = -DFRFC_FALLBACK_HOST=localhost

start_lazy = 0

start_control = SAP J2EE startup framework

DpJ2eeStart: j2ee state = STARTED

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1625]

Tue May 08 18:37:57 2007

CCMS: start to initalize 3.X shared alert area (first segment).

DpJ2eeLogin: j2ee state = CONNECTED

Tue May 08 18:38:32 2007

***LOG Q0I=> NiIRead: recv (10054: WSAECONNRESET: Connection reset by peer) [nixxi.cpp 4242]

• ERROR => NiIRead: SiRecv failed for hdl 3 / sock 1536

(SI_ECONN_BROKEN; I4; ST; 127.0.0.1:1069) [nixxi.cpp 4242]

DpJ2eeMsgProcess: j2ee state = CONNECTED (NIECONN_BROKEN)

DpIJ2eeShutdown: send SIGINT to SAP J2EE startup framework (pid=3632)

• ERROR => DpProcKill: kill failed [dpntdisp.c 371]

DpIJ2eeShutdown: j2ee state = SHUTDOWN

Tue May 08 18:38:40 2007

• ERROR => MsIAttachEx: NiBufConnect to sapserver/3901 failed (rc=NIECONN_PENDING) [msxxi.c 652]

J2EE server info

start = TRUE

state = STARTED

pid = 744

KP - The Cool Breeze: sare ra'

chaitanya Lavu: argv[0] = D:\usr\sap\B60\DVEBMGS01\exe\jcontrol.EXE

argv[1] = D:\usr\sap\B60\DVEBMGS01\exe\jcontrol.EXE

argv[2] = pf=D:\usr\sap\B60\SYS\profile\B60_DVEBMGS01_sapserver

argv[3] = -DSAPSTART=1

argv[4] = -DCONNECT_PORT=1126

argv[5] = -DSAPSYSTEM=01

argv[6] = -DSAPSYSTEMNAME=B60

argv[7] = -DSAPMYNAME=sapserver_B60_01

argv[8] = -DSAPPROFILE=D:\usr\sap\B60\SYS\profile\B60_DVEBMGS01_sapserver

argv[9] = -DFRFC_FALLBACK=ON

argv[10] = -DFRFC_FALLBACK_HOST=localhost

start_lazy = 0

start_control = SAP J2EE startup framework

DpJ2eeStart: j2ee state = STARTED

DpJ2eeLogin: j2ee state = CONNECTED

chaitanya Lavu: Tue May 08 18:39:00 2007

• ERROR => MsIAttachEx: NiBufConnect to sapserver/3901 failed (rc=NIECONN_PENDING) [msxxi.c 652]

• ERROR => W0 (pid 3640) died [dpxxdisp.c 14299]

• ERROR => W1 (pid 3648) died [dpxxdisp.c 14299]

• ERROR => W2 (pid 3656) died [dpxxdisp.c 14299]

• ERROR => W3 (pid 3664) died [dpxxdisp.c 14299]

• ERROR => W4 (pid 3672) died [dpxxdisp.c 14299]

• ERROR => W5 (pid 3680) died [dpxxdisp.c 14299]

my types changed after wp death/restart 0xbf --> 0xbe

chaitanya Lavu: *** ERROR => MsIModTypes: not_attached [msxxi.c 1834]

• ERROR => W6 (pid 3688) died [dpxxdisp.c 14299]

my types changed after wp death/restart 0xbe --> 0xbc

• ERROR => MsIModTypes: not_attached [msxxi.c 1834]

• ERROR => W7 (pid 3696) died [dpxxdisp.c 14299]

my types changed after wp death/restart 0xbc --> 0xb8

• ERROR => MsIModTypes: not_attached [msxxi.c 1834]

• ERROR => W8 (pid 3704) died [dpxxdisp.c 14299]

chaitanya Lavu: *** ERROR => W9 (pid 3712) died [dpxxdisp.c 14299]

my types changed after wp death/restart 0xb8 --> 0xb0

• ERROR => MsIModTypes: not_attached [msxxi.c 1834]

• ERROR => W10 (pid 3720) died [dpxxdisp.c 14299]

my types changed after wp death/restart 0xb0 --> 0xa0

• ERROR => MsIModTypes: not_attached [msxxi.c 1834]

• ERROR => W11 (pid 3728) died [dpxxdisp.c 14299]

my types changed after wp death/restart 0xa0 --> 0x80

• ERROR => MsIModTypes: not_attached [msxxi.c 1834]

• DP_FATAL_ERROR => DpWPCheck: no more work processes

• DISPATCHER EMERGENCY SHUTDOWN ***

Help is much Appreciated.

Thanks in Advance

Krishna

[Former Member]

Check firewall settings as suggested above. After restart Windows could have made there some changes. Shut it down completely for a moment and try starting up your SAP.

Regards,

FS

[former_member204746]

please provide sqlnet.ora, tnsnames.ora and listener.ora

[Former Member]

do you have an active firewall configured?

[Former Member]

yet to get solution..Partly answered

[Former Member]

Goodmorning Soft,

Did you check if your Listener was started automatically after the reboot?

It is installed with the default "manually" setting.

If not, stop SAP and Oracle. Set it to "automatically" in the "Services" and start Oracle and SAP again.

Kind regards,

Albert Claproth

[Former Member]

Hello Albert,

yes the TNS listner service is in automatic mode only and is running fine when we have restarted the system. However there is a problem with "OracleB60102iSQLPlus" service. Whenever we are trying to start, it gives an error like "couldn't start the OracleB60102iSQLPlus service on local computer: and Error 1067: the process is terminated unexpectedly."

Could anyone advice me on this ...

Thanks in advance,

chaitanya.

[Former Member]

OracleB60102iSQL*Plus sevice is not needed. You can disable it.

You can use this service to access sqlplus functionality using a web browser.

as sqlplus is used in commandline mode only within SAP - this service is not needed.

regards

Peter

[Former Member]

Thank you Peter,

But what could be the problem now. I could start db from cmd using scott/tiger as sysdba... DB is mounted and opened. All environmental variables are fine and profile parameters as well. Network connectivity is good. Tried so many solutions but dispatcher is not coming up.

Any possible solutions to resolve this ... ?

Thanks,

Chaitanya.

[andreas_herzog]

-> plz check connection via

> R3trans -d (as user <sid>adm)

-> can you ping your sap server via ip address as well as through the hostname?

-> what about your hosts file? everything complete?

GreetZ, AH

[former_member204746]

more useful information can be found in file dev_w0, please post it here.

[Former Member]

HI Eric,

Thanks a ton for the reply..Here iam pasting the contents of dev_wo for your reference.Please let us know the solution..Eagerly waiting for your reply.

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

B

B Tue May 08 20:10:40 2007

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\B60\DVEBMGS01\exe\dboraslib.dll' ...

B Library 'D:\usr\sap\B60\DVEBMGS01\exe\dboraslib.dll' loaded

B Version of 'D:\usr\sap\B60\DVEBMGS01\exe\dboraslib.dll' is "700.08", patchlevel (0.80)

B New connection 0 created

M sysno 01

M sid B60

M systemid 560 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 83

M intno 20050900

M make: multithreaded, Unicode, optimized

M pid 2340

M

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

M length of sys_adm_ext is 572 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2340) [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 Tue May 08 20:10:41 2007

M DpShMCreate: sizeof(wp_adm) 16896 (1408)

M DpShMCreate: sizeof(tm_adm) 3994272 (19872)

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 DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1440)

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

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 05E60040, size: 4651960)

M DpShMCreate: allocated sys_adm at 05E60040

M DpShMCreate: allocated wp_adm at 05E61E40

M DpShMCreate: allocated tm_adm_list at 05E66040

M DpShMCreate: allocated tm_adm at 05E66070

M DpShMCreate: allocated wp_ca_adm at 06235310

M DpShMCreate: allocated appc_ca_adm at 0623B0D0

M DpShMCreate: allocated comm_adm at 0623D010

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 062BDED0

M DpShMCreate: allocated gw_adm at 062BDF10

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 062BDF40

M DpShMCreate: allocated wall_adm at 062BDF48

X

X Tue May 08 20:10:42 2007

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M ThInit: running on host sapserver

M

M Tue May 08 20:10:43 2007

M calling db_connect ...

C Prepending D:\usr\sap\B60\DVEBMGS01\exe to Path.

C Oracle Client Version: '10.2.0.1.0'

C Client NLS settings: AMERICAN_AMERICA.UTF8

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

C Connecting as /@B60 on connection 0 (nls_hdl 0) ... (dbsl 700 250806)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 063FFE58 064053F4 06404C7C

C Attaching to DB Server B60 (con_hdl=0,svchp=06404BC8,svrhp=06416494)

C

C Tue May 08 20:11:04 2007

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12170

[dboci.c 4172]

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

[dbsloci.c 10933]

C Try to connect with default password

C Connecting as SAPSR3/<pwd>@B60 on connection 0 (nls_hdl 0) ... (dbsl 700 250806)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 063FFE58 064053F4 06404C7C

C Detaching from DB Server (con_hdl=0,svchp=06404BC8,srvhp=06416494)

C Attaching to DB Server B60 (con_hdl=0,svchp=06404BC8,svrhp=06416494)

C

C Tue May 08 20:11:26 2007

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12170

[dboci.c 4172]

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

[dbsloci.c 10933]

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

B ***LOG BY0=> ORA-12170: TNS:Connect timeout occurred [dbsh#2 @ 1204] [dbsh 1204 ]

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

B ***LOG BY0=> ORA-12170: TNS:Connect timeout occurred [dblink#3 @ 431] [dblink 0431 ]

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source = 255

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 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 vm = no VM

M

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

M *

M * LOCATION SAP-Server sapserver_B60_01 on host sapserver (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Tue May 08 20:11:26 2007

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10404

M * COUNTER 1

M *

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

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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 2340) [dpnttool.c 327]

[Former Member]

Hi,

TNS-12170 TNS:Connect timeout occurred

Cause: The server shut down because connection establishment with a client

failed to complete within the allotted time interval. This may be a result of

network/system delays; or this may indicate that a malicious client is trying to

cause a Denial of Service attack on the server.

Action: If the error occurred because of a slow network/system, then

reconfigure the "sqlnet.connect_timeout" parameter in sqlnet.ora to a larger

value. If a malicious client is suspected, then use the address in sqlnet.log to

identify the source and restrict access. Note that logged addresses may not be

reliable as they can be forged (that is, in TCP/IP).

regards

Umesh K