Preparing your Oracle database before you upgrade
This section describes the steps you should perform with your Oracle database before you install BMC Remedy AR System or any application in the BMC Remedy IT Service Management Suite.
- To prepare your Oracle database
- Setting up a previously created tablespace
- To use a previously created tablespace in BMC Remedy AR System
Typically, Oracle database administrators create instances, directories, and groups, and they install the Oracle database and Oracle client before proceeding with the BMC Remedy AR System installation.
BMC highly recommends that you review Performance tuning for BSM for other recommendations about tuning your Oracle database in preparation for performing this upgrade. This section includes recommendations for:
- Small, medium, or large Oracle databases
- Cursor sharing
- Cost-Based Optimizer
- CLOB storage
- Install at least one instance of the Oracle database. (Only your database administrator can create database instances.)
You can install it on the same computer where the BMC Remedy AR System is installed, or on a remote server that is networked to the computer where you plan to install BMC Remedy AR System.
- Install Oracle clients on the AR System server.
- (UNIX only) Make sure that the administrator who is installing BMC Remedy AR System is a part of the database group.
- Enable the TCP/IP Protocol for the database.
- Confirm connection to your Oracle database.
Contact your database administrator for more information.
- For remote installations, install and configure the Oracle client on the same system where you will install the AR System server.
- Set the BMC Remedy AR System data file size to at least 2 GB.
For each additional product, add at least 2 GB to the data file size.
- Confirm that database parameters listed in the following table and in the Tuning an Oracle server topic are set.
3GB (at least 2 GB)
FORCE (at least SIMILAR). If you set
cursor_sharingto FORCE, you must also update
the ar.cfg file.
0 (or do not set)
3 (512 MB each)
REDO log files
3 (at least 1 GB each)
- Set the tablespace
CanGrowparameter to YES.
- To prevent BMC Remedy AR System from reaching the size limit of the database, set your tablespaces to auto-extend by executing the following SQL statement as the
- Set the table space and temporary table space to at least the following minimum settings:
- To avoid time-out errors during installation, set the System Global Area (SGA) minimum size to at least 1 GB (small database), 3 GB (medium database), or 6 GB (large database).
For Oracle 10g or 11g, BMC Software recommends setting the maximum SGA size and enabling the database to automatically manage the internal memory structures of the SGA.
For example, to change the SGA size to 1 GB, use the
alter system set sga_target=1G scope=bothcommand.
- Verify or set the following environment variables.
Specifies globalization settings. For information about
NLS_LANGand its usage, see the following notes from Oracle: 144808.1, 227330.1, 260192.1. If you are using the Oracle Instant Client, see step 14.
Specifies globalization settings.
Points to the directory where the Oracle client is installed. Use this value: $<ORACLEHOMEDirectoryPath>
The installer accepts the ORACLE_HOME path as a user input on UNIX.
If you are using the Oracle Instant Client, see step 14.
(For Windows) Points to the bin directory of the Oracle client. For example, C:\oracle\product\10.2.0\client_1\bin. The bin directory contains the path to the Oracle binary files. Add the following value to the PATH:$ORACLE_HOME/bin
If you are using multiple versions of Oracle, make sure that the entry for the version you want to use appears before the others.
- When using the Oracle Instant Client, complete the following steps:
- Set the system path to the folder where the Oracle Instant Client is located on the local computer.
- Set the ORACLE_HOME system variable to point to the folder where the Oracle Instant Client is located on the local computer.
- Set the TNS_ADMIN system variable to point to the folder where the correct tnsnames.ora file is located.
By default, the Oracle Net Services configuration files are located in the OracleHome\network\admin directory. To change the default location, you can set the TNS_ADMIN environment variable to the appropriate value (for example, OracleBase\OracleHome\test\admin). The AR System suite installer accepts the value of the Database Client Home Path field only for UNIX installations. If the installer does not find the tnsnames.ora file in dbClientHomePath\network\admin or in the directory specified in TNS_ADMIN, it prompts you to enter the path in the AR System Server Database Information panel. If you provide a valid path, the installer sets the TNS_ADMIN environment variable in the arsystem.sh script. The installer accepts your input and sets the value for TNS_ADMIN only if you have Read permissions on the tnsnames.ora file.
- Set the NLS_LANG system variable value for non-unicode or unicode.
- Create the following soft links that point to libclntsh.so.11.1:
- Create the directory structure as follows: ORACLE_HOME/bin and ORACLE_HOME/lib.
- Configure the tnsnames.ora file to make sure that the service name is the same as the entry name for the server on which you are installing BMC Remedy AR System. For example:
For more information about tnsnames.ora, see your Oracle documentation.
During the installation, you are asked for the database instance name, and it should match the entry in the tnsnames.ora file (for example, MACHINEA).
- Find the Connection Identifier in the tnsnames.ora file (located in $ORACLE_HOME/network/admin folder).
If multiple listeners are configured, locate the correct tnsnames.ora file in the correct $TNS_ADMIN value path.
Following is an example entry in tnsnames.ora:
- Make sure that the Oracle listener is running and is configured correctly for the database.
For a BMC Remedy AR System server, you can use a tablespace that you previously created in Oracle.
If you are using a RAC or ASM Oracle database, you must create tablespaces before installing BMC Remedy AR System. For more information about creating tablespaces in RAC or ASM databases, refer to your Oracle documentation.
- In a SQL*Plus window, create the tablespace and temporary tablespace. For example:
- Create a user. For example:
- Create a role for the user you created in step 2 above. For example:
- Set the privileges for the role. For example:
- Grant the role to the user. For example: