
Deploy the databases for the
Rational® Common Reporting 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 is needed only if you chose the manual installation method
for installing the data warehouse.
Procedure
- 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/RCPR/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/RCPR/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.
Note: Rational Common Reporting users must enter the default parameters when manually
running the scripts.
- 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.