VariableSubstException Encountered when Running the RCU Installer in Silent Mode
(Doc ID 1932432.1)
Last updated on AUGUST 12, 2024
Applies to:
Oracle SOA Suite - Version 12.1.3.0.0 and laterInformation 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=<PORT>)))(CONNECT_DATA=(SERVICE_NAME=<SID>)(INSTANCE_NAME=<SID>)))' -dbRole SYSDBA -schemaPrefix <PREFIX> -component MDS -tablespace <NAME> -tempTablespace TEMP -component IAU -tablespace <NAME> -tempTablespace TEMP -component IAU_APPEND -tablespace <NAME> -tempTablespace TEMP -component IAU_VIEWER -tablespace <NAME> -tempTablespace TEMP -component STB -tablespace <NAME> -tempTablespace TEMP -component SOAINFRA -tablespace <NAME> -tempTablespace TEMP -f < passwords.txt
The schemas get created but the following errors are reported in rcu.log:
<TIMESTAMP> 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)
<TIMESTAMP> 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)
...
<TIMESTAMP> 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)
<TIMESTAMP> 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 <SCHEMA>_STB.COMPONENT_SCHEMA_INFO (SCHEMA_USER,COMP_ID,PREFIX_NAME,DB_HOSTNAME,DB_SERVICE,DB_PORTNUMBER,DATABASE_NAME,STATUS ) values ( '<SCHEMA>_MDS','MDS','<NAME>','%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)
...
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)
<TIMESTAMP> 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)
...
<TIMESTAMP> 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)
<TIMESTAMP> 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 <SCHEMA>_STB.COMPONENT_SCHEMA_INFO (SCHEMA_USER,COMP_ID,PREFIX_NAME,DB_HOSTNAME,DB_SERVICE,DB_PORTNUMBER,DATABASE_NAME,STATUS ) values ( '<SCHEMA>_MDS','MDS','<NAME>','%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
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
Symptoms |
Cause |
Solution |