Walkthrough: Creating the BladeLogic Database for Oracle
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:
Introduction
This topic is intended for system and database administrators preparing to install BSA. You must have access to a database before running the BSA unified product installer or when manually installing BSA.
You have two distinct choices. Use the script to create the tablespaces and user, or create them manually, but do not combine them.
- You can use the create_oracle_instance.sql to create the database user (typically BLADELOGIC) and the BLADELOGIC and BLADELOGIC_INDEX tablespaces and grant privileges to the database user. For more information, see How to use a script to create the Oracle tablespaces and user.
- You can manually set up a database table spaces and database user with the required permissions. Your Oracle environment might require special permissions. You can modify these steps accordingly. For more information, see How to manually set up an Oracle database server and user.
Note
For detailed information, see Setting up an Oracle database for BMC Server Automation.
What does this walkthrough show?
In this walk through, we primarily perform the following tasks:
- Create a table space to hold the the BSA schema
- Create a database user
- Grant the database permissions required to create the BSA schema
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).
What do I need to do before I get started?
For this walkthrough, you must have Oracle database and SQL *Plus installed on the Linux machine you want to use as a database server. Your Oracle environment must be 100% clean, with no existing BSA installations.
How to use a script to create the Oracle tablespaces and user
Run the create_oracle_instance.sql script if you do not want to manually create the tablespaces and user. BMC recommends this approach because it is less prone to error.
Log on to the Linux server you want to use as a database server and perform the following steps:
Step | Commands with examples | |
---|---|---|
1 | Create a bsa directory with the correct permissions to store the table spaces. |
|
2 | Copy the create_oracle_instance.sql script into the directory that you created for the tablespaces. |
|
3 | Change directory to the new bsa directory. where you copied the create_oracle_instance.sql script. | Change directory to the new bsa directory where you copied the create_oracle_instance.sql script. |
4 | Modify the create_oracle_instance.sql script and change the path for data files to match the directory you created for the tablespace for the new schema. Modify the BLADELOGIC user password as needed. | Modify both the As an option, modify the user password, for example, from |
5 | (Optional) If required by your company policy, modify the tablespace privileges. | If required by your company policy, you can modify the create_oracle_instance.sql script to revoke the RESOURCE and UNLIMITED TABLE SPACE privileges, and replace them with more granular privileges.
|
6 | 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. |
7 | Run the script. | Run the create_oracle_instance.sql script by using the following commands: SQL> @/u01/app/oracle/oradata/bsa/create_oracle_instance.sql; SQL> exit |
How to manually set up an Oracle database server and user
If your company policy requires special privileges or you want more granular control, you can manually create the Oracle tablespaces and user.
Log on to the Linux server you want to use as a database server and perform the following steps:
Step | Commands with examples | |
---|---|---|
1 | Create a bsa directory with the correct permissions to store the table space. |
|
2 | 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. |
3 | 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:
|
4 | 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:
|
5 | 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:
For more information about the privileges, see List of required database permissions. |
6 | 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:
|
Wrapping it up
Congratulations. You have successfully set up an Oracle database server. You are now ready to run the unified product installer.
Where to go from here
Walkthrough: Installing on Linux using the unified installer
Comments