Hi,
Environment Details.
Oracle Version: 11.2.0.4
Server Hosting Biztalk Application: Windows Server 2003
Siebel CRM Application: 8.1.1.8
There are different source systems(AS400, Custom Appliactions) wherein data comes into Biztalk and Posted to Siebel CRM Application.
The posting of data fails with below Error. If the data is selected using biztalk interface and pushed explicitly Data is successfully migrated to Siebel.
"
- Microsoft.ServiceModel.Channels.Common.ConnectionException:
ORA-12541: TNS:no listener ---> Oracle.DataAccess.Client.OracleException
ORA-12541: TNS:no listener at
Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode,
OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object
src, String procedure)
at
Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode,
OracleConnection conn, IntPtr opsErrCtx, Object src)
at Oracle.DataAccess.Client.OracleConnection.Open()
at
Microsoft.Adapters.OracleCommon.OracleCommonConnectionWrapper..ctor(String
connectionString, OracleCommonExecutionHelper executionHelper)
at
Microsoft.Adapters.OracleDB.OracleDBConnection.Microsoft.ServiceModel.Channels.Common.IConnection.Open(TimeSpan
timeout)
--- End of inner
exception stack trace ---
Server stack trace:
at
Microsoft.Adapters.OracleDB.OracleDBConnection.Microsoft.ServiceModel.Channels.Common.IConnection.Open(TimeSpan
timeout)
at Microsoft.ServiceMode