Preparing to install BMC ProactiveNet Server and BMC ProactiveNet Central Server on a Linux computer

This topic explains the steps that you must perform to prepare your Oracle database on Linux hosts for the BMC ProactiveNet Central Server and BMC ProactiveNet Server products installations.

Before you begin

Before you prepare your database for installing the BMC ProactiveNet Central Server and BMC ProactiveNet Server products, perform the following steps:

1. Ensure that you dedicate one Oracle database instance each exclusively for one installation of BMC ProactiveNet Server and one database instance for BMC ProactiveNet Central Server respectively.
2. From the <Applications/BPPMServer/Common> subdirectory under you installations folder, copy the Utilities.zip file to the server that hosts the database for the BMC ProactiveNet Central Server and BMC ProactiveNet Server products.
3. Extract the zip file.
   The zip file contains the database scripts that you need to run to configure your Oracle database for the BMC ProactiveNet installations.

To specify the installer to create a tablespace and tablespace user during the installation

When you begin installing BMC ProactiveNet Central Server and BMC ProactiveNet Server, you can instruct the BMC Cloud Lifecycle Management Installer to create an Oracle tablespace and tablespace user for the products. Before you begin the product installation, perform the following steps to configure the required database parameters for the installation:

1. Log on with sys permissions as shown in the following code:

    sqlplus sys/SYS_PASSWORD@ORACLE_SID as sysdba 

2. Run the database script as shown in the following code:

    sql$ @set_system_parameter_oracle_pnet.sql 

   The script then prompts you to back up the database. BMC recommends that you back up the database to resolve any possible issues with the installation.
3. Press Enter to restart the database.

To configure your database to use a pre-created tablespace and tablespace user

Perform the following steps to pre-create Oracle tablespace and user on your Linux host:

1. On the computer where you installed the Oracle database, type sqlplus at the command prompt to connect to your database and set the following environment variables:
   • For Oracle RAC, type the following code:

     
     $ . oraenv
     ORACLE_SID = oracle ? <RAC_ORACLE_SERVICE_NAME>
     The Oracle base remains unchanged with value /data1/app/oracle/product
     

   • For standalone database, type the following code:

     
     $ . oraenv
     ORACLE_SID = [oracle] ? <ORACLE_SID>
     

2. Log on with sys permissions as shown in the following code:

   
   $ sqlplus sys/<sys_pwd>@<ORACLE_SID> as sysdba
   $ sqlplus sys/Asimil8@orcl as sysdba  OR
   $ sqlplus sys/bmcAdm1n@ora11g as sysdba
   

3. Run the database script as shown in the following code:

   
   SQL> @"/usr/oracle/custom_db_scripts_pnet/run_oracle_db_scripts.sql"
   

   
   
   When you run the script, you are prompted to create the tablespace and user, and to set database and parameters in Oracle.