ORA-01110: data file has been detected in MO_GLOBAL.INIT in Oracle Apps

Error:
ORA-01110: data file has been detected in MO_GLOBAL.INIT in Oracle Apps when running the concurrent jobs .


Solution:

From v$tempfile , Files are there but still I am getting the issue

 

This issue occurred due to one of temporary tablespace group temp file not there.

SQL> select
tablespace_name, group_name
from
DBA_TABLESPACE_GROUPS; 2 3 4

TABLESPACE_NAME GROUP_NAME
—————————— ——————————
TEMP1 TEMP
TEMP2 TEMP

select file_name from dba_temp_files where TABLESPACE_NAME=’TEMP2′;

no rows selected

 

Add tempfile to temp2 also

SQL> alter tablespace temp2 add tempfile ‘/u01/apps/db/apps_st/data/temp02.dbf’ size 5G autoextend on;

Tablespace altered.







If you like please follow and comment