
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.
- If the option for automatic execution of scripts was not chosen
when the database server was installed, the installer only creates
batch files to set up the Rational Insight data warehouse,
but does not run them. Run the batch file manually.
- The data warehouse with sample data is a backed up database file
that the installer places on the system. Restore this sample database
to the data warehouse.
- Create the listener and service name.
- Create the data warehouse:
- Go to the C:\Program Files\IBM\Rational Insight\datawarehouse\dw directory.
- Run the install.bat batch file.
- 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.
- Install the data warehouse with sample data:
Note: This
step is optional.
- Go to the C:\Program Files\IBM\Rational Insight\datawarehouse\sampledw directory.
- Run the install.bat batch file.
- 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.
- Create the listener:
- Set system variable:
ORACLE_SID=$SID
where $SID is
the name of the database you created during the installation.
- Start Oracle Net Manager.
- Expand the nodes, select Listeners,
and click .
- Enter a name for the listener and click OK.
- Click Add Address and enter the
host and port.
- From the dropdown list, select Database Services and
click Add Database.
- Enter the global database name, Oracle home directory,
and the name of the database you created during the installation.
- Click .
- Close Oracle Net Manager.
- Start the listener through the following command:
lsnrctl start
- Create the service name:
- Start Oracle Net CA.
- Select Local Net Service Name configuration
and click Next.
- Select Add and click Next.
- Enter a name for the service and click Next.
- Select a protocol and click Next.
- Enter the name of the host and the port.
- Click Yes, perform a test, click Next,
change the logon if necessary, and ensure that the connection is established.
- Close Oracle Net CA.