oracle Preconfiguration Requirements

This article describes the procedures to follow before you start configuring the oracle probe. Before deploying the oracle probe on your robot, perform the following activities:
uimpga-ga
This article describes the procedures to follow before you start configuring the oracle probe. Before deploying the oracle probe on your robot, perform the following activities:
Add Environment Variables
Add the Oracle libraries in the system PATH environment variable and configure the Oracle client appropriately before installing the oracle probe. You can update the variables by using the controller GUI or by editing the nimbus script at /etc/init.d.
Restart the robot after updating the nimbus script.
Setting the ORACLE_HOME path is mandatory to generate the correct Device ID, routing the QoS messages and alarms to the correct device, and viewing data on the Unified Service Manager (USM).
On Windows platform:
  • Set the ORACLE_HOME path to the directory where the client is installed. For example, C:\oracle\product\11.2.0\client_1.
On UNIX, or AIX platforms:
  1. Set the ORACLE_HOME path to the directory where the client is installed. For example, /home/oracle/app/oracle/product/12.1.0/client_1.
  2. Set the ORACLE_SID to the service identifier name that you configured by using the Oracle client.
  3. Set the LD_LIBRARY_PATH path to the Oracle library directory. 
    , you must also set the LIBPATH path to the Oracle library directory. 
    For example, /home/oracle/app/oracle/product/12.1.0/client_1/lib. 
Security-Enhanced Linux (SELinux) is a mandatory access control (MAC) security mechanism implemented in the Linux kernel. SELinux has three basic modes of operation: Enforcing, Permissive and Disabled. In Permissive mode, SELinux is enabled but does not enforce the security policy, only warns and logs actions. The 
Current Enforcing Mode
 must be 
Permissive
 on Linux platform.
Follow these steps for setting the Current Enforcing Mode to Permissive:
  1. Open SELinux Management and the SELinux Administration window appears.
  2. In the Current Enforcing Mode list, click Permissive.
  3. Close the SELinux Administration window.
Add CDB/PDB Connection Entries
From version 4.8, the oracle probe supports multi-tenancy monitoring. Add CDB/PDB details in the tnsnames.ora file on your system before creating a connection with the database.
You must ensure that the required database details are present in the tnsnames.ora to monitor a CDB, as shown in the example.
CDB1 =
 (DESCRIPTION =
  (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.112.16.128)(PORT = 1521))
  )
  (CONNECT_DATA =
   (SERVICE_NAME = CDB1)
  )
 )
where CDB1 is the service name.
You must add the PDB details to the tnsnames.ora to monitor a PDB, as shown in the example.
PDB1 =
 (DESCRIPTION =
  (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = oracle-cdb)(PORT = 1521))
  )
 (CONNECT_DATA =
   (SERVICE_NAME = PDB1)
  )
 )
where PDB1 is the service name.
Provide Access Rights for a Database User
A non-root probe user must have appropriate access rights to the Oracle database to run the oracle probe for monitoring. Only a root user or a sysdba can grant permissions to the user. 
To grant access rights, connect to the Oracle server as a 
sysdba
 and run the following queries:
create user nimmon identified by nimmon; 
grant connect to nimmon; 
grant select_catalog_role to nimmon;
grant select on gv$sort_segment to nimmon;
grant select on sys.ts$ to nimmon;
For a CDB connection, prefix c## or C## to the user name and grant required permissions to the user.
create user c##nimmon identified by nimmon;
Monitor Oracle RAC
To monitor Oracle RAC with the oracle probe, perform the following tasks:
  • Configure an Oracle RAC connection in the probe.
    Add the scan-ip value in the tnsnames.ora file.
    For example,
    SOMORCL_RAC =
                 (DESCRIPTION =
                              (ADDRESS_LIST =
                                (ADDRESS = (PROTOCOL = TCP)(HOST =
    <oraclerac-scan-ip>
    )(PORT = 1521))
                  )
    (CONNECT_DATA =
                 (SERVER = DEDICATED)
                 (SERVICE_NAME = orcl.com)
                 )
    )
    Replace the 
    oraclerac-scan-ip
    value with the IP address or the host name of the Oracle scan-ip.
  • Define the scan-ip in hosts file.
    In the hosts file on each node, define the scan-ip in the hosts file in order to ensure that alarms and QoS are getting redirected to the correct device on UMP.