I have installed Data Services XI 3.0 on windows 64 bit OS (2003 Server SP1)
It is installed successfully.
But issue is when I am trying to make data store connection with oracle client 11g, its giving error as in snapshot attached.
Possibly, the reason is that oracle 11g client is 64 bit application.
Please help me finding solution to it. Whether, issue would be resolved by installing oracle 32 bit client (with oracle database 64 bit only) on BOE server. I think would need to repair the BO installation after that.
Installing the 32bit client in additional should resolve that. A 32bit application like DI on Windows (on Unix DI is 64bit) cannot load a 64bit library.
I installed oracle 9i 32 bit client to access oracle 64 bit 11g database…
but now error changed… its “TNS cannot resolve service name”…
the OS is 64 bit windows… pl suggest… I am facing similar issue in making oracle connection in universe designer… As a resolution, I have been suggested not to install BOE in a directory having parenthesis (x86)… which is a problem of oracle middleware
This can be resolution… will try reinstlling DI and update here… waiting for your suggestions…
If I am not mistaken with the support matrix, 9i client cannot connect to 11i. And the error message you got simply means that you have a second ORACLE_HOME and hence a second tnsnames.ora file that needs to be adjusted.
On the 11i installation there should have been the 32bit client as well…
I also doubted on the connection of oracle 9i client with 11g database, but its been done from the oracle 9i client successfully, so it should be possible from BOE universe as well.
I have set the ORACLE_HOME variable in environment variables and just checked that there is not other TNSNAMES.ora in the machine.
May be need to get assistance from some oracle expert here… but will keep the forum updated on whatever output I derive.
Yes, probably even after deinstalling the previous clients of oracle, oracle home entry exists.
This can only be removed by deleting the corresponding registry variables (regedit). I did that and it showed a single oracle home.
Also, another majot issue was installation of data services in a directory having “program files (x86)”. The parenthesis are not identified - some oracle middleware concern.
Anyways, all issues resolved now. I am able to connect oracle client now.
(BOB member since 2006-08-02)
(BOB member since 2004-12-17)
(BOB member since 2006-08-02)