Prompt | Explanation |
---|---|
Enter a value of 1 for 10G or 2 for 11G to designate the version of Oracle you are running. | The identifier for your Oracle version. Type 1 for Oracle Database 10g release 2 and 2 for Oracle Database 11g release 1. |
Enter value for ORACLE_HOME | The fully qualified path or your ORACLE_HOME
directory; for example, ![]() ![]() |
Enter value for ORACLE_BASE | The fully qualified path or your ORACLE_BASE
directory; for example, ![]() ![]() |
Enter name [SID] of database to create, maximum length of name is 8 characters | The alias of the database for the data warehouse.
The alias can contain up to 8 letters. In the Rational® Common Reporting samples, the supplied database name is RIDW. |
Enter password for SYS account | The SYS user password of the database. |
Enter password for SYSTEM account | The SYSTEM user password of the database. |
Enter password for SYSMAN account | The SYSMAN user password of the database. |
Enter password for DBSNMP account | The DBSNMP user password of the database. |
Enter user name to create the DBA account | The user name of the database administrator. |
Enter password for this user | The password for the database administrator account. |
Enter schema under which the operational data store will be built | The name of the schema for the operational data
store. The name can contain up to 8 letters. In the Rational Common Reporting samples, the supplied schema name is RIODS. |
Enter schema under which the star schema will be built | The name of the schema for the star schema.
The name can contain up to 8 letters. In the Rational Common Reporting samples, the supplied schema name is RIDW. |
Enter user name that will connect and run the reports | The database users who need to connect to the
database for running and viewing reports. In the Rational Common Reporting samples, the supplied user name is rptuser. |
Enter user password to use for the account that will connect and run the reports | The password for the user account that will connect to the database for running and viewing reports. |
Enter earliest year to populate the date dimension with | The start year for populating the tables. |
Enter latest year to populate the date dimension with | The end year for populating the tables. |
Specify a base directory for the table space files | A fully qualified path where the table space
files will be created and placed; for example, ![]() ![]() |