ORA-01114 ERROR:
Issue:
PeopleTools 8.52.21 - Application Engine
Server Copyright (c) 1988-2014 Oracle and/or its affiliates. All Rights
Reserved PSAESRV started service request at 18.35.24 2014-12-05 Processed Order
Request with Message ID - 000000000304166 and Order no - 900012043 (0,0) File:
/vob/peopletools/src/pspcm/pcmobuf.cppSQL error. Stmt #: 5555 Error
Position: 0 Return: 1114 - ORA-01114: IO error writing block to file
(block # ) Failed SQL stmt:INSERT INTO PS_ZZ_ITC_MSG_LOG
(OPERATIONNAME,MESSAGE_ID,KEY_FIELD_NAME_01,KEY_FIELD_NAME_02,DESCR,GUID,DATETIME_STAMP,XML_TESTI,RESENDCONTENT,MESSAGE_PARM1,OPRID)
VALUES
(:1,:2,:3,:4,:5,:6,TO_TIMESTAMP(:7,'YYYY-MM-DD-HH24.MI.SS.FF'),:8,:9,:10,:11)
SQL error. Function: Record.Insert
Error Position: 0
Return: 1114 - ORA-01114: IO error writing block to file (block # )
Error Position: 0
Return: 1114 - ORA-01114: IO error writing block to file (block # )
Cause:
Temp file Header of one of the Temporary Tablespace files is
corrupted
INST_ID
TABLESPACE_NAME
FILE_ID BYTES_USED BLOCKS_USED BYTES_FREE BLOCKS_FREE RELATIVE_FNO
---------- ------------------------------ ----------
---------- ----------- ---------- ----------- ------------
2
TEMP
2 -1.565E+11
-19108352 1.6912E+11
20644352 2
2
TEMP
3 1.0486E+10
1280000
0
0 3
2
TEMP
1 1048576 128
9662627840
1179520 1
3
TEMP
3 1.0486E+10
1280000 0
0
3
3
TEMP
1 1048576 128
9662627840
1179520 1
3
TEMP
2 -1.565E+11
-19108352 1.6912E+11
20644352 2
1
TEMP
3 1.0486E+10
1280000
0
0 3
1
TEMP
1 1048576 128
9662627840 1179520
1
1
TEMP
2 -1.565E+11 -19108352
1.6912E+11
20644352 2
-ve (Negative) Values in BYTES_USED & BLOCKS_USED
indicates Tempfile Header Corruption
Fix:
SQL> ALTER DATABASE TEMPFILE '+PRDFSCM_DG/prdfscm/tempfile/temp.463.763559877'
DROP;
Database altered.
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE
'+PRDFSCM_DG' size 11g;
Tablespace altered.
No comments:
Post a Comment