Configuring the Oracle Server data warehouse

Windows Make sure that the batch files for setting up the data warehouse run successfully.

About this task

After you have installed the data warehouse, configure it.

Procedure

  1. Create the data warehouse:
    1. Go to the C:\Program Files\IBM\RCPR\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.
      Note: Rational Common Reporting users must enter the default parameters when manually running the scripts.
  2. 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.
  3. Start the listener through the following command:
    lsnrctl start
  4. 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