Reference: Oracle Server parameters for creating the databases for the data warehouse

See a list of the parameters, and their explanations, that are needed to manually create the databases for the data warehouse.

Parameters for the data warehouse

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, Windows D:\oracle\product\10.2.0\db_1 or D:\app\Administrator\product\11.1.0\db_1 or Linux /home/oinstall/app/oinstall/product/11.1.0/db_1.
Enter value for ORACLE_BASE The fully qualified path or your ORACLE_BASE directory; for example, Windows D:\oracle or D:\app\Administrator or Linux /home/oinstall/app/oinstall.
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® Insight 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 Insight 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 Insight samples, the supplied schema name is RIDW.

Note: If you specify a name other than RIDW, make sure that the qualified references to the tables and views in the Framework Manager package match the name you specify here for the star schema.
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 Insight 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, Windows C:\DB_Location or Linux /home/oinstall/DB_Location.

Parameters for the data warehouse with sample data

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, Windows D:\oracle\product\10.2.0\db_1 or D:\app\Administrator\product\11.1.0\db_1 or Linux /home/oinstall/app/oinstall/product/11.1.0/db_1.
Enter value for ORACLE_BASE The fully qualified path or your ORACLE_BASE directory; for example, Windows D:\oracle or D:\app\Administrator or Linux /home/oinstall/app/oinstall.
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 Insight samples, the supplied database name is SAMPLEDW.

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 Insight 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 Insight samples, the supplied schema name is SAMPLEDW.

Note: If you specify a name other than SAMPLEDW, make sure that the qualified references to the tables and views in the Framework Manager package match the name you specify here for the star schema.
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 Insight 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.
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, Windows C:\DB_Location or Linux /home/oinstall/DB_Location.

Feedback