Setting up Oracle for installation
If Oracle 11g or 12c is already installed as a database engine, you need to execute the following before installing the master.
To set the character set to unicode
- In the Database Configuration Assistant select the Character Set tab when the Initialization Parameters window appears.
- Select the Use Unicode (AL32UTF8) radio button.
- In the National Character Set box select the UTF8 value.
To create a database on Oracle v11g or 12c
Create a database for the BMC Client Management before running the installation process. This database can be default named as bcmdb or freely named. The name is requested during the BMC Client Management master installation in the Database Settings dialog box (this applies to Windows platforms only).
To create tablespaces for Oracle v11g or 12c
Before installing the master you must also create a user and the tablespaces for the BCM database. This is done through the execution of scripts delivered with the BMC Client Management installation archive in the Support/Database directory. Proceed as follows:
- Create a new directory under the Oracle installation directory for the tablespaces, for example, Oracle/OraData/BmcClientManagement .
Copy the files Create_User_TS.oracle.bat and Create_User_TS.oracle.sql to the temp directory of the machine on which the BMC Client Management master is to be installed.
- Open a command line window on this machine.
Enter the following command line followed by the ENTER button: Create_User_TS.oracle.bat <System_Password> <Net_Service_Name> <Tablespaces_Path> <DB_User_Name> <DB_User_Password> whereby:
System_Password
is the password to the Oracle system
Net_Service_Name
is the name of the Oracle service
Tablespaces_Path
is the path to the directory in which the tablespaces are located, for example, Oracle/OraData/BmcClientManagement
DB_User_Name
is the name of the Oracle account, with which you connect to the BMC Client Management database
DB_User_Password
is the corresponding password
The tablespaces are now created and you can continue with the master installation.
To remove Oracle identification on the client
The following line must be commented with a hash (#) in the following file to remove the Oracle identification on the Oracle client:
To define language settings on Oracle v11g or 12c
The following settings are required for the NLS_LANG parameter:
- The Oracle parameter NLS_LANG (stored as either an environment variable, or in the registry at HKLM/SOFTWARE/ORACLE/HOME0/NLS_LANG) needs to be set properly. It is of the form "Language"_"Location"."Charset" and Charset needs to be set to AL32UTF8, for example, NLS_LANG=Japanese_Japan.AL32UTF8.
- If your language is not one of the Western European group, the Oracle parameter NLS_LANG (stored as either an environment variable, or in the registry at HKLM/SOFTWARE/ORACLE/HOME0/NLS_LANG) needs to be set properly. It is of the form "Language"_"Location"."Charset" and Charset needs to be set to AL32UTF8, for example, NLS_LANG=Japanese_Japan.AL32UTF8.
To configure database for Linux
- On Linux systems, ensure that the Oracle library libclntsh.so exists on the master in the oracle_home/lib directory of the Oracle client. It is sometimes possible that this library exists under another name, such as libcIntsh.so.9.2. If this is the case, create a symbolic link for libclntsh.so pointing to libcIntsh.so.9.2/. Also, ensure that the directory that contains this file is referenced in the /etc/ld.so.conf file. Any changes to this file require ldconfig to be run for the changes to take effect.
In the the BMCClientManagementAgent file (this file corresponds to the service of BMC Client Management agent) located in the /etc/init.d/ directory, ensure the following entries are listed under the # Some definitions section in this file:
############### ORACLE START########################################
PATH=$PATH:/usr/local/bmc-software/client-management/master/bin
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client
export ORACLE_HOME
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export NLS_LANG
SQLPATH=$ORACLE_HOME/sqlplus
export SQLPATH
PATH=$ORACLE_HOME/bin:$PATH
export PATH
TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN
if [ $?LD_LIBRARY_PATH ]
then
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
else
LD_LIBRARY_PATH=$ORACLE_HOME/lib
fi
export LD_LIBRARY_PATH
############### ORACLE END###########################################