Troubleshooting
Problem
The installation script for the Rational Open Data Access database for IBM Rational Portfolio Manager on Oracle fails with Oracle error ORA-01119 when executing it for the first time.
Symptom
When installing Rational Open Data Access on Oracle for the first time, the script will fail with error ORA-01119.
Cause
The create_rpm_roda_tb_spaces.sql script called by the installation does not specify the size of the tablespaces.
Environment
This problem occurs on Oracle 10g 10.2.0.4 and Rational Portfolio Manager - Open Data Access delivered with Rational Portfolio Manager 7.1.1.2 iFix 004.
Resolving The Problem
This defect is fixed in Rational Portfolio Manager 7.1.1.2 iFix 009.
WORKAROUND:
To resolve the problem, modify the create_rpm_roda_tb_spaces.sql script in the installation package to specify an initial size for each of the tablespaces.
For example:
Original entry in the create_rpm_roda_tb_spaces.sql script:
<code>
CREATE TEMPORARY TABLESPACE TEMPSPACEDW32K TEMPFILE '${rpm_database_roda_tablespace_dir}tempspaceStag32k.dbf' REUSE AUTOEXTEND ON UNIFORM SIZE 2M;
</code>
This entry must be changed to the following:
<code>
CREATE TEMPORARY TABLESPACE TEMPSPACEDW32K TEMPFILE '${rpm_database_roda_tablespace_dir}tempspaceStag32k.dbf' SIZE 512M REUSE AUTOEXTEND ON UNIFORM SIZE 2M;
</code>
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21397774