Hello Rajesh,
MSDN Library
The System.Data.Common namespace provides generic classes for working with data that let you write code that can work across different data providers, as long as the data is isomorphic. The programming model for writing provider-independent code is based on the use of the "factory" design pattern, which uses a single API to access databases across multiple providers.
Given this info and more available
here[
^], I suspect that the ODP is not correctly installed or not installed at all on the machine where you are hosting the site.
So go ahead and download the ODP.NET xcopy installer from
OTN website[
^]. Do remember to download the correct version. Follow the installation instructions to install the provider. There after it's just a configuration, which I am sure is done properly as it's working locally?
Sample Configuration
<system.data>
<dbproviderfactories>
<remove invariant="Oracle.DataAccess.Client" />
<add name="Oracle Data Provider for .NET">
invariant="Oracle.DataAccess.Client"
description="Oracle Data Provider for .NET"
type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
</add></dbproviderfactories>
</system.data>
Regards,