Creating Oracle databases and setting up the database server
For information about the databases supported for use with BMC Decision Support – Network Automation, see System requirements.
While setting up the databases described in these instructions, record the database parameter values in the ETL Database Configuration row of the Installation worksheet. You are prompted for the database parameter values during the BMC Decision Support – Network Automation installation.
This topic describes how to set up and configure Oracle databases for a BMC Decision Support – Network Automation installation.
To create the Oracle users
- On the database server, create the following users (schemas):
- BCAN_ETL_WORK for the ETL work repository
- BCAN_ETL_MASTER for the ETL master repository
- BCAN_DWH for the data warehouse
If you are creating users with any other names, do not use any special characters in names.
- Ensure that the database users meet the following requirements:
- Database users must be able to log on to the database by using the same SID.
- Database users must have complete control of the databases. Grant the following permissions to these users you just created:
- create tables
- create views
- stored procedures
- log on by using the user credentials (avoid changing the password after the product installation)
To set up the database for Oracle RAC environments
If you are using Oracle Real Application Clusters (RAC), after setting up the BusinessObjects Business Intelligence (BI) server and meeting the requirements for using Oracle RAC (see System requirements), configure the tnsnames.ora file to access the Oracle RAC database server as follows:
- Navigate to the <Oracle_Client_installation_directory>\client_1\network\admin directory.
Locate the tnsnames.ora file and open it for editing.
The file contents looks similar to the following:
<TNS_NAME> = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <HOST_NAME>)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = <SERVICE_NAME>) ) )
- Edit the following variables in the file:
<TNS_NAME>with the service name of your Oracle RAC database instance.
<HOST_NAME>with the Oracle RAC database server host name.
<SERVICE_NAME>with service name of the Oracle RAC database instance.
- Save and close the file.
To set up the database for Oracle database 12c environments
In Oracle database 12c, the default value of the
SQLNET.ALLOWED_LOGON_VERSION parameter has been updated to
11. Therefore, the database clients using pre-11g JDBC thin drivers cannot authenticate to 12c database servers. In order to work with the existing JDBC thin drivers, you need to modify the sqlnet.ora file, as follows:
- On the database server, locate the sqlnet.ora file, as follows:
- (Oracle 12c) ORACLE_HOME\network\admin
- (Oracle 12c RAC) ORACLE_HOME\network\admin and GRID_HOME\network\admin
Open the sqlnet.ora file with a text editor.
Create this file if it does not exist. You can use the sample file located in the ORACLE_HOME\network\admin\sample directory (GRID_HOME\network\admin\sample in case of RAC) to create this file.
- If the following parameters exist in the file, update them. If they do not exist, add them as follows:
- Restart all the database services.
To verify the database server setup
Before beginning the installation, verify that the server has enough space and that it meets the following requirements:
- The database server must be accessible from the reporting and application servers in your deployment.
- The Listener and TNS files must be configured correctly to access the database from the application server through JDBC drivers.
- Ensure that the drivers used by the BusinessObjects Business Intelligence server are compatible with your database setup (see Setting up the reporting server).
- Ensure that there are no port conflicts.