Monday, 25 June 2012

Changing Apps Password in EBS, what needs to be done in OID


Changing Apps Password in EBS, what needs to be done in OID

After updating the APPS user password in the E-Business Suite, user updates From OID to Ebiz fail with the following error:

Using Service Name to connect - URL : jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<<<ebs-db-host>>>)(PORT=1571))(CO
NNECT_DATA=(SERVICE_NAME=<<<ebs-db-sid>>>))),user : APPS
Exception Connecting to DB using service name :java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Retrying with SID ..
Using SID Name to connect - URL : jdbc:oracle:thin:@<<<ebs-db-host>>>:1571:<<<ebs-db-sid>>>,user : APPS
Using Service Name to connect - URL : jdbc:oracle:thin:@<<<ebs-db-host>>>:1571:<<<ebs-db-sid>>>,user : APPS
Exception Connecting to DB :java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Update the Oracle Internet Directory provisioning profile with the new APPS password. This can be done by running the Oracle Internet Directory oidprovtool command-line utility.

oidprovtool operation=modify \
profile_mode=INBOUND profile_status=enabled \
ldap_host=<OID Server hostname> ldap_port=<OID Server Port> \
ldap_user_dn="cn=orcladmin" ldap_user_password=<orcladmin Password> \
application_dn="<The LDAP distinguished name of the application>" \
interface_connect_info=<E-Business Suite connect info of the format, host:port:Sid:username: new updated password>

profile_mode = Run the following SQL as the APPS user
SELECT * FROM fnd_user_preferences WHERE preference_name = 'provisiontype';
1 = BOTH             
2 = INBOUND
3 = OUTBOUND    
4 = BOT

application_dn = Run the following SQL as the APPS user
SELECT * FROM fnd_user_preferences WHERE preference_name = 'USERNAME'

interface_connect_info = E-Business Suite connect info of the format, host:port:Sid:username:password

oidprovtool operation=modify \
profile_mode=INBOUND profile_status=enabled \
ldap_host=<<<ldap-host-name>>> ldap_port=3060 \
ldap_user_dn=cn="orcladmin" ldap_user_password=welcome1 \ 
application_dn="orclApplicationCommonName=ebizqa,cn=EBusiness,cn=Products,cn=OracleContext,dc=us,dc=oracle,dc=com" \
interface_connect_info=ebiz30qa:1521:ebizqa:apps:welcome2

orclODIPProfileName=EA3EFF8640819A51F0301990304E5D0B_EA960F743D5D7552F0301990304E34B3, cn=Provisioning Profiles, cn=Changelog Subscriber,cn=Oracle Internet Directory
The Provisioning Profile for the Application has been modified.


No comments:

Post a Comment