OBIA 11g: "ConfigApps.sh" Failed At Step "Configuring ODI" syntax error at line 1: `(' unexpected (Doc ID 2093186.1)

Last updated on JULY 17, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.9.2 and later
Information in this document applies to any platform.

Symptoms

ConfigApps.sh  fails while installing OBIA 11.1.1.9.2 at "Configuring ODI" steps on RAC database. 

Below are the log entries from Install log:


Disconnected from weblogic server: AdminServer
keystore created successfully
at:/t01/ufsdbi/Middleware/user_projects/domains/bifoundation_domain/config/fmw
config/default-keystore.jks
configure_odi: sh: syntax error at line 1: '(' unexpected
configure_odi: Problem invoking WLST - Traceback (innermost last):

Below is the Connect string used for the RAC database while connecting to schema as per Standard Documentation

ed0801-vip:1571:UFSDBI1^ed0802-vip:1571:UFSDBI2@UFSDBI

If single RAC instance is used in the connect string like ed0801-vip:1571:UFSDBI1 instead of ed0801-vip:1571:UFSDBI1^ed0802-vip:1571:UFSDBI2@UFSDBI the installation is successful. But, the purpose of using RAC as underlying database is not fulfilled because it will connect only to node 1 of RAC.

Changes

Internal Bug 21814364 - CONFIGAPPS.SH FAILS WITH ERROR "syntax error near unexpected token '('

Once the installation is completed using single RAC url datasource created at the time of installation will have single RAC instance url. You cannot update db url back with RAC based DB URL .There are few datasources like bip_datasource, mds-owsm which gets created at the time of OBIEE config steps ie after running config.sh file.

While running config.sh RAC connect string was given which had created " multi source " type datasources ,ie there will be three datasources.

bip_datasource
bip_datasource - rac0 ----url pointing to RAC node 1
bip_datasource - rac1 ----url pointing to RAC node 2

But, while running Configapps.sh if single instance RAC connect string is given Generic Datasources are created like odiMasterRepository ,ApplicationLiteDB and thus we cannot create manual multisoure type datasources after installation.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms