Configuring the Oracle Server data warehouse

Linux 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.
  1. Create the data warehouse:
    Note: This step is required if you did chose the manual installation option when you installed the data warehouse.
    1. Go to the /opt/ibm/RationalInsight/datawarehouse/dw directory.
    2. Switch to the root user by running the su command. If prompted, type the root password.
    3. Set the permissions for the files and folders by running the following command:
      chown oinstall.oinstall /opt/ibm/RationalInsight/datawarehouse/dw -R
    4. Return to the database administrator console and run the install.sh shell script through the following command:
      [oinstall@VEGAVM dw]$ ./install.sh
    5. 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. 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.
    1. Go to the /opt/ibm/RationalInsight/datawarehouse/sampledw directory.
    2. Switch to the root user by running the su command. If prompted, type the root password.
    3. Set the permissions for the files and folders by running the following command:
      chown oinstall.oinstall /opt/ibm/RationalInsight/datawarehouse/sampledw
    4. Return to the database administrator console and run the install.sh shell script through the following command:
      [oinstall@VEGAVM sampledw]$ ./install.sh
    5. 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.
  3. 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.
  4. Create a listener:
    1. Run the following command: export ORACLE_SID=$SID, where $SID is the name of the database you created during the installation.
    2. Start Oracle Net Manager and run netmgr using the oinstall account in the Linux console.
    3. Expand the nodes, select Listeners, and click 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.
  5. Start the listener through the following command at the Linux console: lsnrctl start
  6. Create a 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