Maybe. But having gone back and checked - I also get the same error message on another oracle database that has a simple connection (connects to the same copy database in both DEV and PROD environments), so there must be something more to it.
My amazingly wonderful tech support who does all the migration, CMC & security stuff has wandered off. Hopefully he’ll be along by here at some point. (Flattery gets me everywhere…)
Debbie
Debbie 
(BOB member since 2005-03-01)
I hate to even stick my foot in because of my ignorance in LCM, but I’ve seen similar errors with oracle due to Path problems to Oracle home. I had to set that on the client machines in Designer, on my server for Webi.
Also, if there is anyting custom in any oracle configuration (the .SBO file, for example) - if that’s not consistent, you may see something similar.
Just putting that out, in case it’s that simple. If not, disregard : )
B
bdouglas 
(BOB member since 2002-08-29)
That’ll be me then! 
When I’ve discussed with Debbie, I’ve pointed out that I think its my lack of experience with LCM (which as a tool, is fairly easy to use) and best practise with regards to migration etc.
When I’ve moved back to the Import Wizard, thats moved the Universes fine.
I’m on the look out for some kind of tutorial or best practise for the LCM tool! So if you know of one, please let me know!
ChrisOnesBroken (BOB member since 2011-06-08)
For LCM info see here: http://wiki.sdn.sap.com/wiki/display/BOBJ/From+DEV+to+QA+to+PROD+using+LifeCycle+Manager
Andreas 
(BOB member since 2002-06-20)
It seems to have “reset” something quite fundamental. None of my universes now work in prod!
Debbie
Debbie (BOB member since 2005-03-01)
Update:
We tried migrating all the universe again using the wizard. But still nothing works in prod. Looks like LCM has definitely reset something somewhere!
On my pc, I checked the connections in dev & prod. All work OK. Then I remembered that they’d be using DSNs and settings on my hard disk, so I logged onto Designer on the actual servers. And sure enough - the connections on the dev server are fine, but all the connections on the prod server are broken with the same dll/dsn errors.
I don’t want to rebuild connections in prod since they get overwritten from dev on every migration. But the ones in dev are fine - yet migrating them doesn’t fix the issue.
Any clues? We’re in the dark here, though fortunately the R3 system isn’t yet live!
Debbie
Debbie (BOB member since 2005-03-01)
Did you find out whether you are mapping the connections to Prod in LCM? I believe you have carried over the Dev connections?
What are they pointing to in Prod Designer on the server?
Mak 1 (BOB member since 2005-01-06)
Right now, I don’t care what LCM is doing - just want to get prod working again! 
I can’t see what the connections are pointing to in prod designer since it just flashes up the error message as soon as you click on anything…
Debbie
Debbie (BOB member since 2005-03-01)
I was thinking you could remap, via LCM, pointing the connections to the Prod data sources?
Maybe, you could run this, on the server, to get the connection details.
https://bobj-board.org/t/185750
Mak 1 (BOB member since 2005-01-06)
Andreas - thanks for that guide. That all makes sense, but I’m still unsure in what circumstances to migrate what using the LCM. :?
With regards to the:
CS: DBDriver failed to load : D:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\dbd_oci.dll (%1 is not a valid Win32 application.
)Error, I’ve searched and found a thread on the SAP forums here:
http://forums.sdn.sap.com/thread.jspa?threadID=1576010&start=15&tstart=0
…and I found that the path listed in the above error message wasn’t in the PATH system variable, so I’ve added it, but it doesnt seem to have made much of a difference.
ChrisOnesBroken (BOB member since 2011-06-08)
Do you have a reference to the oracle path in your PATH variable?
It’s pure voodoo, but look for references on that - don’t waste a lot of time on it, but at least eliminate it as an issue… I think you need a path down to oracle home\bin.
B
bdouglas (BOB member since 2002-08-29)
There is an Oracle reference in the PATH variable:
D:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\;D:\oracle\product\10.2.0\client_1\bin;D:\oracle\product\10.2.0\client_1;%SystemRoot%\system32;%SystemRoot%\System32\Wbem;C:\Program Files (x86)\Subversion\bin…and this is the content of the PATH variable on my DEV machine:
D:\oracle\product\10.2.0\client_1\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files (x86)\Subversion\binEDIT: I’ve reinstalled the Oracle 10g client, and this hasnt helped either.
ChrisOnesBroken (BOB member since 2011-06-08)
When I try to create a webi report in 4. I am getting DB driver failed to load. DBD_oci.dll is not a valid 32 bit application. I reinstalled the Oracle database in my system. Still facing the same issue.
surya_sudheer 
(BOB member since 2006-11-01)
Have you installed 32 bit and 64 bit Oracle client?
Please read through this to ensure correct config:-
http://www.dallasmarks.org/blog/2012/08/installing-two-oracle-clients-on-one-server/
Mak 1 (BOB member since 2005-01-06)
I have installed only one oracle 64 bit in my system. At first I have installed oracle 10g. But after some research in google I have uninstalled oracle 10g and installed oracle 11g.But still Iam facing the same issue. The system details are:
OS: Windows server 2008
SAP BO: BOBI 4.0
DB: Oracle 11g
surya_sudheer (BOB member since 2006-11-01)
Please read the posts, you need 32bit and 64 bit Oracle + the correct Oracle environmental variable definitions, paths etc.
http://scn.sap.com/thread/2101749
http://scn.sap.com/thread/3402522
Mak 1 (BOB member since 2005-01-06)
I have installed 10g 32 bit in my system and my os is windows 2008 server 64 bit.
surya_sudheer (BOB member since 2006-11-01)
Really confused now. Have you got 10 or 11g Oracle on there? Whatever it is it should be the same for 32 and 64 bit.
Have you set the Oracle paths, home etc. correctly?
http://scn.sap.com/thread/1576010
Mak 1 (BOB member since 2005-01-06)
It was oracle 10g and I have set the paths correctly. Oracle 10g was 32 bit on 64 bit OS
surya_sudheer (BOB member since 2006-11-01)
OK so do you actually have both 32 and 64 bit 10g Oracle clients on there now?
Then you have to confugure the home path to refer to both the 32bit and 64 bit. Try reading the SAP notes in the following post:-
http://scn.sap.com/thread/3252524
Please post the path you are using.
Mak 1 (BOB member since 2005-01-06)