70 views

Description

During Discovery, if an Oracle Listener process is detected with multiple parameters, the first parameter is used as the application name in the CMDB.

Steps to Reproduce

  1. Run Discovery against a host with a running Oracle Listener.

    The Oracle Listener must have more than one parameter in its running process, for example:

    /u01/app/oracle/product/12.1.0/dbhome_1/bin/tnslsnr LISTENER -no_crs_notify -inherit (the parameters are prefixed with a dash)

  2. Check the cmdb_ci_application record for the Oracle Listener.

    The record will be named something like -no_crs_notify@hostname.

 

Workaround

  1. Set the Oracle Listener application with a specific name.

    • To set the Oracle Listener application with the generic name 'Oracle Listener@<host>':

      ---------------------------------------------------------------------------
      //var matches = parameters.match(/^(\S+)\s+.*$/);
      //if (matches)
      // current.name = matches[1] + '@' + g_sensor.deviceGR.name;

      current.oracle_home = command.substring(0, command.indexOf('bin/tnslsnr') - 1);
      g_probe_parameters.listener = 'LISTENER';
      g_probe_parameters.oracle_home = current.oracle_home;
      ---------------------------------------------------------------------------
    • To set the Oracle Listener application with the Listener's name:

      ---------------------------------------------------------------------------
      var matches = command.split(' ');
      if (matches)
      current.name = matches[1] + '@' + g_sensor.deviceGR.name;

      current.oracle_home = command.substring(0, command.indexOf('bin/tnslsnr') - 1);
      g_probe_parameters.listener = matches ? matches[1] : 'LISTENER';
      g_probe_parameters.oracle_home = current.oracle_home;
      ---------------------------------------------------------------------------
  2. Delete the Oracle Listener applications with the incorrect names.

  3. Rediscover the device.

 

 


Related Problem: PRB932917

Seen In

There is no data to report.

Fixed In

Kingston

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2017-08-30 17:35:32
Published:2017-08-31