Installing Two Oracle 12c Clients on One Server

The Oracle 12c 32-bit client requires a little bit of extra attention.

I’ve previously written about best practices for installing the 64-bit and 32-bit Oracle clients on a single Microsoft Windows server that needs to support SAP BusinessObjects BI 4 (see related article, Installing Two Oracle Clients on One Server). Those best practices still apply, but I encountered a small wrinkle with Oracle 12c and apparently I’m not the only one.

The installation of the 64-bit client goes smoothly. It’s only when you attempt to install the 32-bit client that you may encounter the following error, “[INS-10102] Installer initialization failed.”

Oracle 12 32 bit trick 01 500The issue seems to occur when a previous installation of the Oracle 32-bit client (for example, the older 11g client) was previously installed. The registry key named HKEY_LOCAL_MACHINESOFTWAREORACLE has a value named inst_loc behind, which interferes with the Oracle 12c 32-bit installation.

Oracle 12 32 bit trick 02 500

Simply remove the offending inst_loc value from the registry.

Oracle 12 32 bit trick 03 500

Then you’ll be able to install the 32-bit client successfully.

Oracle 12 32 bit trick 04 500

Additional fun with Oracle 12c SQL Loader

The 64-bit Oracle 12c client tools also have a small issue with the SQL Loader utility (sqlldr.exe). SQL Loader is not required by SAP BusinessObjects Business Intelligence 4, but I thought I’d document the issue here anyway – “The program can’t start because oranfsodm12.dll is missing from your computer. Try reinstalling the program to fix this problem.”

Oracle 12c SQL Loader Issue

Reinstalling the client tools won’t help because the issue is an Oracle defect, which is described on the Oracle Technology Network. To resolve, make a copy of the oraodm12.dll in the bin directory and rename it to oranfsodm12.dll.

What is your experience with SAP BusinessObjects BI4 and Oracle 12c? Share you thoughts in the comments below.

Author: Dallas Marks

I am a business intelligence architect, author, and trainer. I help organizations harness the power of analytics, primarily with SAP BusinessObjects products. An active blogger, SAP Mentor and co-author of the SAP Press book SAP BusinessObjects Web Intelligence: The Comprehensive Guide, I prefer piano keyboards over computer keyboards when not blogging or tweeting about business intelligence.

Leave a Reply