英文:
Giving error ORA-12801: error signaled in parallel query server P008
问题
ORA-12801: error signaled in parallel query server P008
ORA-01157: cannot identify/lock data file 408 - see DBWR trace file
ORA-01110: data file 408: '+DATA/maximusp/tempfile/temp.402.dbf'
- 00000 - "error signaled in parallel query server %s"
*Cause: A parallel query server reached an exception condition.
*Action: Check the following error message for the cause, and consult
your error manual for the appropriate action.
*Comment: This error can be turned off with event 10397, in which
case the server's actual error is signaled instead.
select cl.cont_no, cl.plan_id, pl.plan_desc, con.eff_date, cl.mbr_no, mem.reg_date, cl.vou_no, PP.prepost_ind, cl.sub_status,cl.adm_date,
cl.process_date, cl.diag_code from cl_clm_hist_line cl
inner join mr_contract con on cl.cont_no=con.cont_no
inner join mr_member mem on cl.cont_no||cl.mbr_no=mem.cont_no||mem.mbr_no
inner join bt_plan pl on cl.plan_id=pl.plan_id
inner join cl_clm_hist_vou PP on cl.vou_no=PP.vou_no
where cl.process_date >= '01-Jun-23' and cl.submit_by='M' and pl.plan_desc not like '%MHP%' and PP.prepost_ind <> 'P';
英文:
ORA-12801: error signaled in parallel query server P008
ORA-01157: cannot identify/lock data file 408 - see DBWR trace file
ORA-01110: data file 408: '+DATA/maximusp/tempfile/temp.402.dbf'
12801. 00000 - "error signaled in parallel query server %s"
*Cause: A parallel query server reached an exception condition.
*Action: Check the following error message for the cause, and consult
your error manual for the appropriate action.
*Comment: This error can be turned off with event 10397, in which
case the server's actual error is signaled instead.
select cl.cont_no, cl.plan_id, pl.plan_desc, con.eff_date, cl.mbr_no, mem.reg_date, cl.vou_no, PP.prepost_ind, cl.sub_status,cl.adm_date,
cl.process_date, cl.diag_code from cl_clm_hist_line cl
inner join mr_contract con on cl.cont_no=con.cont_no
inner join mr_member mem on cl.cont_no||cl.mbr_no=mem.cont_no||mem.mbr_no
inner join bt_plan pl on cl.plan_id=pl.plan_id
inner join cl_clm_hist_vou PP on cl.vou_no=PP.vou_no
where cl.process_date >= '01-Jun-23' and cl.submit_by='M' and pl.plan_desc not like '%MHP%' and PP.prepost_ind <> 'P';
答案1
得分: 1
这意味着 +DATA/maximusp/tempfile/temp.402.dbf 临时文件不存在。如果您有数据库管理员，请通知他们以解决此问题。如果您自己是数据库管理员，解决此问题需要删除丢失的文件。幸运的是，对于临时空间，不涉及数据丢失，因此这是相当常规的操作。
最有可能的是您的参数 files=400，这意味着文件 402 实际上是临时文件 2：
ALTER TABLESPACE temp DROP TEMPFILE 2;
然后查询 dba_temp_files。如果您遇到关于不同临时文件的相同错误，请将其删除，依此类推，直到不再出现错误。如果您必须删除所有文件或需要删除的文件提供的空间，则可能需要创建新文件。
或者，您可能有另一个可用的临时表空间，如果是这样，您需要将分配的临时表空间更改为具有所有临时文件的其他表空间。例如，如果另一个可用的好的临时空间叫做 TEMP2：
ALTER USER myusername TEMPORARY TABLESPACE temp2;
然后重试您的查询。
英文:
This means the +DATA/maximusp/tempfile/temp.402.dbf tempfile does not exist. If you have a DBA, communicate this to them to address it for you. If you are your own DBA, fixing this requires dropping the missing file. Fortunately for temp space there is no data loss involved so this is rather routine.
Most likely your parameter files=400 which means file 402 is actually tempfile 2:
ALTER TABLESPACE temp DROP TEMPFILE 2;
Then query dba_temp_files. If you get the same error about a different tempfile, drop that one as well, and so on until you get no errors. You may have to create new ones if you have to drop all of them or need the space the dropped files would have provided.
Alternatively, you may have another temporary tablespace available, and if so, you need to change your assigned temporary tablespace to this other one that has all its tempfiles. For example, if the other, good temp space is called TEMP2:
ALTER USER myusername TEMPORARY TABLESPACE temp2;
Then retry your query.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论