dispatcher stopped

[Former Member]

Hi all,

I am trying to start IDES BI system,

dispatcher got stopped

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

This is r3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).

unicode enabled version

2EETW000 sap_dext called with msgnr "1":

2EETW000 -

---

db call info -

---

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len (char): 5

2EETW000 key: TADIR

2EETW000 retcode: 1

2EETW125 SQL error "376" during "" access: "ORA-00376: file 4 cannot be read at

this time

ORA-01110: data file 4: 'D:\ORACLE\BI1\SAPDATA2\SR3_1\SR3.DATA1'"

r3trans finished (0012).

how start dispatcher?

[Former Member]

Hi Kittu,

It seems that oracle is not able to read data file SR3.DATA1.

In first place pls check for event log for any OS related error or Hardware problems

Pls follow the procedure below in strict sequence:

1. Start SQLPLUS:

sqlplus "/ as sysdba"

2. Check whether tablespaces are set OFFLINE (only possible if the database is in OPEN state. If you cannot do this, skip steps 2 and 3, and execute them later, if required, when the database is running): SELECT TABLESPACE_NAME FROM DBA_TABLESPACES

WHERE STATUS = 'OFFLINE';

3. If tablespaces are returned, reset them to ONLINE: ALTER TABLESPACE <Tablespace_Name> ONLINE;

4. Check which data files have the status RECOVER: SELECT NAME FROM V$DATAFILE WHERE STATUS = 'RECOVER';

5. If you receive data files with the status RECOVER, recover each of these files with the following command:

RECOVER DATAFILE '<Path_and_name>';

(for example RECOVER DATAFILE

'/oracle/HX1/sapdata8/stabi_2/stabi.data2';)

6. Check which data files have the status OFFLINE:

SELECT NAME FROM V$DATAFILE WHERE STATUS = 'OFFLINE';

7. Set all these data files ONLINE:

ALTER DATABASE DATAFILE '<Path_and_Name>' ONLINE;

8. If the calls in steps 2, 4 and 6 do not return lines anymore, the problem is corrected.

Award points if helpful

Regards

Umesh