This topic walks you through the process of setting up an Oracle database to be used while installing BMC Server Automation (BSA) on Linux.
Warning
These tasks should be performed by a database administrator (DBA). Perform the steps in the exact order in which they are described.
This topic includes the following sections:
This topic is intended for system and database administrators preparing to install BSA. The goal of this topic is to demonstrate how to use SQL *Plus to set up a database table space and database user with required permissions. You must have access to a database before running the BSA unified product installer or when manually installing BSA.
Note
In this walk through, we primarily perform the following tasks:
When installing BSA using the unified product installer, the installation program automatically populates a database schema. The installer accesses that database using the connection information that is defined in this walkthrough.
If you are installing BSA and its database manually (rather than by using the unified product installer), you can use this procedure to set up a database and then later run the script that populates the database schema for BSA (as described in To manually populate the Oracle database schema (not required if you using the unified product installer).
For this walkthrough, you must have Oracle database and SQL *Plus installed on the Linux machine you want to use as a database server.
Log on to the Linux server you want to use as a database server and perform the following steps:
Step | Commands with examples | |
---|---|---|
1 | Use the command shown on the right to log on to SQL *Plus and connect to the Oracle database. |
Replace the following variables appropriate values, as described below:
You are now connected to your database instance using SQL *Plus. |
2 | Create a table space, which can be used by the unified product installer to set up the BSA Schema. |
Replace the following variables with appropriate values, as described below, as described below:
|
3 | Create a table space to index your BSA schema. Run the command shown on the right in SQL *Plus. |
Replace the following variables with appropriate values, as described below:
|
4 | Create a database user and grant required permissions to the user. Run the commands shown on the right in SQL *Plus, to create the database user and grant required permissions. |
Replace the following variables with appropriate values, as described below:
|
5 | Alter the data files of the BSA schema table space and the Index table space to auto extend. Run the command shown on the right in SQL *Plus. |
Replace the following variables with appropriate values, as described below:
|
Congratulations. You have successfully set up an Oracle database server. You are now ready to run the unified product installer.