ORA-28047: Database is not a Member of any Enterprise Domain in OID (Doc ID 333405.1)

Last updated on JUNE 17, 2012

Applies to:

Advanced Networking Option - Version 10.1.2 to 11.2.0.3 [Release 10.1 to 11.2]
Information in this document applies to any platform.

Symptoms

Enterprise users get the following error when attempting to log into the database:

ORA-28047: database is not a member of any enterprise domain in OID

-------------------------------

An OID trace reveals the database is accessing  a second realm.

In the OID trace example below, the database (n101) is registered with the realm "dc=fl,dc=oracle,dc=com". The last trace event  reveals a search attempt in a second realm "dc=us,dc=oracle,dc=com".

==============================
BEGIN 2005/09/07:10:55:42 * ServerWorker:4 * ConnID:94 * OpId:0 * OpName:bind
INFO : gslfbiADoBind *  Version=3 BIND dn="cn=n101,cn=oraclecontext,dc=fl,dc=oracle,dc=com" method=163
        ConnId = 94, op=0, IpAddr=138.1.88.111
10:55:42 * INFO : gslfrsASendLdapResult2 RESULT = 14 nentries=0
10:55:42 * INFO : gslfrsASendLdapResult2 RESULT = 0 nentries=0
END

BEGIN
2005/09/07:10:55:42 * ServerWorker:4 * ConnID:94 * OpId:1 * OpName:search
INFO :gslfseADoSearch BASE = cn=OracleDBSecurity,cn=Products,cn=OracleContext,dc=fl,dc=oracle,dc=com FILTER = (& (objectclass=orcldbenterprisedomain)(uniquemember=cn=n101,cn=oraclecontext,dc=fl,dc=oracle,dc=com)) #REQDATTR =1 scope =1
10:55:42 * INFO : gslfrsDSendSearchEntry : Exit
10:55:42 * INFO : gslfrsASendLdapResult2 RESULT = 0 nentries=1
END

BEGIN
2005/09/07:10:55:42 * ServerWorker:4 * ConnID:94 * OpId:2 * OpName:search
INFO :gslfseADoSearch BASE = cn=N101,cn=OracleContext,dc=fl,dc=oracle,dc=com FILTER = (objectclass=*) #REQDATTR= 1 scope =0
10:55:42 * INFO : gslfrsDSendSearchEntry : Exit
10:55:42 * INFO : gslfrsASendLdapResult2 RESULT = 0 nentries=1
END

BEGIN
2005/09/07:10:55:42 * ServerWorker:4 * ConnID:94 * OpId:3 * OpName:search
INFO :gslfseADoSearch BASE = cn=OracleDBSecurity,cn=Products,cn=OracleContext,dc=us,dc=oracle,dc=com FILTER = (& (objectclass=orcldbenterprisedomain_82)(uniquemember=cn=n101,cn=oraclecontext,dc=us,dc=oracle,dc=com)) #REQDATTR = 2 scope =1
10:55:42 * INFO : gslfrsASendLdapResult2 RESULT = 0 nentries=0
END

==============================

Changes

This problem may occur when an enterprise user attempts to log into a database that  has been un-registered from one realm and  registered with another.

 

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