After Enabling High Level Debug In OID, OID Log Shows: Error : ora -> error 1031 : ORA-01031: insufficient privileges (Doc ID 1313808.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Internet Directory - Version 10.1.4.3 to 11.1.1 [Release 10gR3 to 11g]
Information in this document applies to any platform.

Goal

Oracle Internet Directory (OID) 10g or 11g.

Enabled OID tracing, or turning on high level debug in OID by setting the following attributes in the OID server (referenced 11g Document 1239943.1 / 10g Document 397821.1), for example:

orcldebugflag: 2147483647
orcldebugop: 511


The OID debugged log file afterwards shows an ORA-01031 error, for example:

BEGIN
2011/04/05:22:58:26 * ServerWorker (REG):7
ConnID:34521 * mesgID:63667 * OpID:63666 * OpName:bind
ConnIP:<IP Address> ConnDN: cn=user1,cn=users,dc=mycompany,dc=com
gslarswWorker : INFO : held be->op_lock of type
22:58:26 * gslfbidbDoBind:Entry
22:58:26 * gslfbigciGetControlInfo:Entry
22:58:26 * gslfbigciGetControlInfo:Exit
22:58:26 * INFO * gslbnstStringNorm : String to Normalize: <user1>
22:58:26 * INFO * gslbnstStringNorm() Normalized value: <user1>
22:58:26 * INFO * gslbnstStringNorm : String to Normalize: <users>
22:58:26 * INFO * gslbnstStringNorm() Normalized value: <users>
22:58:26 * INFO * gslbnstStringNorm : String to Normalize: <mycompany>
22:58:26 * INFO * gslbnstStringNorm() Normalized value: <mycompany>
22:58:26 * INFO * gslbnstStringNorm : String to Normalize: <com>
22:58:26 * INFO * gslbnstStringNorm() Normalized value: <com>
22:58:26 * gslbndnWithEscChar: origDN:<cn=user1,cn=users,dc=mycompany,dc=com> NormDn:<cn=user1,cn=users,dc=mycompany,dc=com>
22:58:26 * gsldpstToggleSqlTrace: Error : ora -> error 1031 : ORA-01031: insufficient privileges

22:58:26 * Base Search Sql: SELECT /*+ USE_NL(store) USE_NL(dn) INDEX(store EI_ATTRSTORE) INDEX(dn RP_DN) ORDERED */ store.entryid,AttrName,NVL(AttrVal,' '),attrkind,NVL(attrstype, ' '),NVL(AttrVer,' ') FROM CT_DN dn, ds_attrStore store WHERE (dn.rdn = :szCommonName AND dn.parentdn = :szBaseDomain) AND store.entryid = dn.entryid
22:58:26 * szCommonName = *cn=user1*, szBaseDomain = *dc=com,dc=mycompany,cn=users,
22:58:26 * Base Search Completed with: 100
22:58:26 * Enter: gslsbpmCGetSubscriberpwdPolicy
22:58:26 * gslsbpmCGetSubscriberpwdPolicy: Looking for applicable pwdPolicy at cn=user1,cn=users,dc=mycompany,dc=com
22:58:26 * gslsbpmCGetSubscriberpwdPolicy: Looking for applicable pwdPolicy at cn=users,dc=mycompany,dc=com
22:58:26 * gslsbpmCGetSubscriberpwdPolicy: Looking for applicable pwdPolicy at dc=mycompany,dc=com
22:58:26 * gslsbpmCGetSubscriberpwdPolicy: Looking for applicable pwdPolicy at dc=com
22:58:26 * gslsbpmCGetSubscriberpwdPolicy: Subscriber policy does not exist for this user
22:58:26 * gslsbpmCGetSubscriberpwdPolicy: Root policy will be applied for this user
22:58:26 * Exit: gslsbpmCGetSubscriberpwdPolicy
22:58:26 * Entry: gslsfbsBind()
22:58:26 * Exit: lsbBind()
22:58:26 *             DN = "cn=user1,cn=users,dc=mycompany,dc=com"

22:58:26 * EVENT "DB Fetch " time :       4673  micro sec
22:58:26 * EVENT "Ber flush " time :         41  micro sec
22:58:26 * TOTAL "Operation" time :       5160  micro sec
22:58:26 * INFO : gsleswrASndResult2 RESULT = 0 nentries=0
22:58:26 * Bind Op: <IP Address>, Succ
22:58:26 * gslfbidbDoBind:Exit
END


The user1 shown in the log is able to bind to OID successfully.

What does the ORA-1031 error mean?

Solution

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