Tuesday, September 25, 2007

'Invalid Block Type' Reported During Default Database Install

Symptoms

Downloaded 10.2.0.3 from metalink. Oracle from OTN.

Started apply apply patch and DBCA fails with

ERROR IN WRITING TO FILE LIBJMISC.SL[INVALID BLOCK TPYE] at 11% while copying the datafiles.


Checked with metalink, this could be due to file corrupted while download.

To verify this, the download page for the patch on Metalink has a button "View Digest" which shows the checksums
of the zip file.

Patch: p5337014_10203_HP64.zip
1424057924 bytes
MD5 : AC57E417EA46F6A281B54ACC338FD86B

To check the checksum of the download with an
MD-5 checker.
Public Domain checkers are available like on
http://www.fourmilab.ch/md5/

In my case , the checksum are shown below.

F2310739DACE8F9EB7C6067A8A7A1434 (wrong md5 chksum)

AC57E417EA46F6A281B54ACC338FD86B (correct md5 chksum)



From here , I learned taht for big file, verify the Digest is really important.