hello,
we have EUS topology running with Oracle Database 11.2.0.4.0, OUD 11.1.2.3.1 and two ODSEE 11.1.1.7.3 backend servers, OUD is running in Proxy mode as Load Balancer with EUS, and ldapsearch to OUD Proxy works perfect and I see the activities both from OUD and ODSEE access logs, no problem here
ldapsearch -h <OUD_HOST> -p <PROXY PORT> -D uid=TCAISIK,ou=people,o=turkcell,dc=entp,dc=tgc -w <USER PW> -b dc=entp,dc=tgc uid=TCAISIK cn
OUD access logs:
[11/Mar/2016:07:56:27 +0200] CONNECT conn=315 from=10.200.115.152:65453 to=10.200.115.186:1389 protocol=LDAP
[11/Mar/2016:07:56:27 +0200] BIND REQ conn=315 op=0 msgID=1 type=SIMPLE dn="uid=TCAISIK,ou=people,o=turkcell,dc=entp,dc=tgc" version=3
[11/Mar/2016:07:56:27 +0200] BIND PROXY_REQ conn=315 op=0 msgID=1 s_conn=65 s_msgid=693 dn="uid=TCAISIK,ou=people,o=turkcell,dc=entp,dc=tgc" s_credmode=use-client-identity type=simple
[11/Mar/2016:07:56:27 +0200] BIND PROXY_RES conn=315 op=0 msgID=1 result=0 s_conn=65 s_msgid=693 etime=8 s_authdn="uid=TCAISIK,ou=people,o=turkcell,dc=entp,dc=tgc"
[11/Mar/2016:07:56:27 +0200] BIND RES conn=315 op=0 msgID=1 result=0 authDN="uid=TCAISIK,ou=people,o=turkcell,dc=entp,dc=tgc" etime=0
[11/Mar/2016:07:56:27 +0200] SEARCH REQ conn=315 op=1 msgID=2 base="dc=entp,dc=tgc" scope=sub filter="(uid=TCAISIK)" attrs="cn"
[11/Mar/2016:07:56:27 +0200] SEARCH PROXY_REQ conn=315 op=1 msgID=2 s_conn=65 scope="sub" s_msgid=694 base="dc=entp,dc=tgc" s_credmode=use-client-identity filter="(uid=TCAISIK)"
[11/Mar/2016:07:56:27 +0200] SEARCH PROXY_RES conn=315 op=1 msgID=2 result=0 s_conn=65 s_msgid=694 etime=4 authzDN=uid=TCAISIK,ou=people,o=turkcell,dc=entp,dc=tgc nentries=1
[11/Mar/2016:07:56:27 +0200] SEARCH RES conn=315 op=1 msgID=2 result=0 nentries=1 etime=0
[11/Mar/2016:07:56:27 +0200] UNBIND REQ conn=315 op=2 msgID=3
[11/Mar/2016:07:56:27 +0200] DISCONNECT conn=315 reason="Client Disconnect"
ODSEE Access log
[10/Mar/2016:18:28:44 +0200] conn=11 op=290 msgId=291 - BIND dn="uid=TCAISIK,ou=people,o=turkcell,dc=entp,dc=tgc" method=128 version=3
[10/Mar/2016:18:28:44 +0200] conn=11 op=290 msgId=291 - RESULT err=0 tag=97 nentries=0 etime=0 dn="uid=tcaisik,ou=people,o=turkcell,dc=entp,dc=tgc"
[10/Mar/2016:18:28:44 +0200] conn=11 op=291 msgId=292 - SRCH base="dc=entp,dc=tgc" scope=2 filter="(uid=TCAISIK)" attrs="cn objectClass"
[11/Mar/2016:07:56:27 +0200] conn=3 op=692 msgId=693 - BIND dn="uid=TCAISIK,ou=people,o=turkcell,dc=entp,dc=tgc" method=128 version=3
[11/Mar/2016:07:56:27 +0200] conn=3 op=692 msgId=693 - RESULT err=0 tag=97 nentries=0 etime=0 dn="uid=tcaisik,ou=people,o=turkcell,dc=entp,dc=tgc"
[11/Mar/2016:07:56:27 +0200] conn=3 op=693 msgId=694 - SRCH base="dc=entp,dc=tgc" scope=2 filter="(uid=TCAISIK)" attrs="cn objectClass"
OUD Proxy and users and groups locations has been configured to work with EUS using ODSM, Oracle Context selected to be used by EUS using "netca" database registered in the ldap server, please check the output below
also all proxy definitions created and defined in the database
no problem so far,
PS: name of the database is "EUS"
ldapsearch -h oudhost -p -D cn=dirmanager -w <pwd> -b cn=oraclecontext,dc=entp,dc=tgc cn=EUS
dn: cn=EUS,cn=OracleDefaultDomain,cn=OracleDBSecurity,cn=Products,cn=OracleCon
text,dc=entp,dc=tgc
objectClass: orclGroup
objectClass: groupofuniquenames
objectClass: orclDBEnterpriseRole_10i
objectClass: orclDBEnterpriseRole
objectClass: orclprivilegegroup
objectClass: top
objectClass: orclDBEnterpriseRole_82
orcldbserverrole: cn=EUS,cn=OracleContext,dc=entp,dc=tgc,GlobalRole=GLOBAL_AQ_ USER_ROLE
uniqueMember: uid=TCAISIK,ou=People,o=Turkcell,dc=entp,dc=tgc
cn: EUS
dn: cn=EUS,cn=OracleContext,dc=entp,dc=tgc
orclVersion: 112000
orclcommonrpwdattribute: {SASL-MD5}Dejg7DJcUIhHmnoIJbg2/Q==
objectClass: orclApplicationEntity
objectClass: orclService
objectClass: orclDBServer_92
objectClass: orclDBServer
objectClass: top
orclServiceType: DB
orclSid: EUS
cn: EUS
orclOracleHome: /export/home/oracle/app/oracle/product/11.2.0/dbhome_1
orclSystemName: pergamumnew
userPassword: {SSHA}oOVPz7gs69xcG/cbCAhQ3nZAGvSnd1r1/M0ZWw==
orclNetDescString: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=pergamumnew.turkcell.tgc)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=EUS)))
orclDBGlobalName: EUS
orclNetDescName: 000:cn=DESCRIPTION_0
but when I try to connect to DB with sqlplus command, I've got error, please check the activity from OUD Proxy access log below
and there is NO activity on OUD Backend (ODSEE) servers
has anyone experienced this problem?
any help or advice highly appreciated
thank you,
pergamumnew:/export/home/oracle> sqlplus tcaisik
SQL*Plus: Release 11.2.0.4.0 Production on Fri Mar 11 07:43:00 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
[11/Mar/2016:08:29:18 +0200] DISCONNECT conn=312 reason="Client Disconnect"
[11/Mar/2016:08:29:20 +0200] CONNECT conn=323 from=10.200.171.42:44803 to=10.200.115.186:1636 protocol=LDAPS
[11/Mar/2016:08:29:21 +0200] BIND REQ conn=323 op=0 msgID=1 type=SASL mechanism=DIGEST-MD5 dn="cn=eus,cn=oraclecontext,dc=entp,dc=tgc" version=3
[11/Mar/2016:08:29:21 +0200] BIND RES conn=323 op=0 msgID=1 result=14 etime=0
[11/Mar/2016:08:29:21 +0200] BIND REQ conn=323 op=1 msgID=2 type=SASL mechanism=DIGEST-MD5 dn="cn=eus,cn=oraclecontext,dc=entp,dc=tgc" version=3
[11/Mar/2016:08:29:21 +0200] BIND RES conn=323 op=1 msgID=2 result=0 authDN="cn=EUS,cn=OracleContext,dc=entp,dc=tgc" etime=0
[11/Mar/2016:08:29:21 +0200] SEARCH REQ conn=323 op=2 msgID=3 base="cn=OracleDBSecurity,cn=Products,cn=OracleContext,dc=entp,dc=tgc" scope=one filter="(&(objectclass=orcldbenterprisedomain_82)(uniqueMember=cn=EUS,cn=OracleContext,dc=entp,dc=tgc))" attrs="orclDBAuthTypes,dn"
[11/Mar/2016:08:29:21 +0200] SEARCH RES conn=323 op=2 msgID=3 result=0 nentries=1 etime=0
[11/Mar/2016:08:29:21 +0200] SEARCH REQ conn=323 op=3 msgID=4 base="cn=Common,cn=Products,cn=OracleContext,dc=entp,dc=tgc" scope=base filter="(objectclass=*)" attrs="ALL"
[11/Mar/2016:08:29:21 +0200] SEARCH RES conn=323 op=3 msgID=4 result=0 nentries=1 etime=0
[11/Mar/2016:08:29:21 +0200] SEARCH REQ conn=323 op=4 msgID=5 base="ou=People,o=Turkcell,dc=entp,dc=tgc" scope=sub filter="(uid=TCAISIK)" attrs="dn,authPassword,orclPassword,orclguid"
[11/Mar/2016:08:29:21 +0200] BIND PROXY_REQ conn=323 op=4 msgID=-1 s_conn=32 s_msgid=-1 dn="cn=EUS,cn=OracleContext,dc=entp,dc=tgc" s_credmode=use-client-identity type=simple
[11/Mar/2016:08:29:21 +0200] BIND PROXY_RES conn=323 op=4 msgID=-1 result=48 s_conn=32 s_msgid=-1 etime=1 s_authdn="cn=EUS,cn=OracleContext,dc=entp,dc=tgc"
[11/Mar/2016:08:29:21 +0200] SEARCH RES conn=323 op=4 msgID=5 result=53 message="A silent authentication operation failed with result code '48'" nentries=0 etime=0