ORA-31619: Invalid Dump File When Attempting To Upload Into The AWR Warehouse
Last updated on AUGUST 19, 2015
Applies to:Enterprise Manager Base Platform - Version 18.104.22.168.0 and later
Enterprise Manager for Oracle Database - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 12.1]
Information in this document applies to any platform.
ORA-31619: invalid dump file when loading a DUMP file into the AWR Warehouse
The following message is generated when loading the dump file into the AWR Warehouse on Windows:
This error may also be accompanied by :
ORA-31640: unable to open dump file "D:\oracle\agent\agent_inst\awr_t\<dumpfile>.dmp" for read
ORA-19505: failed to identify file "D:\oracle\agent\agent_inst\awr_t\<dumpfile>.dmp"
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 22124978)
Both the AWR Warehouse database, and the source database are on Windows.
If the dump file is saved on the source database, and a test import is carried out on the source database, this is successful, suggesting that the file is created correctly.
The fix for the bug:19813287 has been applied.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms