Steps to install and use BizTalk 2009 with Oracle Adapters

Here i will add the steps involved in installing BizTalk Server 2009 and SQL Server 2008 R2 Ent Edition as Database on Windows Server 2008 R2 Operating System in a standalone server with oracle adapters.

1. Windows Server 2008 R2
2. OS Language pack
3. IIS 7.0
4. MS Office Excel 2007
5. UltraISO
6. Visual Studio Pro 2008
7. Visual Studio 2008 SP1
1. VS90sp1-KB945140-ENU
8. SQL Server 2008 Ent R2
1. SW_DVD9_SQL_Svr_Enterprise_Edtn_2008_R2_English_MLF_X16-29540
9. SQL Notification Services
1. sqlncli_x64
2. SQLServer2005_XMO_x64
3. SQLServer2005_NS_x64
10. BizTalk Server 2009 Ent
1. SW_DVD5_BizTalk_Server_Ent_2009_English_Core_MLF_X15-46665
11. Oracle instantclient_11_2
1. ODBC Instant Client Release 11.2
12. Configure Environment Variables
1. ORACLE_HOME
2. TNS_ADMIN
3. NLS_LANG
13. Create ODBC connection & test
14. ODTwithODAC1110720 (this installation is required for BizTalk, refer my blog for details http://seenstechs.blogspot.com/2011/05/oracle-database-connection-problem.html )
1. 11.1.0.7.0
15. WCL LOB Adapter
1. AdapterFramework64
2. WCF LOB Adapter SDK SP1 x64
3. WCF LOB Adapter SDK SP2 x64
16. BizTalk Adapter Pack 2.0
1. SW_CD_BizTalk_Adapter_Pack_2.0_English_MLF_X15-49578 ( installed both x86 and x64 softwares . refer my blog http://seenstechs.blogspot.com/2011/05/biztalk-2009-adpter-pack-no-valid.html for details)
17. Run Visual Studio as Administrator and create a new biztalk project, add generated items you should be able to configure oracle binding and see the schemas.

To create WebService from the orchestration you need to deploy . Run BizTlak WebService Publishing Wizard and create WebService . test it with SoapUI software (i used version soapUI-x32-3_0_1)