Hi All, Thanks for the response.I was able to resolve the issue.It was basically the Oracle Version issue that was installed on the DI server.We were using Oracle version 10.2.0.3 initially which was incompatible with the Windows Server 2008 R2 Edition-64 bit.Because of it, the Oracle Drivers were not visible leading to no interaction between the SAS Application (64-bit) and the Oracle client installed as it was not able to find the drivers. Issue Resoultion Step:Applied the Patchset on the Oracle Client installed ,thereby,upgrading it to 10.2.0.5 which was compatible with the Windows Server 2008 R2 version-64-bit.Once it was not we were able to check the Oracle drivers. We reassigned the Oracle Libname statement and it was successfully connected.
... View more