You’ll need to look at the Product Availability Matrix (PAM) for information about which version of database client will work with your version of BOBJ.
Also, all of the client tools are 32-bit so you’ll need to have the 32-bit Oracle client installed on the machine(s) where you’re using the UDT or IDT. However, with the exception of the Crystal2016 servers, everything else in the BI platform is 64-bit so you’ll need to have the 64-bit version of the client installed on the servers where BOBJ is installed.
Unlike 3.1 and earlier, best practice is to NOT install any of the client tools on the servers where the BI Platform is running. One reason for this is so that you don’t have to install both “bit-nesses” of DB clients.
After performing the following, a new error message:
The server is not responding SBO0001
Do we need to install both the 64 bit and 32 bit Oracle clients on the server? Should we also do this on the client machine? Does it matter if Oracle is installed on the C: drive or D: drive?
We created the connection using the UDT, and the test was successful. After creating the connection, when we attempt to apply it to a new universe or an existing one, it produces the message:
The server is not responding! (SBO00001)
CS: Unexpected behavior
I actually tried to install both the 32-bit and 64-bit on the server. However, this was not possible as it noted that a current installation exists.
Desperate at this point, I was able to even successfully create an ODBC connection with Oracle. But again, when I use designer, it generates the same error message as stated above.
I will give that a shot as soon as I can. I’m knee-deep in some Universe work. I’ll keep the 64-bit Oracle client with the BO Server installation on our Windows, and do everything you suggested on my client machine.
Hi Jemstar,
The environment variable is calling the 64-bit Oracle client on the server. I will reboot the entire server after I do the client updates on my laptop.
Thanks for the suggestions guys! Crossing my finger this works.
Hi Indy- am having the same issue with my designer client in my desktop. Basically I was trying to get 64 bit client for Toad and uninstalled 32 bit client. After realizing that designer needs 32 bit client, we got it back and uninstalled 64 but. Since then It’s unable to connect or locate the 32 bit oracle client. Environment variable is good. I was able to verify oracle client installation is good. Can you please explain what worked for you? Did you just follow Joe’s suggestion?