My Oracle Support Banner

After Migrating From 11g to 12c, OBIS and OBIPS Fail To Start Due To Faulty ODBC.INI File (Doc ID 2245569.1)

Last updated on MAY 03, 2019

Applies to:

Business Intelligence Suite Enterprise Edition - Version and later
Information in this document applies to any platform.


On : version,

OBIS and OBIPS services are down

The issue can be reproduced at will with the following steps:
Upgrade from 11g ( to 12c (, make sure all the services are running and login to weblogic console, EM and console.
1. Back up the instanceconfig.xml file and add some 12c tuning lines per your 12c tuning guide.
2. In EM update the Configuration/Mail smtp, port and email address of sender.
3. Verify in Toad and change in EM: Weblogic Domain/bi (right-click)/Security/Credentials/ (expand)/datasource.biplatform (Edit) for the <BIPLATFORM> password.
4. Copy the odbc.ini and tnsnames.ora files from the 11g system to 12c.
5. Change to the datadirect paths in the 12c odbc.ini file.
6. Copy the 11g userpref_currencies.xml  to 12c.
7. Copy the from 11g to 12c.
8. Restart the 12c server using and




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.