cancel
Showing results for 
Search instead for 
Did you mean: 

Export with Table Splitting : ORA-01115: IO error reading block from file

Farid
Active Participant
0 Kudos

Hello,

We are in perfroming the last dryrun of our CU&UC conversion.

The are now in the process of exporting the ECC6 system (Oracle 10.2.0.4.0, HPUX ia64) using sapinst features, "table splitting preparation"

When doing so, we are facing critical errors :

Creating file /export_uni/sapinst_splitting/ora_query3_tmp3_1.sql.

ERROR 2010-08-11 10:27:28.881

CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: ORA-12801: error signaled in parallel query server P002

ORA-01115: IO error reading block from file 90 (block # 16640)

ORA-27072: File I/O error

HPUX-ia64 Error: 22: Invalid argument

Additional information: 4

Additional information: 16640

Additional information: -1

ORA-01115: IO error reading block from file 90 (block # 16640)

ORA-27072: File I/O error

HPUX-ia64 Error: 22: Invalid argument

ORA-06512: at "SAPR3.TABLE_SPLITTER", line 775

ORA-06512: at line 1

I have therefore perfmed a dbverify ; no corruption has been recorded.

When trying to perfrom the EXPORT, without table splitting ; it works fine ...but the processing time is extremely long, as you can imagine. Any help would be highly appreciated.Regards.

Raoul

Accepted Solutions (1)

Accepted Solutions (1)

stefan_koehler
Active Contributor
0 Kudos

Hello Raoul,

which exact OS level do you use? HP-UX 11i v3?

If yes please check, if OS patch PHKL_38574 is installed.

Regards

Stefan

Farid
Active Participant
0 Kudos

Thank you Stefan,

Our HPUX Release seems to be indeed 11v3,

[root@:/root]# uname -a

HP-UX B.11.31 U ia64 2566039091 unlimited-user license

I'll check the installation of the patch and keep you informed

Thank you

Raoul

Edited by: Raoul Shiro on Aug 11, 2010 11:57 AM

Farid
Active Participant
0 Kudos

It worked, the Oracle errors have disapeared after applying the patch.

thank you Stefan !

Answers (0)