Since your question relates to third party software (Oracle) I cannot say whether your code should be using both Oracle 9 and Oracle 12 or only binaries from one version.
The System Error message indicates that your code is using load-time linking for the Oracle dlls. From what has been said it seems that the Debug configuration is using Oracle 9 and the Release configuration is using Oracle 12. This apparently contradicts the statement "But, we will be using only orasql12.lib only." So you need to resolve this inconsistency for your Oracle usage and configure your project properties accordingly. As @Viorel has pointed out VS maintains separate project property settings for the various combinations of Platform/Configuration so make sure that you are adjusting the properties for the correct combinations. Sometimes its easier to adjust properties for All Platforms and All Configurations.
As far as the run-time System Error is concerned, this indicates that the dlls in the error messages could not be located by the system when the .exe is loaded. You need to verify the file system location of the indicated Oracle dlls and ensure that location is one that will be searched by the system when loading dlls at run-time. The system search order is documented at Dynamic-link library search order.