Forum Discussion
Unable to connect using Oracle database even after ODAC install.
Alrighty...Finally got it to work.
Installed 64bit runtime client 12.2. Then installed ODAC122010_x64. INTO THE SAME ORACLE HOME.
By default ODAC tries to install itself into a new Oracle Home. Which doesn't work.
Alrighty...Finally got it to work.
Installed 64bit runtime client 12.2. Then installed ODAC122010_x64. INTO THE SAME ORACLE HOME.
By default ODAC tries to install itself into a new Oracle Home. Which doesn't work.
This might be beneficial to other community members, you may help accept the solution above. Your contribution is highly appreciated.
Hi! I believe I have the same issue. I installed ODAC and as a result I got a client_2 in addition to client_1 in the C:\app\client\windowsusername\product\12.2.0
Is this what you refer to as oracle home the the ODAC should have installed in client_1 folder. How do I achieve this in the installation? (I guess I have to specify some other than the default path).
I have installed a complete test environment on my virtual PC consisting of oracle database, oracle business intelligence servers. So I probaly have another scenario than end users that do not run the DB server and fusion middelware on the computer.
I have had a lot of problems during installation of these components but have always figures a way around it, so I guess you have found the answer to this final issue of the Power BI / Oracle test envrionment installation.
Thanks for the help. I now installed a second time (using VM machine I could revert to before the first installation) then I change the installation path to client_1 instead of client_2. I got past the messages saying I did not have correct ODAC installed.
I also now managed to get it work by having the two clients client_1 and client_2. I then used the downloadable PBI client and isntalled ODAC with the tick for sharing installation on the machine.
Hey dramus , can you please paste in the links for the downloads you performed? Both the Runtime and ODAC?
It looks like Oracle have removed the links for the Oracle 12.2 Client from thrir Software downloads page. You have to request it now.
I'll try installing with the latest version and report back here.
So, I am really new to this stuff and there seems to be several files to download, can you refer me to the link in Oracel or file name of what I should download? Thanks for responding, your post is a few years old now lol
