Thursday, January 17, 2013

[DAC] Oracle DAC issue in 64 Bit Machine


Environment:
DAC Client on 64 Bit Machine
OBIEE 11G
Issue:
When the Oracle DAC client was used to create the data ware house tables I got the error “Unable to connect to Database” in the DAC../log/Config folder
Cause:
The DAC component is a 32 bit component but my machine where the DAC client was installed is on 64 Bit. Hence the Oracle client components for 32 Bit is to be installed on top of the 64 bit machine so that the DAC (which is 32 bit client) can connect to the Database (To create the DWH tables).
Solution:
1) Download  and install the ODAC client components for 32 bit in your 64 bit machine where the DAC component is running.
2) Go to C:\Windows\SysWOW64
Click on odbcad32.exe to create the ODBC connection.
Specify the details in DAC for creating the tables.
Now able to create the tables.