Configuring the Oracle Server data warehouse

Windows Make sure that the batch files for setting up the data warehouse run successfully. Optionally, restore the data warehouse with the sample data to the data warehouse and use it as your IBM® Rational® Insight data warehouse; the data warehouse with the sample data contains data with which you can test Rational Insight.
About this task
After you have installed the data warehouse, configure it.
  1. Create the data warehouse:
    1. Go to the C:\Program Files\IBM\Rational Insight\datawarehouse\dw directory.
    2. Run the install.bat batch file.
    3. When prompted, specify the parameters for the data warehouse. To see a list of parameters and their explanations, see the related links at the bottom of this page.
  2. Install the data warehouse with sample data:
    Note: This step is optional.
    1. Go to the C:\Program Files\IBM\Rational Insight\datawarehouse\sampledw directory.
    2. Run the install.bat batch file.
    3. When prompted, specify the parameters for the data warehouse with the sample data. To see a list of parameters and their explanations, see the related links at the bottom of this page.
  3. Create the listener:
    1. Set system variable:
      ORACLE_SID=$SID

      where $SID is the name of the database you created during the installation.

    2. Start Oracle Net Manager.
    3. Expand the nodes, select Listeners, and click Edit > Create.
    4. Enter a name for the listener and click OK.
    5. Click Add Address and enter the host and port.
    6. From the dropdown list, select Database Services and click Add Database.
    7. Enter the global database name, Oracle home directory, and the name of the database you created during the installation.
    8. Click File > Save Network Configuration .
    9. Close Oracle Net Manager.
  4. Start the listener through the following command:
    lsnrctl start
  5. Create the service name:
    1. Start Oracle Net CA.
    2. Select Local Net Service Name configuration and click Next.
    3. Select Add and click Next.
    4. Enter a name for the service and click Next.
    5. Select a protocol and click Next.
    6. Enter the name of the host and the port.
    7. Click Yes, perform a test, click Next, change the logon if necessary, and ensure that the connection is established.
    8. Close Oracle Net CA.

Feedback