cancel
Showing results for 
Search instead for 
Did you mean: 

All workprocess are in to ended state

Former Member
0 Kudos

Hi ,

I have SAP 4.7 IDES with Oracle 8i , when I trying to start SAP server, all workprocess are showing endded state.

I came to know that the problem with my oracle archive directory .

Its showing error like:--"OriglogA,MirrorlogA files are mismached".

Please slove this problem...

Regards.

Prabhakar P

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI,

1. check if Oraarch directory is full

2. check the tablespaces and add datafile if it reached more than 90%

Hope this would sovle ur issue...

Former Member
0 Kudos

Yes Oraarch directory is fulled , One Tablespace is in 92% ,

I increased the tablespace size with date file , but still I am facing same problem.

We hav to delete '.DBF' files in Oraarch direcory ???

Regards,

Prabhakar P

Former Member
0 Kudos

Hi,

first check the database is running or not . if the database is not running check the log files in saptrace folder.

check this note Note 328785 - ORA-00376: File cannot be read at this time

Former Member
0 Kudos

Prabakar,

Never delete the offline redolog files with out taking backup of this files ...

what is the FS size Oraarch dir ?

Check

http://help.sap.com/saphelp_45b/helpdata/de/62/7c1998a94a11d28e160000e816c2ff/content.htm

Regards,

Gokul B

Edited by: Gokul Bhogabandi on Dec 24, 2007 6:54 PM

Answers (2)

Answers (2)

0 Kudos

Hi,

you should analyse the problem of disp+work connection failure. The reason for this you will find in the dev traces of the sap instance. Check them for connection failure. Here you should find an ORACLE returncode.

If you have problems with the archive directory (full) the system will go into a wait state. This means all disp+work processes are running and busy, not in an ended state.

get back with the message from the dev traces and we will look for the reasen.

Regards Ulrich

Former Member
0 Kudos

Hi Prabhakar,

First you have to check the oraarch directory size and after thatyou have to take the backup of that file and then only you have to delete those files except last10 or 15 files. and try to restrt the instnse.

before that you have to check the listner and database status.

with regards,

harih reddy