Adapters like Oracle, SAP etc. are free for Biztalk, but dont get installed when you install BizTalk Server 2006. You'd need to download them from the microsoft website. They are included in a package, which contains the Oracle adapter as well. Once you download that package, follow the instructions on this link to install and configure them:
I am also having no luck finding this adapter. I have Biztalk Server 2006 Standard edition. Could it be that I need the enterprise edition or the developer's edition?