Disp+work processes stopped

[Former Member]

Hello friends

I have installed 4.7 in WIN 2000 SERVER. Message server is running , but the disp+workprocess starts and stops. The workprocesses are in the state ENDED. Can anyone tell me to solve this problem . A step by step by procedure will be helpfull

Here is the snap shot of Dev-disp trace file.

-

---

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

-

---

Sat Jul 25 17:15:35 2009

systemid 560 (PC with Windows NT)

relno 6200

patchlevel 0

patchno 251

intno 20020600

pid 3000

***LOG Q00=> DpSapEnvInit, DPStart (00 3000) [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 Jul 25 17:15:39 2009

• WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 4 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 ).

Sat Jul 25 17:15:40 2009

<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 575 MB

<ES> 574 blocks reserved for free list.

ES initialized.

Sat Jul 25 17:15:41 2009

***LOG Q0K=> DpMsAttach, mscon ( erp) [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 Jul 25 17:16:21 2009

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

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

Sat Jul 25 17:16:41 2009

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

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

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

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

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

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

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

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

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

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

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

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

• ERROR => W14 (pid 3168) 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 Jul 25 17:16:45 2009

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

MBUF state OFF

MBUF component DOWN

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

Regards

Sathya

[sunny_pahuja2]

Hi Sathya,

Check this thread

if you problem is not solved, Could you please also paste dev_w0 logs ?

Thanks

Sunny

[Former Member]

Hi,

Here is the snap shot of dev_w0 and dev_ms file. Kindly let me know the solution.

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Sat Aug 01 17:00:28 2009

B create_con (con_name=R/3)

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

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

B Version of 'C:\usr\sap\ERP\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 3028

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3028) [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 01 17:00:34 2009

M calling db_connect ...

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

C

C Sat Aug 01 17:00:35 2009

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

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

C Attaching to DB Server ERP (con_hdl=0,svchp=06EE8A28,svrhp=06EE8834)

C

C Sat Aug 01 17:01:09 2009

C Starting user session (con_hdl=0,svchp=06EE8A28,srvhp=06EE8834,usrhp=06F2A07C)

C

C Sat Aug 01 17:01:10 2009

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

[dboci.c 3718]

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

[dboci.c 9536]

C Try to connect with default password

C Connecting as SAPERP/<pwd>@ERP on connection 0 ...

C Starting user session (con_hdl=0,svchp=06EE8A28,srvhp=06EE8834,usrhp=06F2A07C)

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

[dboci.c 3718]

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

[dboci.c 9536]

B ***LOG BV3=> severe db error 1033 ; work process is stopped [dbsh#2 @ 957] [dbsh 0957 ]

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

B ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [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 erp_ERP_00 on host erp (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Sat Aug 01 17:01:10 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 3028) [dpnttool.c 345]

-

---

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

-

---

[Thr 2960] Sat Aug 01 17:00:15 2009

[Thr 2960] MsSSetTrcLog: trc logging not active

[Thr 2960] relno 6200

[Thr 2960] patchlevel 0

[Thr 2960] patchno 125

[Thr 2960] intno 20020600

[Thr 2960] pid 2956

[Thr 2960] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 2956) [msxxserv.c 1515]

[Thr 2960] Sat Aug 01 17:00:16 2009

[Thr 2960] MsHttpPortInsert: set HTTP state to LISTEN

[Thr 2960] *** I listen to port sapmsERP (3600) ***

[Thr 2960] *** HTTP LISTEN ***

[Thr 2960] *** I listen to HTTP port 8100 ***

[Thr 2960] CUSTOMER KEY: >U0886639124<

[Thr 2960] Sat Aug 01 17:01:26 2009

[Thr 2960] *** ERROR => MsSClientHandle: no server provides service ENQ (4), requested from erp_ERP_00 [msxxserv.c 3957]

[Thr 2960] ***LOG Q0I=> NiPRead: recv (10054: WSAECONNRESET: Connection reset by peer) [ninti.c 1091]

[Thr 2960] *** ERROR => MsSRead: NiBufReceive (rc=NIECONN_BROKEN) [msxxserv.c 8485]

[Thr 2960] *** ERROR => MsSClientHandle: MsSRead C1 (erp_ERP_00), MSEINTERN [msxxserv.c 3637]

[Thr 2988] Sat Aug 01 17:01:45 2009

[Thr 2988] MsSExit: received SIGINT (2)

[Thr 2988] ***LOG Q02=> MsSHalt, MSStop (Msg Server 2956) [msxxserv.c 4786]

[debasissahoo]

Hi,

Its giving ORA-01033. Please check if your database is up and running or not.

check if this can help.

http://www.orafaq.com/forum/t/38120/0/

Regards,

Debasis.

[Former Member]

Hi,

***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress

Check if your database is in NOMOUNT,MOUNT or in progress ot starting/stopping. Please refer OSS Note 175636 - cannot startup Oracle (with no/meaningless error(s))

For your knowledge also refer OSS Note 655240 - Composite SAP note: ORA-01033.

If you are not able to solve your problem then please post the aler_<SID>.log file .

Tnx,

Shambo

[Former Member]

Hi,

I tried the following

C:/> SQLPLUS / NOLOG

SQL> CONNECT AS SYSDBA

SQL > STARTUP NOMOUNT

SQL > ALTER DATABASE MOUNT

SQL > ALTER DATABASE OPEN

Then I started SAP application server. The problem still continues. The dispatcher stops and the work process are in ended state.

I even tried to restart the oracle database service. The problem still continues

Kindly help me to solve the problem.

Regards

N.Sathya

[markus_doehr2]

Two things I see in the logfiles:

> M relno 6200

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

1. Your kernel is out of support (620 was desupported several years ago)

2. Oracle 8i is also out of support for a LONG time (a few years).

Can you tell my why you use such ancient software installation media? Or is this an "I-bought-on-ebay"-software?

Markus

[Former Member]

hello,

please check following:

a) R3trans -d

b) check your services file in

C:\WINDOWS\system32\drivers\etc

You should see a whole list of SAP services. Make sure it also has the following entry :

sapmsSID 36nn/tcp

[Former Member]

Hi ,

I have checked the services file in C:\WINDOWS\system32\drivers.

There is a file sapmsERP 3600/tcp.

Can you tell me how to check R3trans -d .

Kindly let me know to solve the problem.

Regards

N.Sathya

[markus_doehr2]

> I have checked the services file in C:\WINDOWS\system32\drivers.

> There is a file sapmsERP 3600/tcp.

Good.

> Can you tell me how to check R3trans -d .

- login as <sid>adm

- execute "R3trans -d"

- check the resulting "trans.log" file

Your database is not coming up. Check alert<sid>.log in the saptrace\background directory.

Still - you software is ancient and no more supported.

Markus

[Former Member]

Hi,

I has executed as suggested. As Iam an ABAPER , unable to figure out the problem.

Here is the snap shot of the trans.log file.

4 ETW000 C:\usr\sap\ERP\SYS\exe\run\R3TRANS.exe version 6.07 (release 620 - 05.08.02 - 15:04:42).

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

4 ETW000

4 ETW000 date&time : 07.08.2009 - 16:15:15

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: C:\usr\sap\ERP\SYS\exe\run\R3TRANS.exe -D

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Fri Aug 07 16:15:18 2009 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0.000000

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0.000000

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ...

4 ETW000 42 0.000042

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0

4 ETW000 123424 0.123466

4 ETW000 [dev trc ,00000] using "C:\usr\sap\ERP\SYS\exe\run\dboraslib.dll"

4 ETW000 26 0.123492

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

4 ETW000 21 0.123513

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

4 ETW000 23 0.123536

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

4 ETW000 2687 0.126223

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

4 ETW000 15 0.126238

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

4 ETW000 20 0.126258

4 ETW000 [dev trc ,00000] New connection 0 created 17 0.126275

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO

4 ETW000 15 0.126290

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

4 ETW000 15 0.126305

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

4 ETW000 11 0.126316

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO

4 ETW000 14 0.126330

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=D:\oracle\ora81 from environment

4 ETW000 6225 0.132555

4 ETW000 [dev trc ,00000] -->oci_initialize 618 0.133173

4 ETW000 [dev trc ,00000] Fri Aug 07 16:15:19 2009 218625 0.351798

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC

4 ETW000 22 0.351820

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

4 ETW000 53 0.351873

4 ETW000 [dev trc ,00000] Connecting as /@ERP on connection 0 ...

4 ETW000 12 0.351885

4 ETW000 [dev trc ,00000] Allocating service context handle

4 ETW000 9253 0.361138

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

4 ETW000 27 0.361165

4 ETW000 [dev trc ,00000] Attaching to DB Server ERP (con_hdl=0,svchp=01739BA0,svrhp=017399AC)

4 ETW000 26 0.361191

4 ETW000 [dev trc ,00000] Fri Aug 07 16:15:21 2009 2809989 3.171180

4 ETW000 [dev trc ,00000] Assigning server context 017399AC to service context 01739BA0

4 ETW000 134 3.171314

4 ETW000 [dev trc ,00000] Allocating user session handle

4 ETW000 18237 3.189551

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=01739BA0,srvhp=017399AC,usrhp=0174BF1C)

4 ETW000 24 3.189575

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034

4 ETW000 1596 3.191171

4 ETW000 [dboci.c ,00000] *** ERROR => CONNECT failed with sql error '1034'

4 ETW000 16 3.191187

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

4 ETW000 16 3.191203

4 ETW000 [dev trc ,00000] Connecting as SAPERP/<pwd>@ERP on connection 0 ...

4 ETW000 13 3.191216

4 ETW000 [dev trc ,00000] Assigning username to user session 0174BF1C

4 ETW000 12 3.191228

4 ETW000 [dev trc ,00000] Assigning password to user session 0174BF1C

4 ETW000 14 3.191242

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=01739BA0,srvhp=017399AC,usrhp=0174BF1C)

4 ETW000 15 3.191257

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034

4 ETW000 967 3.192224

4 ETW000 [dboci.c ,00000] *** ERROR => CONNECT failed with sql error '1034'

4 ETW000 15 3.192239

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 1034 performing CON [dblink#1 @ 419]

4 ETW000 16774 3.209013

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-01034: ORACLE not available

4 ETW000 ORA-27101: shared memory realm does not exist [dblink#1 @ 419]

4 ETW000 35 3.209048

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

• Placing a snap shot of part of Alert.log file also .

Sun Aug 02 19:44:14 2009

ARCH: STARTING ARCH PROCESSES COMPLETE

Sun Aug 02 19:44:14 2009

ALTER DATABASE MOUNT

Sun Aug 02 19:44:15 2009

ARC0: Archival started

Sun Aug 02 19:44:20 2009

Successful mount of redo thread 1, with mount id 4237559956.

Sun Aug 02 19:44:20 2009

Database mounted in Exclusive Mode.

Completed: ALTER DATABASE MOUNT

Sun Aug 02 19:44:20 2009

ALTER DATABASE OPEN

ORA-1113 signalled during: ALTER DATABASE OPEN...

Dump file D:\oracle\ERP/saptrace/background\erpALRT.LOG

Fri Aug 07 15:30:50 2009

ORACLE V8.1.7.0.0 - Production vsnsta=0

vsnsql=e vsnxtr=3

Windows 2000 Version 5.2 , CPU type 586

Starting up ORACLE RDBMS Version: 8.1.7.0.0.

System parameters with non-default values:

processes = 80

sessions = 96

timed_statistics = TRUE

shared_pool_size = 80320921

shared_pool_reserved_size= 8032092

enqueue_resources = 8000

control_files = D:\oracle\ERP/saparch/cntrl\cntrlERP.dbf, D:\oracle\ERP/sapdata1/cntrl\cntrlERP.dbf, D:\oracle\ERP\origlogA\/cntrl\cntrlERP.dbf

db_block_buffers = 14707

db_block_size = 8192

compatible = 8.1.6

log_archive_start = TRUE

log_archive_dest = D:\oracle\ERP/oraarch/ERParch

log_buffer = 1048576

log_checkpoint_interval = 300000

log_checkpoint_timeout = 0

db_files = 254

db_file_multiblock_read_count= 32

log_checkpoints_to_alert = TRUE

control_file_record_keep_time= 30

dml_locks = 2500

transactions_per_rollback_segment= 20

max_rollback_segments = 400

rollback_segments = PRS_0, PRS_1, PRS_10, PRS_11, PRS_12, PRS_13, PRS_14, PRS_15, PRS_16, PRS_17, PRS_18, PRS_19, PRS_2, PRS_3, PRS_4, PRS_5, PRS_6, PRS_7, PRS_8, PRS_9

transaction_auditing = FALSE

remote_os_authent = TRUE

sort_area_size = 2097152

sort_area_retained_size = 0

db_name = ERP

open_cursors = 800

optimizer_mode = choose

optimizer_index_cost_adj = 10

hash_join_enabled = FALSE

background_dump_dest = D:\oracle\ERP/saptrace/background

user_dump_dest = D:\oracle\ERP/saptrace/usertrace

core_dump_dest = D:\oracle\ERP/saptrace/background

PMON started with pid=2

DBW0 started with pid=3

LGWR started with pid=4

CKPT started with pid=5

SMON started with pid=6

RECO started with pid=7

Fri Aug 07 15:30:52 2009

ARCH: STARTING ARCH PROCESSES

ARC0 started with pid=8

Fri Aug 07 15:30:52 2009

ARCH: STARTING ARCH PROCESSES COMPLETE

Fri Aug 07 15:30:52 2009

ARC0: Archival started

Fri Aug 07 15:31:50 2009

Starting ORACLE instance (normal)

Fri Aug 07 15:36:17 2009

Starting ORACLE instance (normal)

Fri Aug 07 15:38:28 2009

Shutting down instance (abort)

License high water mark = 2

Instance terminated by USER, pid = 908

Starting up ORACLE RDBMS Version: 8.1.7.0.0.

System parameters with non-default values:

processes = 80

sessions = 96

timed_statistics = TRUE

shared_pool_size = 80320921

shared_pool_reserved_size= 8032092

enqueue_resources = 8000

control_files = D:\oracle\ERP/saparch/cntrl\cntrlERP.dbf, D:\oracle\ERP/sapdata1/cntrl\cntrlERP.dbf, D:\oracle\ERP\origlogA\/cntrl\cntrlERP.dbf

db_block_buffers = 14707

db_block_size = 8192

compatible = 8.1.6

log_archive_start = TRUE

log_archive_dest = D:\oracle\ERP/oraarch/ERParch

log_buffer = 1048576

log_checkpoint_interval = 300000

log_checkpoint_timeout = 0

db_files = 254

db_file_multiblock_read_count= 32

log_checkpoints_to_alert = TRUE

control_file_record_keep_time= 30

dml_locks = 2500

transactions_per_rollback_segment= 20

max_rollback_segments = 400

rollback_segments = PRS_0, PRS_1, PRS_10, PRS_11, PRS_12, PRS_13, PRS_14, PRS_15, PRS_16, PRS_17, PRS_18, PRS_19, PRS_2, PRS_3, PRS_4, PRS_5, PRS_6, PRS_7, PRS_8, PRS_9

transaction_auditing = FALSE

remote_os_authent = TRUE

sort_area_size = 2097152

sort_area_retained_size = 0

db_name = ERP

open_cursors = 800

optimizer_mode = choose

optimizer_index_cost_adj = 10

hash_join_enabled = FALSE

background_dump_dest = D:\oracle\ERP/saptrace/background

user_dump_dest = D:\oracle\ERP/saptrace/usertrace

core_dump_dest = D:\oracle\ERP/saptrace/background

PMON started with pid=2

DBW0 started with pid=3

LGWR started with pid=4

CKPT started with pid=5

SMON started with pid=6

RECO started with pid=7

Fri Aug 07 15:38:40 2009

ARCH: STARTING ARCH PROCESSES

ARC0 started with pid=8

Fri Aug 07 15:38:40 2009

ARC0: Archival started

Fri Aug 07 15:38:40 2009

ARCH: STARTING ARCH PROCESSES COMPLETE

Fri Aug 07 15:40:41 2009

ALTER DATABASE OPEN

Fri Aug 07 15:40:41 2009

ORA-1507 signalled during: ALTER DATABASE OPEN

...

Starting ORACLE instance (normal)

Regards

sathya

[markus_doehr2]

> 4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-01034: ORACLE not available

> 4 ETW000 ORA-27101: shared memory realm does not exist [dblink#1 @ 419]

Your database is not started.

> Starting up ORACLE RDBMS Version: 8.1.7.0.0.

That version is also not supported, you need at least patchlevel 8.1.7.4 if you still insist of using such an old version. So despite what you try do with your current software level - it wont work - technically.

I understand that you are "just" ABAPer, I just have to tell you, that installing and maintaining an Oracle database (which is obsolete by its version) is very complex and you may be out of luck if you have no clue where to get patches and how to install them. You also don't follow the advise to use a supported kernel, your complete installation media is obsolete.

If you want to use R/3 4.7 then why not download recent installation media from the service marketplace, maybe even with a database that is easier to maintain (MaxDB, SQL-Server). It will save you (and eventually us here) a lot of time and frustration.

Markus

[Former Member]

Hi,

I got R/3 installed in my PC for practice two years ago. It was working fine since then. Iam unable to understand that the "Version is not supported". So you mean to say that I need to reinstall the whole thing again.

Regards

Sathya.

[markus_doehr2]

> I got R/3 installed in my PC for practice two years ago. It was working fine since then. Iam unable to understand that the "Version is not supported". So you mean to say that I need to reinstall the whole thing again.

What I mean is:

Note 1174136 - Oracle: End of Support Dates

[...]
Oracle 8.1.7	 End 2003
[...]

and

Note 803429 - Desupport 6.20 kernel

[...]
SAP terminates maintenance for the 6.20 kernel on 30 June 2005.
[...]

Why not download the current (and supported) version here from SDN?

And:

You are aware that a private installation is a violation of the license terms? There is no license for a "home installation", no license for "private use" (read the license.pdf on the installation master CD). You can be lucky if you're not sued by SAP legal.

Note: I'm not trying to offend, I just say that you are using obsolete software - illegally - so providing help here could bring the people (including me) in a troublesome situation too.

Markus

[manu_susankar]

 possible network problems detected - check tracefile and adjust the DNS settings  

[Related Forum post|;

[Try this|http://www.saptechies.com/dispatcher-fails/]

[Try with this link|http://www.sapgeeksquad.com/forum/database/sap-system-does-not-start-after-backup-t11.html?sid=15e4c7ecf1f4956e4cdb51ce12ba543b]

[See this also|http://www.saptechies.com/dispatcher-fails/].

Hope these will help you ....

Regards,

S.Manu

[Former Member]

Hi,

In order to uderstand please paste the file dev_w0.

Please let us know the db & Win2000 SP.

Tnx,

Shambo