Various files for the BI Server contain configuration information: odbc.ini and tnsnames.ora. The odbc.ini file contains non-Oracle data source (DSN) connection information. The tnsnames.ora file contains network service names mapped to connect descriptors for the local naming method, or net service names mapped to listener protocol addresses. You must examine these 11g files and manually copy the configuration information to the respective 12c files.
To migrate the BI Server configuration details:
- View the BI Server information in the 11g odbc.ini file present at the following location:
On UNIX operating system:
$11g_DOMAIN_HOME/config/fmwconfig/bienv/core
On Windows operating system:
%11g_DOMAIN_HOME%\config\fmwconfig\bienv\core
- Copy the BI Server configuration from the 11g odbc.ini file to the 12c file.
- Copy the contents from the 11g tnsnames.ora file present at the following location to the 12c file and make the 12c-related changes:
On UNIX operating system:
$11g_DOMAIN_HOME/config/fmwconfig/bienv/core
On Windows operating system:
%11g_DOMAIN_HOME%\config\fmwconfig\bienv\core