VariableSubstException Encountered when Running the RCU Installer in Silent Mode (Doc ID 1932432.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle SOA Suite - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

Running the rcu installer in silent mode using the command:

./rcu -silent -createRepository -databaseType ORACLE -dbUser SYS -connectString 'jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<host>)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=XE)(INSTANCE_NAME=XE)))' -dbRole SYSDBA -schemaPrefix DEVBPM -component MDS -tablespace SSP_BPM -tempTablespace TEMP -component IAU -tablespace SSP_BPM -tempTablespace TEMP -component IAU_APPEND -tablespace SSP_BPM -tempTablespace TEMP -component IAU_VIEWER -tablespace SSP_BPM -tempTablespace TEMP -component OPSS -tablespace SSP_BPM -tempTablespace TEMP -component UCSUMS -tablespace SSP_BPM -tempTablespace TEMP -component WLS -tablespace SSP_BPM -tempTablespace TEMP -component STB -tablespace SSP_BPM -tempTablespace TEMP -component SOAINFRA -tablespace SSP_BPM -tempTablespace TEMP -f < passwords.txt

 

The schemas get created but the following errors are reported in rcu.log:

 

2014-10-03 09:12:15.392 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::getParameters: VariableSubstException:
oracle.sysman.assistants.rcu.util.VariableSubstException: Variable DB_HOSTNAME Not Found
at oracle.sysman.assistants.rcu.util.VariableSubstUtil.substituteVariables(VariableSubstUtil.java:129)
at oracle.sysman.assistants.rcu.backend.action.AbstractAction.getParameters(AbstractAction.java:152)
at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:209)
at java.lang.Thread.run(Thread.java:745)
at oracle.sysman.assistants.rcu.backend.action.JavaAction.perform(JavaAction.java:164)
at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:247)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:335)
at java.lang.Thread.run(Thread.java:745)

2014-10-03 09:12:15.393 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::getParameters: VariableSubstException:
oracle.sysman.assistants.rcu.util.VariableSubstException: Variable DB_SERVICE Not Found
at oracle.sysman.assistants.rcu.util.VariableSubstUtil.substituteVariables(VariableSubstUtil.java:129)
...

2014-10-03 09:12:15.393 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::getParameters: VariableSubstException:
oracle.sysman.assistants.rcu.util.VariableSubstException: Variable DB_PORTNUMBER Not Found
at oracle.sysman.assistants.rcu.util.VariableSubstUtil.substituteVariables(VariableSubstUtil.java:129)

2014-10-03 09:12:15.495 INCIDENT_ERROR rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: Failed to execute method:  Excepton:
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
...
Caused by: com.oracle.cie.rcu.ComponentSchemaException: Exception with insert into DEVBPM_STB.COMPONENT_SCHEMA_INFO (SCHEMA_USER,COMP_ID,PREFIX_NAME,DB_HOSTNAME,DB_SERVICE,DB_PORTNUMBER,DATABASE_NAME,STATUS ) values ( 'DEVBPM_MDS','MDS','DEVBPM','%DB_HOSTNAME%','%DB_SERVICE%','%DB_PORTNUMBER%','%DATABASE_NAME%','INITIALIZED')
at com.oracle.cie.rcu.ComponentSchemaUtil.insertCompSchemaInfo(ComponentSchemaUtil.java:170)
...
Caused by: java.sql.SQLException: ORA-12899: value too large for column "DEVBPM_STB"."COMPONENT_SCHEMA_INFO"."DB_PORTNUMBER" (actual: 15, maximum: 10)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
...

 

Note that the same installation in interactive mode works fine without exceptions in the log.

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