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