SAP MMC disk + work Stop(Ecc6( Adap+jav),win 2003 -32 bit , oracle-10.2)

[Former Member]

Hi Friends,

I hope somebody can help.

I have an Ides Ecc6(java+adap) installation on Oracle 10..*.os win 2003 32 bit

Then I try to start the System in mmc the dispatcher is stopping (first yeloow then grey) and no error messages

when is see sys log in SAP MMC

erro: SAP-Basis System: Initialization DB-Connect Failed, Return Code 000256

when i try R3trans-d

Log:

C:\Documents and Settings\accadm>r3trans -d

This is r3trans version 6.14 (release 700 - 15.06.07 - 15:50:00)

unicode enabled version

2EETW000 sap_dext called with msgnr "2":

2EETW000 -

---

db call info -

---

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len (char): 5

2EETW000 key: TADIR

2EETW000 retcode: 2

r3trans finished (0012)

Dev_wo.lo file

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

B

B Thu Apr 16 14:07:43 2009

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\ACC\DVEBMGS00\exe\dboraslib.dll' ...

B Library 'D:\usr\sap\ACC\DVEBMGS00\exe\dboraslib.dll' loaded

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

B New connection 0 created

M sysno 00

M sid ACC

M systemid 560 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 111

M intno 20050900

M make: multithreaded, Unicode, optimized

M pid 3724

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 3724) [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 Thu Apr 16 14:07:44 2009

M DpShMCreate: sizeof(wp_adm) 18672 (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: 06810040, size: 4892312)

M DpShMCreate: allocated sys_adm at 06810040

M DpShMCreate: allocated wp_adm at 06812090

M DpShMCreate: allocated tm_adm_list at 06816980

M DpShMCreate: allocated tm_adm at 068169B0

M DpShMCreate: allocated wp_ca_adm at 06C1FDF0

M DpShMCreate: allocated appc_ca_adm at 06C25BB0

M DpShMCreate: allocated comm_adm at 06C27AF0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 06CA89B0

M DpShMCreate: allocated gw_adm at 06CA89F0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 06CA8A20

M DpShMCreate: allocated wall_adm at 06CA8A28

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 oiam

M

M Thu Apr 16 14:07:46 2009

M calling db_connect ...

C Prepending D:\usr\sap\ACC\DVEBMGS00\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 /@ACC on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 06DF1478 06DF6A14 06DF629C

C Attaching to DB Server ACC (con_hdl=0,svchp=06DF61E8,srvhp=06E07DD4)

C Starting user session (con_hdl=0,svchp=06DF61E8,srvhp=06E07DD4,usrhp=06E53768)

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

C Got SAPSR3's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=06DF61E8,usrhp=06E53768)

C Now I'm disconnected from ORACLE

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

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 06DF1478 06DF6A14 06DF629C

C Starting user session (con_hdl=0,svchp=06DF61E8,srvhp=06E07DD4,usrhp=06E53768)

C Now 'SAPSR3/<pwd>@ACC' is connected (con_hdl 0, nls_hdl 0).

C Database NLS settings: AMERICAN_AMERICA.UTF8

C DB instance ACC is running on OIAM with ORACLE version 10.2.0.1.0 since APR 16, 2009, 14:07:26

B Connection 0 opened (DBSL handle 0)

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20090416 140746 OIAM

C OCI-call failed with -1=OCI_ERROR

C SQL error 376: 'ORA-00376: file 25 cannot be read at this time

C ORA-01110: data file 25: 'D:\ORACLE\ACC\SAPDATA1\SR3_22\SR3.DATA22''

C *** ERROR => Error 376 in stmt_fetch() from oci_execute_stmt(), orpc=0

[dbsloci.c 12714]

C *** ERROR => ORA-376 occurred when executing SQL stmt (parse error offset=0)

[dbsloci.c 12733]

C sc_p=06D44E98,no=0,idc_p=00000000,con=0,act=1,slen=26,smax=256,#vars=0,stmt=06E1C138,table=SVERS

C SELECT VERSION FROM SVERS ;

C sc_p=06D44E98,no=0,idc_p=00000000,con=0,act=1,slen=26,smax=256,#vars=0,stmt=06E1C138,table=SVERS

C prep=0,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=0,upsh_p=00000000,ocistmth_p=06E0FC68

C IN : cols=0,rmax=1,xcnt=0,rpc=0,rowi=0,rtot=0,upto=-1,rsize=0,vmax=0,bound=0,iobuf_p=00000000,vda_p=00000000

C lobs=0,lmax=0,lpcnt=0,larr=00000000,lcurr_p=00000000,rret=0

C OUT: cols=1,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=0,upto=-1,rsize=144,vmax=32,bound=1,iobuf_p=003F2DC8,vda_p=06E1C3A8

C lobs=0,lmax=0,lpcnt=0,larr=00000000,lcurr_p=00000000,rret=0

C SELECT VERSION FROM SVERS ;

B ***LOG BZA=> table SVERS does not exist on database [dblink#3 @ 1299] [dblink 1299 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 004096) [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 oiam_ACC_00 on host oiam (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Thu Apr 16 14:07:46 2009

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

thanks for support

keshava

[Former Member]

Hi Rohit

-

---

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

-

---

sysno 00

sid ACC

systemid 560 (PC with Windows NT)

relno 7000

patchlevel 0

patchno 111

intno 20050900

make: multithreaded, Unicode, optimized

pid 3452

Fri Apr 17 14:17:27 2009

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

length of sys_adm_ext is 576 bytes

• SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (00 3452) [dpxxdisp.c 1239]

shared lib "dw_xml.dll" version 111 successfully loaded

shared lib "dw_xtc.dll" version 111 successfully loaded

shared lib "dw_stl.dll" version 111 successfully loaded

shared lib "dw_gui.dll" version 111 successfully loaded

shared lib "dw_mdm.dll" version 111 successfully loaded

rdisp/softcancel_sequence : -> 0,5,-1

use internal message server connection to port 3900

Fri Apr 17 14:17:32 2009

• WARNING => DpNetCheck: NiHostToAddr(www.doesnotexist0225.qqq.nxst) took 5 seconds

Fri Apr 17 14:17:36 2009

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

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

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

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

DpIPCInit2: start server >oiam_ACC_00 <

DpShMCreate: sizeof(wp_adm) 18672 (1436)

DpShMCreate: sizeof(tm_adm) 4232256 (21056)

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)

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

DpShMCreate: sizeof(slock_adm) 0 (96)

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

DpShMCreate: sizeof(file_adm) 0 (72)

DpShMCreate: sizeof(vmc_adm) 0 (1536)

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

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: SHM_DP_ADM_KEY (addr: 06810040, size: 4892312)

DpShMCreate: allocated sys_adm at 06810040

DpShMCreate: allocated wp_adm at 06812090

DpShMCreate: allocated tm_adm_list at 06816980

DpShMCreate: allocated tm_adm at 068169B0

DpShMCreate: allocated wp_ca_adm at 06C1FDF0

DpShMCreate: allocated appc_ca_adm at 06C25BB0

DpShMCreate: allocated comm_adm at 06C27AF0

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 06CA89B0

DpShMCreate: allocated gw_adm at 06CA89F0

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 06CA8A20

DpShMCreate: allocated wall_adm at 06CA8A28

MBUF state OFF

DpCommInitTable: init table for 500 entries

Fri Apr 17 14:17:37 2009

EmInit: MmSetImplementation( 2 ).

MM global diagnostic options set: 0

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 1024 kByte.

Using implementation view

<EsNT> Using memory model view.

<EsNT> Memory Reset disabled as NT default

<ES> 511 blocks reserved for free list.

ES initialized.

J2EE server info

start = TRUE

state = STARTED

pid = 3652

argv[0] = D:\usr\sap\ACC\DVEBMGS00\exe\jcontrol.EXE

argv[1] = D:\usr\sap\ACC\DVEBMGS00\exe\jcontrol.EXE

argv[2] = pf=D:\usr\sap\ACC\SYS\profile\ACC_DVEBMGS00_oiam

argv[3] = -DSAPSTART=1

argv[4] = -DCONNECT_PORT=1045

argv[5] = -DSAPSYSTEM=00

argv[6] = -DSAPSYSTEMNAME=ACC

argv[7] = -DSAPMYNAME=oiam_ACC_00

argv[8] = -DSAPPROFILE=D:\usr\sap\ACC\SYS\profile\ACC_DVEBMGS00_oiam

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 1629]

***LOG Q0K=> DpMsAttach, mscon ( oiam) [dpxxdisp.c 11753]

DpStartStopMsg: send start message (myname is >oiam_ACC_00 <)

DpStartStopMsg: start msg sent

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

CCMS: Initalizing shared memory of size 60000000 for monitoring segment.

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

DpMsgAdmin: Set release to 7000, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1050]

DpMsgAdmin: Set patchno for this platform to 111

Release check o.K.

Fri Apr 17 14:17:38 2009

DpJ2eeLogin: j2ee state = CONNECTED

Fri Apr 17 14:18:25 2009

MBUF state ACTIVE

DpModState: change server state from STARTING to ACTIVE

Fri Apr 17 14:19:53 2009

J2EE server info

start = TRUE

state = ACTIVE

pid = 3652

http = 50000

https = 50001

load balance = 1

start_lazy = 0

start_control = SAP J2EE startup framework

[Former Member]

Hi Rohit

Thanks for your support and quick reply .

As per your mail I applied notr 328785. SAP is working fine.i can loging to SAP GUI

But in SAP MMC disk+ work still in yellow. I unable to see any abap Work pross.

Iu2019ll appreciate if you any provide the sama

Reagrds

keshava

[Former Member]

hi kESHAVA,

Post your dev_w0 and disp_w0 log file,that might be of some help

Have you recently performed any activity on SAP server

Rohit

[Former Member]

Hi Rohit

Thanks for your support and quick reply .

As per your mail I applied notr 328785. SAP is working fine.i can loging to SAP GUI

But in SAP MMC disk+ work still in yellow. I unable to see any abap Work pross.

Iu2019ll appreciate if you any provide the sama

Reagrds

keshava

[Former Member]

Hi,

SQL error 376: 'ORA-00376: file 25 cannot be read at this time C ORA-01110: data file 25: 'D:\ORACLE\ACC\SAPDATA1\SR3_22\SR3.DATA22'' C *** ERROR => Error 376 in stmt_fetch() from oci_execute_stmt(), orpc=0 [dbsloci.c 12714] C *** ERROR => ORA-376 occurred when executing SQL stmt

Looks like data file is offline or not accessible. Did you check all the drives are accessible via windows explorer?

ORACLE version 10.2.0.1.0

This version is not supported. I would suggest you to patch it to 10.2.0.2.0

Check your listner, ORACLE_HOME etc

Hope this helps.

Manoj

[Former Member]

Hello Keshava,

Refer to Note 328785,it contains the problem what are you facing and the solution for that

There seems to be a problem when Oracle is reading the data file

'D:\ORACLE\ACC\SAPDATA1\SR3_22\SR3.DATA22''

Follow the note,it will probably solve your issue

Rohit