My Oracle Support Banner

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 JULY 01, 2019

Applies to:

Oracle Internet Directory - Version 10.1.4.3 and later
Information in this document applies to any platform.

Goal

Oracle Internet Directory (OID) 10g, 11g, 12c or higher.

Enabled OID tracing, or turning on high level debug in OID by setting the following attributes in the OID server (referenced 11g/12c 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=<USER>,cn=users,dc=<COMPANY NAME>,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: <USER>
22:58:26 * INFO * gslbnstStringNorm() Normalized value: <USER>
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: <COMPANY NAME>
22:58:26 * INFO * gslbnstStringNorm() Normalized value: <COMPANY NAME>
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=<USER>,cn=users,dc=<COMPANY NAME>,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=<COMPANY NAME>,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=<USER>,cn=users,dc=<COMPANY NAME>,dc=com
22:58:26 * gslsbpmCGetSubscriberpwdPolicy: Looking for applicable pwdPolicy at cn=users,dc=<COMPANY NAME>,dc=com
22:58:26 * gslsbpmCGetSubscriberpwdPolicy: Looking for applicable pwdPolicy at dc=<COMPANY NAME>,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=<USER>,cn=users,dc=<COMPANY NAME>,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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.