OBIA 11.1.1.9.2 ConfigApps.sh Fails at the ODI Configuration Step with Error "Syntax error near unexpected token `('" (Doc ID 2065554.1)

Last updated on SEPTEMBER 02, 2021

Applies to:

Symptoms

configApps.sh fails at the ODI configuration step when using a RAC connect string.
On the installer screen (configApps.sh) it says:

For Application Cluster (RAC) Database use format <HOST1>:<PORT1>:<INSTANCE1>^<HOST2>:<PORT2>:<INSTANCE2>@servicename. However when this format is used, both ODI and Data warehouse Integration configure failed .

install.out:-

Disconystorenected from weblogic server: AdminServer
keystore created successfully at:/u01/app/orabiee/product/fmw/user_projects/domains/bifoundation_domain/config/fmwconfig/default-ke.jks
configure_odi: sh: -c: line 0: syntax error near unexpected token `('
configure_odi: sh: -c: line 0: `/u01/app/orabiee/product/fmw/Oracle_BI1/jdk/bin/java -client -classpath /u01/app/orabiee/product/fmw/Oracle_ODI1/oracledi.sdk/lib/*:/u01/app/orabiee/product/fmw/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/u01/app/orabiee/product/fmw/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/u01/app/orabiee/product/fmw/Oracle_BI1/biapps/lib/bia-odi.jar -Doracle.security.jps.config=/u01/app/orabiee/product/fmw/user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml oracle.apps.bi.odi.provision.ProvisionDataServer DW_FILE jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=<HOST>)(PORT=<PORT>))(ADDRESS=(PROTOCOL=TCP)(HOST=<HOST>)(PORT=<PORT>)))(CONNECT_DATA=(SERVICE_NAME=<SERVICE_NAME>))) PRD_BIA_ODIREPO xxxx BIAPPS_WORKREP biapps xxx /u01/app/orabiee/product/fmw/Oracle_BI1/biapps/etl/data_files/src_files/BIA_11'
configure_odi: Problem invoking WLST - Traceback (innermost last):
configure_odi:   File "/u01/app/orabiee/product/fmw/Oracle_BI1/bifoundation/install/configure_odi.py", line 296, in ?
configure_odi:   File "/u01/app/orabiee/product/fmw/Oracle_BI1/bifoundation/install/configure_odi.py", line 223, in _configureOdiDwIntegration
configure_odi: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
configure_odi: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
configure_odi: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
configure_odi: at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
configure_odi:
configure_odi: java.lang.Exception: java.lang.Exception: DW_FILE data server update failed with return code: 1
configure_odi:
java.lang.Exception: java.lang.Exception: WLST Script task failed with status 1
at oracle.as.install.biapps.biappsconfig.standard.ODIConfigTask.doExecute(ODIConfigTask.java:57)
at oracle.as.install.bi.biconfig.standard.AbstractProvisioningTask.execute(AbstractProvisioningTask.java:70)
at oracle.as.install.bi.biconfig.standard.StandardProvisionTaskList.execute(StandardProvisionTaskList.java:66)
at oracle.as.install.bi.biconfig.BIConfigMain.doExecute(BIConfigMain.java:113)
at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:375)
at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:88)
at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:105)
at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15)
at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:96)
at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:186)
at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:81)
at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:86)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.Exception: WLST Script task failed with status 1
at oracle.as.install.bi.biconfig.standard.WLSTScriptTask.doExecute(WLSTScriptTask.java:119)
at oracle.as.install.biapps.biappsconfig.standard.ODIConfigTask.doExecute(ODIConfigTask.java:55)
... 12 more

Cause

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