cancel
Showing results for 
Search instead for 
Did you mean: 

In SAP Instance Disp+work not work properlly

Former Member
0 Kudos

Dear Team ,

I have fresh Installed IDES 4.7 with Oracle 8 on Windows 2003.

After sucessfull Installation . When I start my server . my disp+work not working . But when I restart Oracle via SQL Prompt.

i.e First SQL>shutdown immediate

then SQL>startup.

then again SAP Instance start.

then my SAP proper work.

what the reason I have to start Oracle restart.

I check dev_disp log.

-


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

-


Sat Aug 15 14:34:22 2009

systemid 560 (PC with Windows NT)

relno 6200

patchlevel 0

patchno 251

intno 20020600

pid 2788

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

shared lib "dw_xml.dll" version 252 successfully loaded

shared lib "dw_xtc.dll" version 252 successfully loaded

shared lib "dw_stl.dll" version 252 successfully loaded

Sat Aug 15 14:34:36 2009

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

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

MtxInit: -2 0 0

MBUF state OFF

EmInit: MmSetImplementation( 2 ).

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 1024 kByte.

Using implementation std

<EsNT> Memory Reset enabled as NT default

<EsNT> EsIUnamFileMapInit: Initialize the memory 2400 MB

<ES> 2399 blocks reserved for free list.

ES initialized.

***LOG Q0K=> DpMsAttach, mscon ( sapides) [dpxxdisp.c 8832]

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

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

DpMsgAdmin: Set release to 6200, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

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

DpMsgAdmin: Set patchno for this platform to 251

Release check o.K.

Sat Aug 15 14:35:56 2009

      • ERROR => W1 (pid 2860) died [dpxxdisp.c 11210]

      • ERROR => W2 (pid 2868) died [dpxxdisp.c 11210]

Sat Aug 15 14:36:16 2009

      • ERROR => W0 (pid 2852) died [dpxxdisp.c 11210]

      • ERROR => W3 (pid 2876) died [dpxxdisp.c 11210]

      • ERROR => W4 (pid 2884) died [dpxxdisp.c 11210]

      • ERROR => W5 (pid 2892) died [dpxxdisp.c 11210]

      • ERROR => W6 (pid 2900) died [dpxxdisp.c 11210]

      • ERROR => W7 (pid 2908) died [dpxxdisp.c 11210]

      • ERROR => W8 (pid 2916) died [dpxxdisp.c 11210]

      • ERROR => W9 (pid 2924) died [dpxxdisp.c 11210]

      • ERROR => W10 (pid 2932) died [dpxxdisp.c 11210]

      • ERROR => W11 (pid 2940) died [dpxxdisp.c 11210]

      • ERROR => W12 (pid 2948) died [dpxxdisp.c 11210]

      • ERROR => W13 (pid 2956) died [dpxxdisp.c 11210]

      • ERROR => W14 (pid 2964) died [dpxxdisp.c 11210]

      • ERROR => W15 (pid 2972) died [dpxxdisp.c 11210]

      • ERROR => W16 (pid 2980) died [dpxxdisp.c 11210]

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

      • DP_FATAL_ERROR => DpEnvCheck: no more work processes

      • DISPATCHER EMERGENCY SHUTDOWN ***

      • ERROR => DpMBufRead: state MBUF_PREPARED, opmode MBUF_USE [dpxxmbuf.c 503]

      • ERROR => DpModState: DpMBufRead failed (-1) [dpxxdisp.c 13129]

Sat Aug 15 14:36:22 2009

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 9058]

MBUF state OFF

MBUF component DOWN

***LOG Q05=> DpHalt, DPStop ( 2788) [dpxxdisp.c 7637]

Thanks

Sunil

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Sunil,

All above posts are correct and will help to solve your problem. It seems the SAP not installed properly. One friend of mine faced the same problem. I advised him to check the Java Setting (Environment variables), login through SIDADM user.

Have you changed the TCP/IP address for your machine. Check the Oracle services also.

Thanks

Lokendra

markus_doehr2
Active Contributor
0 Kudos

> All above posts are correct and will help to solve your problem. It seems the SAP not installed properly.

Oracle 8.x does not run properly on Windows 2003. This is documented in Oracle Metalink 161546.1. It was not supported and it won't be since it's out of maintenance for a long time already. There is no possiblity to "solve" the problem; it's like putting normal fuel in a diesel car, you may be able to get it inside but the car won't drive for long.

Markus

Former Member
0 Kudos

Dear Team ,

I have fresh Installed SAP IDES again.Now Its working fine.

Thanks & Regards

Sunil

Answers (3)

Answers (3)

markus_doehr2
Active Contributor
0 Kudos

> I have fresh Installed IDES 4.7 with Oracle 8 on Windows 2003.

Oracle 8 is ancient software and is not supported under Windows 2003. No matter how hard you try you will run into problems since it's unsupported (technically the database won't run on Windows 2003 correctly).

Why not download an actual version from the service marketplace with supported software? Or is this yet another "home installation"?

Markus

Former Member
0 Kudos

I

have fresh Installed IDES 4.7 with Oracle 8 on Windows 2003. After sucessfull Installation

Check the above combination is supported at [service.sap.com/pam]

Also make sure you have set the environments variables correctly, listner is up etc. Also check the user status as mentioned in the earlier post.

Former Member
0 Kudos

Dear Team,

I have check Dev_w0 log also

-


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

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, M

*

B

B Sat Aug 15 14:35:56 2009

B create_con (con_name=R/3)

B Loading DB library 'C:\usr\sap\IDE\SYS\exe\run\dboraslib.dll' ...

B Library 'C:\usr\sap\IDE\SYS\exe\run\dboraslib.dll' loaded

B Version of 'C:\usr\sap\IDE\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.112)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6200

M patchlevel 0

M patchno 251

M intno 20020600

M pid 2852

M

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

I MtxInit: -2 0 0

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation std

M <EsNT> Memory Reset enabled as NT default

X ES initialized.

M

M Sat Aug 15 14:36:01 2009

M calling db_connect ...

C Got ORACLE_HOME=D:\oracle\ora81 from environment

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

C Connecting as /@IDE on connection 0 ...

C Attaching to DB Server IDE (con_hdl=0,svchp=06B2ACE8,svrhp=06B2AAF4)

C

C Sat Aug 15 14:36:02 2009

C Starting user session (con_hdl=0,svchp=06B2ACE8,srvhp=06B2AAF4,usrhp=06B3CCEC)

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

[dboci.c 3718]

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

[dboci.c 9536]

C Try to connect with default password

C Connecting as SAPIDE/<pwd>@IDE on connection 0 ...

C Starting user session (con_hdl=0,svchp=06B2ACE8,srvhp=06B2AAF4,usrhp=06B3CCEC)

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

[dboci.c 3718]

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

[dboci.c 9536]

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

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

B ***LOG BY2=> sql error 1017 performing CON [dblink#1 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink 0419 ]

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M tid = -1

M mode = 255

M len = -1

M rq_id = -1

M rq_source = 255

M last_tid = 0

M last_mode = 0

M rfc_req = 0

M report = > <

M action = 0

M tab_name = > <

M

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

M *

M * LOCATION SAP-Server sapides_IDE_00 on host sapides (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Sat Aug 15 14:36:02 2009

M * RELEASE 620

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 8408

M * COUNTER 1

M *

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

M

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >SAP-Trace buffer write< for event BEFORE_DUMP

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

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

plz checj

sunil

Former Member
0 Kudos

SAPIDE user is not able to login successfully.

SAP Note 400241 - Problems with ops$ or sapr3 connect to Oracle

check this note thoroughly, and may be you just need to run the below command w.r.t your users in IDE version

brconnect -u system/<password> -f chpass -o <sapowner> -p <password>