Setting up Oracle for installation
The following Oracle versions are supported for Windows and Linux platforms:
- 11.2.0.2 with 10.2.0.4, 10.2.0.5 or 11.2.0.2 client
- 11.2.0.3
- 12c Release 1 (12.1.0.2)78u78
- 18c, 19c
Note
Make sure your Oracle client has the same architecture as the BMC Client Management agent (x86 or x64); otherwise, the BMC Client Management agent cannot communicate with the database.
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.
To create tablespaces on a Linux server, use the Create_User_TS.oracle.sh file. On a Windows server, use the Create_User_TS.oracle.bat file.
- 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:
file: sqlnet.ora line: SQLNET:AUTHENTICATION_SERVICES=(NTS)
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 aslibcIntsh.so.9.2
. If this is the case, create a symbolic link forlibclntsh.so
pointing tolibcIntsh.so.9.2/
. Also, ensure that the directory that contains this file is referenced in the /etc/ld.so.conffile. Any changes to this file requireldconfig
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###########################################
Notes
- The PATH, ORACLE_HOME and NLS_LANG entries might need to be changed to match the path where BMC Client Management is installed, the path where Oracle is installed, and the NLS_LANG defined for the Oracle database respectively.
- If BMC Client Management agent is already running, you can use the
serviceBMCClientManagementAgentstop
andserviceBMCClientManagementAgentstart
commands to respectively stop and start the agent before making the above changes.
Comments
On Linux Server we should use Create_User_TS.oracle.sh file for creating tablespaces. (.sh file)
Could you add note under section : To create tablespaces for Oracle v11g or 12c, On Linux Server we should use Create_User_TS.oracle.sh
On windows server we can go with mentioned Create_User_TS.oracle.bat (batch) file.
Thanks, Sai! I have added the note.
Log in or register to comment.