Dynamic Ranges Associated With DHCP Server Are Not Displayed On DHCP Server Page (Doc ID 841438.1)

Last updated on AUGUST 26, 2013

Applies to:

Oracle Communications Policy Services - Version: 6.1.1
This problem can occur on any platform.

Symptoms

Dynamic Ranges associated with the DHCP Server are not seen on the DHCP Server page in Policy Services. This behaviour is seen on only one out of two Production Servers.in this example Analysis done on the LDAP access log shows that this is an LDAP issue. On the primary Production server where the problem was seen, the access log had 0 entires when DHCP Server page was opened, whereas on the secondary server it resulted in 77 entries. An LDAP search query performed on both servers resulted in 0 entries for the primary and 77 on secondary server instance. Further analysis showed that the attribute "mslvDHCPServerRef" when removed from the filter criteria produced 77 entries on primary server.

Changes

Index created to improve performance.

Index file - dhcp_index.ldif
dn: cn=mslvDHCPServerRef, cn=index, cn=userRoot,cn=ldbm database,cn=plugins,cn=config
objectClass: nsIndex
objectClass: top
cn: mslvDHCPServerRef
nsSystemIndex: false
nsIndexType: eq
nsIndexType: pres

dn: cn=mslvAllDHCP, cn=index, cn=userRoot,cn=ldbm database,cn=plugins,cn=config
objectClass: nsIndex
objectClass: top
cn: mslvAllDHCP
nsSystemIndex: false
nsIndexType: eq
nsIndexType: pres

To create and implement an index for the attribute "mslvDHCPServerRef", which is also a filter of the LDAP query:
Add index entries:
1. Using the details above to create the ldif file and redirect it to somewhere on the LDAP server. (/tmp in this example)

2. Go to <ldap>/shared/bin and run: ldapmodify -a -h localhost -p <port> -D "cn=dmanager" -w <password> -f /tmp/dhcp_index.ldif

3. You should see something like:
adding new entry cn=mslvDHCPServerRef, cn=index, cn=userRoot,cn=ldbm database,cn=plugins,cn=config

adding new entry cn=mslvAllDHCP, cn=index, cn=userRoot,cn=ldbm database,cn=plugins,cn=config

Generate indexes:

NOTE: there are 2 indexes and they must generate individually.

1. Go to <ldap>/slapd-<instance> and execute
<ldap>/bin/slapd/admin/bin/perl db2index.pl -v -D cn=dmanager -w <password> -n userRoot -t mslvDHCPServerRef

2. Look at the <ldap>/slapd-<instance>/logs/error file to monitor the indexing progress.

3. When the above index completes, another can be created:
<ldap>/bin/slapd/admin/bin/perl db2index.pl -v -D cn=dmanager -w <password> -n userRoot -t mslvAllDHCP

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms