Oracle 11.2.0.2.0   RAC   ,   Linux AS 5.3   


.Net 开发的系统连接Oracle 10g ， 运行oracle 的 packages 没有问题，  今天升级到 Oracle 11.2.0.2.0 之后， 发现 .Net 程序
执行程序有问题 ，  我们将.net 程序所在的client 及 odac 连接组件都从 10g 更换为 11g 的 ， 还是报错 。  




Date  6/30/2011 3:51:34 AM
Log  Job History (TO_OTS_NPD)
Step ID  1
Server  MXOSV-OTS-AP
Job Name  TO_OTS_NPD
Step Name  T
Duration  00:01:17
Sql Severity  0
Sql Message ID  0
Operator Emailed  
Operator Net sent  
Operator Paged  
Retries Attempted  0

Message
Executed as user: MX\it.sqlagent. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.2531.0 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.  


Started:  3:51:34 AM  Error: 2011-06-30 03:51:34.68     Code: 0xC0016016     
Source:       Description: Failed to decrypt protected XML node "DTS:Password" with error
0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2011-06-30 03:51:34.70     Code: 0xC0016016     

Source:       Description: Failed to decrypt protected XML node "DTS:Password"
with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2011-06-30 03:51:34.70     Code: 0xC0016016     

Source:       Description: Failed to decrypt protected XML node "DTS:Password"
with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2011-06-30 03:51:34.71     Code: 0xC0016016     
Source:       Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2011-06-30 03:51:38.70     Code: 0xC0047062   

Source: DFMS ALL Script. Component [2182]     
Description: System.InvalidOperationException: Internal .Net Framework Data Provider error 30.     at
Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)     at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PrimeOutput(Int32 outputs,
Int32[] outputIDs, PipelineBuffer[] buffers)     at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs,
Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)  End Error  Error: 2011-06-30 03:51:38.70     Code: 0xC0047038     

Source: DFMS ALL SSIS.Pipeline     
Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "Script. Component" (2182) returned error code 0x80131509.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  
Started:  3:51:34 AM  Finished: 3:52:49 AM  Elapsed:  74.75 seconds.  The package execution failed.  The step failed.