
Deploy the databases for the
Rational® Insight data warehouse.
The sample database is a database file with test data that the installer
places on the system. Restore this sample database to the data warehouse
and use it to test
Rational Insight.
Also, give the report users access to the data warehouse. Add a new
database instance, create listeners for the service, and create a
database service.
About this task
After you have installed the data warehouse feature, configure
it. Steps 1 and 2 are needed only if you chose the manual installation
method for installing the data warehouse.
- Create the data warehouse:
Note: This step is
required if you did chose the manual installation option when you
installed the data warehouse.
- Go to the /opt/ibm/RationalInsight/datawarehouse/dw directory.
- Switch to the root user by running the su command.
If prompted, type the root password.
- Set the permissions for the files and folders by running
the following command:
chown oinstall.oinstall /opt/ibm/RationalInsight/datawarehouse/dw -R
- Return to the database administrator console and run
the install.sh shell script through the following
command:
[oinstall@VEGAVM dw]$ ./install.sh
- 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.
- Restore the sample database to the data warehouse:
Note: This step is needed only if you chose the manual installation
option during the installation procedure.
- Go to the /opt/ibm/RationalInsight/datawarehouse/sampledw directory.
- Switch to the root user by running the su command.
If prompted, type the root password.
- Set the permissions for the files and folders by running
the following command:
chown oinstall.oinstall /opt/ibm/RationalInsight/datawarehouse/sampledw
- Return to the database administrator console and run
the install.sh shell script through the following
command:
[oinstall@VEGAVM sampledw]$ ./install.sh
- 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.
- If you want to manage the database using one of the user
Interface (UI) tools of Oracle Serve, add a database instance. To
do so, modify /etc/oratab by adding the following line: $SID:/$ORACLE_HOME:Y where $SID is
the name of the database you created during the installation and $ORACLE_HOME is
the file path of the database location.
Note: To do the
next few steps, you must log in with a Linux® database
administrator account.
- Create a listener:
- Run the following command: export ORACLE_SID=$SID,
where $SID is the name of the database you created
during the installation.
- Start Oracle Net Manager and run netmgr using
the oinstall account in the Linux console.
- 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 at the Linux console: lsnrctl
start
- Create a 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.